sas certification for base programming
download pdf
xprogramming i : sas essentials
1.1 sas system basics
• accessing the sas system
• navigating through the sas windows including the editor, log, and output
windows
• creating and executing sas programs in batch and interactive mode
• understanding errors in the sas log
• exploring program output
• understanding sas data set and library structure
• creating data and proc steps
• understanding sas syntax and sas naming conventions
• working with temporary and permanent sas data sets
1.2 creating reports
• using the report procedure
• creating reports in a wysiwyg interactive environment without code
• creating reports in a batch environment with code and nowd
• using column, define, and compute statements for structure
• using ods to generate html, rtf and xml reports.
• using report options such as width=, format=, display, group, headline
and headskip
• summarizing and sorting reports
• adding titles, footnotes and labels to reports
• using the print procedure
• selecting report columns with the var statement
• grouping reports with the by statement
• summing report columns with the sum statement
• producing frequency tables using the freq procedure
1.3 creating graphs
• producing vertical and horizontal bar charts with the gchart procedure, vbar
and hbar statements
• understanding chart variables
• using run-group processing for multiple graphs in the same session
• understanding options to tailor graphs, such as discrete, sumvar=, and type=
1.4 reading sas data sets
• reading data sets with the set statement
• restricting data set size by selecting variables with drop= and keep= options
• using if-then/else logic processing
• understanding the difference between subsetting if and where clause processing
to restrict observations
1.5 creating sas data sets
• reading raw data using list, column and pointer input
• naming variables
• understanding how to read any type of data using sas informats
• using infile and input statements to read raw data
• examining the structure of a sas data set and its variables' attributes using the
contents procedure
• creating new variables using sas functions and assignment statements
1.6 recoding and reorganizing data
• using sas formats to recode data values for better presentation in reports and
analyses
• using the format procedure to create user defined value labels
• reordering rows of data with the sort procedure
1.7 summarizing your data
• calculating descriptive statistics with the means and summary procedures
• grouping data using the class statement
• analyzing data values using the var statement and appropriate functions such as
sum, mean, median and more
• generating one-way and multi-way frequency tables using the freq procedure
• using the tables statement in the freq procedure to specify analysis structure
1.8 combining sas data sets
• concatenating sas data sets using the set statement
• merging multiple sas data sets on common key variables
• using the sql procedure
• comparing methods of merging (joining) data sets
programming ii: data manipulation using the data step
2.1 understanding the data step
• understanding the difference between compile and execute phases of the data
step
• learning about data step storage areas
• reading and creating multiple sas data sets
2.2 how to debug your program
• learning to dump the input buffer and program data vector with the put
statement
• using the interactive debugger to understand program logic problems
2.3 reading external data types and creating flat file basics
• reading flat files using delimiters
• reading data from a relational database
• creating user defined informats for special data
• creating flat files in sas
2.4 creating new variables and adding value to your data
• cleaning existing data
• assigning new character, numeric and date variables
• using picture statements to create user defined formats
2.5 combining data files using a match merging and interleaving
• match merging multiple sas data sets together
• interleaving sas data sets with the set statement
• changing variable types using the put and input functions summarizing data
files
• summarizing data in the data step using sum and retain statements
• creating group totals with first and last processing
• creating summary data sets with proc summary
• selecting specification summarization hierarchies using the _type_ variable
2.6 perform iterative processing on data
• using do loops for repetitive calculations and processing
• using arrays to process across an observation
• using do while and do until statements for conditional looping
• creating a simple random sample
2.7 producing exception reports
• using a where statement to subset data
• using a contribution option to perform table lookups when merging files
• identifying duplicate rows of data in a file
|