STAT 5110/6110 SAS Programming and Applications by Peng Zeng

SAS Codes and Datasets

01-grades.sas: the first SAS code
01-external.sas: read external files
- filename statement: create an alias for a file
- blood-pressure.txt: a txt file (separated by spaces)
- blood-pressure.csv: a csv file (separated by comma)
- blood-pressure.xlsx: an Excel file (xlsx)
01-blood.sas: commonly-used procedures
- proc means: compute descriptive statistics
- proc freq: create frequency tables
- proc sort: sorting observations
01-bodymeasure.sas: NHANES example
01-errors.sas: sas code with syntax errors

02-lib.sas: SAS library and permanant SAS data set
- employees.sas7bdat: SAS data file
02-external-files.sas: read and write external files
- delimiter.txt: values separated by ampersand (&)
- state_data.txt: values separated by space
- boot.csv: values separated by comma (,), no variable names
- class.txt: values separated by tab
02-excel.sas: read and write Excel files
- exercise.xlsx: Excel files with multiple worksheets
02-manipulate.sas: minipulate data sets
- keep and drop variables
- define new variables
- conditional execution
- create subsets
02-transpose.sas: proc transpose
02-retain.sas:
- accumulate total
- retain statement

03-proc-print.sas: proc print
- common statements: var, where, by, id
- common options: noobs, label
- compute totals and subtotals
- titles, footnotes, and other global options
03-format.sas: SAS format
- demonstrate typical SAS formats
- proc format: define new format
03-summary.sas: summarize data
- proc means: compute descriptive statistics
- proc freq: create frequency tables
03-tabulate.sas: proc tabulate: display descriptive statistics in tabular format
03-report.sas: proc report: produce a variety of reports

04-firstlast.sas: first and last observations in a sorted data set
04-read-space.sas: read raw data separated by sapces
- ToadJump.txt:
- grades.txt:
- AllScores.txt: demonstrate option missover
04-read-column.sas: read raw data arranged in columns
- OnionRing.txt:
- Pumpkin.txt:
- NatPark.txt:
- Address.txt: demonstrate option truncover
04-read-delimited.sas: read delimited files
- Bands.csv:
04-write-raw.sas: write data to external files
04-output.sas: control output
04-combine.sas: combine data sets

06-SQL.sas: proc sql queries
- pokemon.csv: Pokemon
- employees.sas7bdat: SAS data file
06-SQL-table.sas: proc sql tables
06-SQL-join.sas: proc sql joins
06-SQL-set.sas: proc sql set
06-SQL-subquery.sas: proc sql subqueries