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.
CONTENT AND OBJECTIVES:
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.
The DATA Step
Read a raw data file column input.
Print the data in order by column.
Select specified records and reprint.
Sort data using multiple VARs.
The VARs both will be in ascending and descending order.
Submitting SAS Jobs
Understanding the JCL associated with SAS execution.
Code JCL statements to use and create datasets.
Determining the location of the printout after execution.
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.
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.
SAS Language Statements
Perform editing and extraction of the input data.
Extract sample data 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.
Reshaping Data for SAS
Code a DATA step method for reshaping the output dataset into a more readable tabular format.
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.
Other SAS Features
Reformat SSN:Social Security number, 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.
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.
Advanced Input Features
Read data files that have multiple observations on one line and multiple lines for a single observation.
Custom Output and Reports
Writes lines to an external file that is specified in the most recent FILE statement.
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.
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.
SAS Language Features
Examination of the other SAS PROCS.
Demonstration of other SAS products.
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.