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