SAS Base Programming Training

·      Use the SORT Procedure to re-order observations in place or output to a new dataset.

·      Practical Exercise              

·      Use IF-THEN/ELSE statements to process data conditionally.

·      Use DO and END statements to execute multiple statements conditionally.

·      Practical Exercise              

·      Create new variables and assign a value.

·      Assign a new value to an existing variable.

·      Assign the value of an expression to a variable.

·      Assign a constant date value to a variable.

·      Practical Exercise              

·      Change the names of variables by using the RENAME= data set option.

·      Use LABEL and FORMAT statements to modify attributes in a DATA step.

·      Define the length of a variable using the LENGTH statement.

·      Practical Exercise              

·      Use the BY statement to aggregate by subgroups.

·      Practical Exercise              

·      Use SAS functions such as SCAN, SUBSTR, TRIM, UPCASE, and LOWCASE to perform tasks such as the tasks shown below.

·      Replace the contents of a character value.

·      Trim trailing blanks from a character value.

·      Search a character value and extract a portion of the value.

·      Convert a character value to upper or lowercase.

·      Use SAS arithmetic, financial, and probability functions to create or modify numeric values by using the INT and ROUND functions.

·      Create SAS date values by using the functions MDY, TODAY,DATE, and TIME.

·      Extract the month, year, and interval from a SAS date value by using the functions YEAR, QTR, MONTH, and DAY.

·      Perform calculations with date and datetime values and time intervals by using the functions INTCK, INTNX, DATDIF and YRDIF.

·      Practical Exercise              

·      Explain the automatic conversion that SAS uses to convert values between data types.

·      Use the INPUT function to explicitly convert character data values to numeric values.

·      Practical Exercise              

·      Explain how iterative DO loops function.

·      Use DO loops to eliminate redundant code and to perform repetitive calculations.

·      Use conditional DO loops.

·      Use nested DO loops.

·      Practical Exercise              

·      Use PROC FREQ to list unique values, with the nlevel option to show the number of distinct values, with the order=freq to check for duplicate or missing values.

·      Use PROC PRINT with the WHERE statement to display observations with invalid values.

·      Use PROC MEAN to validate the range of numeric variables.

·      Use PROC UNIVARIATE to display extreme observations and missing values and with the ID statement to display the value of identifying variable

·      Practical Exercise              

·      Modify the default behavior of PROC PRINT by adding statements and options such as

·      Use the VAR statement to select and order variables.

·      Calculate totals with a SUM statement.

·      Select observations with a WHERE statement.

·      Use the ID statement to identify observations.

·      Use the BY statement to process groups.

·      Practical Exercise              

·      Produce one-way and two-way frequency tables with the FREQ procedure.

·      Enhance frequency tables with options.

·      Use PROC FREQ to validate data in a SAS data set.

·      Calculate summary statistics and multilevel summaries using the MEANS procedure

·      Enhance summary tables with options.

·      Identify extreme and missing values with the UNIVARIATE procedure.

·      Practical Exercise              

·      Use the LABEL statement to define descriptive column headings.

·      Control the use of column headings with the LABEL and SPLIT=options in Proc Print output.

·      Practical Exercise              

·      Identify the Output Delivery System destinations.

·      Create HTML, PDF, RTF, and files with ODS statements.

·      Use the STYLE=option to specify a style template.

·      Create files that can be viewed in Microsoft Excel.

·      Practical Exercise              

·      Use the PUTLOG Statement in the Data Step to help identify logic errors.

·      Use PUTLOG to write the value of a variable, formatted values, or to write values of all variables.

·      Use PUTLOG with Conditional logic.

·      Use temporary variables N and ERROR to debug a DATA step.

·      Practical Exercise              

·      Identify the characteristics of SAS statements.

·      Define SAS syntax rules including the typical types of syntax errors such as misspelled keywords, unmatched quotation marks, missing semicolons, and invalid options.

·      Use the log to help diagnose syntax errors in a given program.

·      Practical Exercise              

·      Given a SAS program, use the log to determine the reason for a data error.

·      Practical Exercise