" /> Advanced SAS Programming | Compu21

Setup Menus in Admin Panel


Setup Menus in Admin Panel

Advanced SAS Programming

Advanced SAS Programming Querying SAS Data Sets Using the SAS Structured Query Language Calculate new columns in a query. Eliminate …


    Advanced SAS Programming

    Querying SAS Data Sets Using the SAS Structured Query Language

    • Calculate new columns in a query.
    • Eliminate duplicate rows from being returned in query results.
    • Subset data in a query.
    • Order data in a query.
    • Summarize data in a query using functions.
    • Use subqueries to subset data based on values in other tables.
    • Combine data sets in a query.
    • Assign an alias to a table.
    • Compare solving a problem using the SQL procedure versus using traditional SAS programming.
    • Create and use an SQL view.
    • Update and delete data values in a table.

    Designing, Writing and Debugging Macro-based Systems Using the SAS Macro Facility

    • Understand the default flow (i.e. tokenization, compilation and execution) of a SAS program and how the macro processor affects program flow.
    • Create and reference macro variables.
    • Display the value of a macro variable.
    • Use macro functions.
    • Combine macro variable references with text.
    • Create macro variables during the execution of the DATA step.
    • Reference macro variables indirectly.
    • Obtain a macro variable value during execution.
    • Define and call macro programs.
    • Use macro level statements to control processing within a macro program.
    • Process code conditionally within a macro program.
    • Describe where macro variables and their values are stored.

    Using Advanced Programming Techniques for Improving SAS Program Efficiency

    • Use basic techniques for improving the performance of BASE SAS programs.
    • Reduce the space required to store values in SAS data sets.
    • Create and use DATA step views.
    • Create and maintain simple and composite indexes.
    • Understand when the SAS System uses an index to retrieve data and when it does not.
    • Use the MODIFY statement in a DATA step.
    • Use statements, such as REPLACE, in conjunction with the MODIFY statement, to control the update process.
    • Use automatic variables to monitor the process of updating a SAS data set.
    • Create, use, document, and store permanent formats.
    • Use control data sets in the FORMAT procedure.
    • Load an array from a SAS data set.
    • Understand the concept of a SAS sort flag and how it is used.
    • Use various sort options.
    • Use appropriate options to handle data that is grouped but not sorted.
    • Compare variables and observations from two data sets.

    Designing and Creating Text Reports

    • Select the appropriate SAS report-writing tool.
    • Organize data to simplify report writing.
    • Understand the components of COLUMN and DEFINE statements.
    • Use stored report definitions to produce REPORT procedure output.
    • Modify the default ordering sequence in reports produced using the REPORT procedure.
    • Compute new columns in the REPORT procedure.
    • Create subtotals using the REPORT procedure.
    • Create grand totals using the REPORT procedure.
    • Control the appearance of report pages using system options and REPORT procedure options.
    • Add titles and footnotes to reports.
    • Understand column usage types in the report procedure.
    • Stack column data in reports.
    • Span multiple columns with one column header.
    • Use a column alias in the REPORT procedure.
    • Create one-, two-, and three-dimensional tables using the TABULATE procedure.
    • Enhance reports created using the TABULATE procedure.
    • Calculate percentages, using the TABULATE procedure.
    • Produce simple reports using FILE and PUT statements in the DATA step.
    • Produce multiline reports.
    • Calculate summary statistics using the MEANS procedure and the SUMMARY procedure.
    • Produce multilevel summary reports using the MEANS procedure.

    Designing and Creating Graphic Reports Using SAS/GRAPH Software

    • Enhance graphics output.
    • Plot values of two variables on an X and Y axis plot.
    • Apply interpolation techniques to plots.
    • Add a second vertical axis to plots.
    • Customize plot axes.
    • Control features of default legends using LEGEND statements.
    • Set and modify graphics options.
    • Produce bar, block, and pie charts.
    • Group and subgroup charts.
    • Label sections in pie charts.
    • Understand the structure of map data sets.
    • Understand the relationship between map data sets and response data sets.
    • Produce choropleth, block, and prism maps.
    • Understand how Annotate data sets store graphics commands.
    • Draw and label reference lines.
    • Annotate output from SAS/GRAPH procedures using different frames of reference.
    • Label the lines on plots using the ANNOTATE facility.

    Course Reviews

    No Reviews found for this course.

    • 10 Days

    Advanced Course Search Widget

    Popular Courses

    Recent Posts