Technology Driven IT Training Longstanding IT Technologists Computer Education Techniques
Distance-learning - SAS: Programming

Home

distance-learning center

Computer-Device_Tethered-Distance-learning Distance-learning-Building

Professional Distance-learning

IT Training Services



MFSYS84

SAS: Programming
DURATION: 5 days

FEE: $2,475

PRIVATE GROUP FEE: $
Based upon a class size of six students.

Scheduling can be adjusted to employee work hours and incorporate client assignments.

SMALL CLASS SIZE:
There is a surcharge associated with training two or fewer students.

AUDIENCE:

  • Business Professional
  • Statistician
  • Report Designer
  • Programmer
  • IT Professional
 
   

DATES:

CONTENT AND OBJECTIVES:
    1. Getting Ready to Use SAS
      • Read and print a simple file.
      • Use a DATA and PROC PRINT step.
      • z/OS: Code the JCL to syntax check and execute the code.
    2. The DATA Step
      • Read a raw data file column input.
      • Print the data in order by column.
      • Select specified records and reprint.
    3. SAS PROCS
      • Sort data using multiple VARs.
      • The VARs both will be in ascending and descending order.
    4. Submitting SAS Jobs - z/OS:
      • Understanding the JCL associated with SAS execution.
      • Code JCL statements in order to use and create datasets.
      • Determining the location of the printout after execution.
    5. Plotting and Bar Charts
      • Use the PROC PLOT to code and test a program that plots the values of two variables for each observation in an input SAS dataset.
      • Display the results on a printer.
      • Exclude observations with missing values.
    6. Simple Statistics
      • Code and test code to compute descriptive statistics for variables within groups of observations.
      • Calculate separate statistics for each BY group.
      • Create an output dataset that contains specified statistics and identification variables.
    7. SAS Language Statements
      • Perform editing and extraction of the input data.
      • Extract a data sampling from the input.
      • Perform transformations or create new variables.
      • Run the data procedure and create a temporary data file.
      • Run it again and keep a permanent copy.
      • Print descriptive statistics for the variables.
      • Select rows and variables to be included in a SAS Dataset.
      • Specify and format a date.
    8. Reshaping Data for SAS
      • Code a DATA step method for reshaping the output dataset into a more readable, tabular format.
    9. What Can Go Wrong
      • The instructor will provide three programs. Identify the issues and problems that have resulted from executing the programs.
      • Problems include maintenance issues, naming conventions, syntax error, logic problems and invalid output data.
    10. Other SAS Features
      • Manually reformat SSN, phone numbers, and dates using character manipulation.
      • Convert numeric, dates, and character fields.
      • When editing the program, it will be necessary to select data for the correct month and print the correct title.
      • Implement a more efficient and less error prone method by using the %LET to create a macro variable.
      • Change the value of the macro variable in the %LET statement; SAS will repeat the new value throughout the program.
    11. Advanced Language Features
      • Create a file where each record contains 24 values with the temperatures for each hour of the day.
      • The temperatures will need to be converted from Fahrenheit to Celsius values.
      • Use an array to perform the calculation on each of the 24 values.
    12. Advanced Input Features
      • Read data files that have multiple observations on one line and multiple lines for a single observation.
    13. Custom Output and Reports
      • Writes lines to an external file that is specified in the most recent FILE statement.
    14. Statistical Analysis
      • Print computes the Pearson correlation used to calculate coefficients parametric measure of a linear relationship between two variables.
      • Specify the singularity criterion for the execution.
    15. More on SAS Datasets
      • Copy a SAS dataset using the DATA and SET statements to perform a simple reading and writing of a separate single observation to either an existing or new dataset.
      • Copy a SAS dataset using the COPY procedure; the associated indexes also will be copied.
    16. SAS Language Features
      • Examination of the other SAS PROCS.
      • Demonstration of other SAS products.

 
 
    Web-based Training   Blended Learning    
Synchronous
Instruction
Asynchronous
Instruction
 

 

Effective February 27, 2012, the course dates listed on the SYS-ED schedules only will be available based upon approved and authorized user ID.

Copyright Acknowledgement: The software product(s) listed in this outline are owned and copyrighted by their respective companies. SYS-ED makes no representation regarding ownership in any of the software products that we train on.

SYS-ED courses are not intended for or open to the general public. They are intended for employees of Fortune 1000 companies, government municipalities, consulting companies, software, companies, healthcare providers. and mid-sized businesses. Individuals attending such courses will be required to execute a statement acknowledging that the employer will be paying for the SYS-ED course and that the employer has a licensed version of the software.