To Home Page

CSC 433 -- SAS Examples

Weekly Zipfiles

week1.zip  week2.zip  week3.zip  week4.zip  week5.zip 

Index of SAS Examples

• Input: Kids  Quiz  Pointer
• Informat: States  USPopulation HexChars  Sound  WebLog 
• Missing: Column  List 
• Format: Bulls  TopSongs 
• FileOutput: PutToFile  Sales 
• Excel: Import  Export 
• Permanent SAS Datasets: PermDS 
• Control Statements: CompOp  StateRegions  FirstLast  Quiz4 
• Combine Datasets: InsertSum  Union  MatchMerge 
• Compute Percentiles: Percentiles1  Percentiles2  Ranks 
• Common Procs: ProcSort  ProcPrint  Sheep
• Arrays: Quiz5  Grades 
• Graphics and Charts: Pearson  Smoke1  Smoke2  Smoke3 
• Scatterplots: Iris1 and 2  Pearson2  Iris3  Iris4  Sgpanel  DoubleAxis 
• ODSGraphics: BarChart  Histogram  BoxPlot  ScatterPlot  Series  ProcTemplate
• SQL: Popul  Finance  Patients  Continent  Kids
• Reports: ProcMeansSummary  Drugstores  Boats  Treatments  NationalParks
• proc IML IML
• SAS Macros Tropical  GenerateState

Input Examples

• Kids Example -- Read Simple Dataset
   
  Answer questions about name, gender, and age of Kids dataset.
   
  

  Data File	Source Code	Output
  kids.txt	kids.sas	Output

  
  
• Quiz Examples -- Compute course score and final grade from quizzes, midterm, and final exams.
   
  Quiz1: create one observation from one input line; Quiz2: create three observations from one input line; Quiz3: create one observation from three input lines.
   
  

  Data File	Source Code	Output
  quiz1.txt	quiz1.sas	Output 1
  quiz2.txt	quiz2.sas	Output 2
  quiz3.txt	quiz3.sas	Output 3

  
  
• Pointer Example -- Use Column and Row Pointers
   
  Use SAS column and line pointers to control data access.
   
  

  Source Code	Output
  pointer.sas	Output

Informat Examples

• States Example -- Read data related to states' populations.
   
  Use the COMMAw. and PERCENTw. informats to read this data.
   
  

  Data File	Source Code	Output
  states.txt	states.sas	Output

  
   
• USPopulation Example -- Read data related to states' populations from 1900 to 1998.
   
  Use the ANYDTDTE12. informat and the YYMMDD. format to process the dates.
   
  

  Data File	Source Code	Output
  us-pop.txt	us-pop.sas	Output

  
  
• HexChars Example -- Process Hex ASCII data.
   
  Read hex bytes; display them as extended ASCII characters.
   
  

  Source Code	Output
  hexchars.sas	Output

  
   
• Sound Example -- Read raw binary integers.
   
  Read raw binary data from a simulated sound file using the IB1. (integer binary) informat. Print and plot this data.
   
  

  Data File	Source Code	Output
  sound.zip	sound.sas	Output

  
  
• WebLog Example -- Read lines from a server web log.
   
  Use the colon modifier and the @'chars' pointer.;
   
  

  Data File	Source Code	Output
  samplelog.txt	weblog.sas	Output

Format Example

• Bulls Example -- Display Chicago Bulls roster information.
   
  Display position with a user defined format.
   
  

  Data File	Source Code	Output
  bulls-roster-1213.txt	bulls.sas	Output

  
  
• TopSongs Examples -- Read and display a comma delimited file.
   
  TopSongs1 uses DLM=',' DSD. TopSongs2 uses proc import.
   
  

  Data File	Source Code	Output
  top-songs.txt	top-songs1.sas	Output 1
  	top-songs2.sas	Output 2

Missing Examples

• Column Example -- Read data using column input.
   
  Use the options flowover (Column1), missover (Column2), and truncover (Column3) to see what happens.
   
  

  Data File	Source Code	Output
  employees.txt	column1.sas	Output 1
  	column2.sas	Output 2
  	column3.sas	Output 3

  
  
• List1 Example -- Read data using list input.
   
  Use the options flowover (List1), missover (List2), and truncover (List3) to see what happens.
   
  

  Data File	Source Code	Output
  employees.txt	list1.sas	Output 1
  	list2.sas	Output 2
  	list3.sas	Output 3

File Output Examples

• PutToFile Example --Use the file and put statements to write to an output file.
   
  

  Data File	Source Code	Output File
  kids.txt	put-to-file.sas	kids-out.txt

  
  
• Sales Example -- Write a report that totals sales from various cities;
   
  

  Data File	Source Code	Output	Output File
  sales.txt	sales.sas	Output	report.txt

Excel Import/Export Examples

• Import Example --Import a dataset from Excel.
   
  

  Data File	Source Code	Output File
  mpg.xlsx	import.sas	Output

  
  
• Export Example -- Export a dataset to Excel.
   
  

  Source Code	Output File
  export.sas	mpg2.xslx

Permanent SAS Dataset Example

• PermDS --Create and use a Permanent SAS Dataset.
   
  

  Source Code	Output Files
  create-permds.sas
  read-permds.sas	Output

ControlStatements Examples

• CompOp -- Show that the comparison operators return the logical values 0 or 1.
   
  

  Source Code	Output Files
  comp-op.sas	Output

  
   
• StateRegions --  Classify states by the four census regions: Northeast, Midwest, South, and West. (1) Use if..else statements, (2) Use a select statement.
   
  

  Input File	Source Code	Output Files
  states2.txt	state-regions1.sas	Output 1
  	state-regions1.sas	Output 2

  
  
• FirstLast -- Print the first and last names in alphabetical order for both boys and girls. Use the first and last variables.
   
  

  Source Code	Output Files
  first-last.sas	Output 1

  
  
• Quiz4 -- Use a do loop to output one exam score per line;
   
  

  Input File	Source Code	Output Files
  quiz1.txt	quiz4.sas	Output

Combine Datasets Examples

• InsertSum -- Insert a summary statistic computed by proc means or other proc into a dataset.
   
  

  Source Code	Output Files
  insert-sum.sas	Output

  
  
• Union -- Form the union of two datasets using (1) stacking and (2) interleaving
   
  

  Input File	Source Code	Output Files
  bolts-coarse.txt bolts-fine.txt	union.sas	Output

  
   
• MatchMerge -- Merge a dataset of bolt orders with catalog information to compute the extended price for each order.
   
  

  Input File	Source Code	Output Files
  bolts-coarse.txt	match-merge.sas	Output

• Percentiles1 -- Use proc univariate to compute the 62nd percentile of scores using the five SAS definitions for computing percentiles.
   
  

  Source Code	Output Files
  percentiles1.sas	Output

  
  
• Percentiles2 -- Use the SAS pctl function to compute the 62nd percentile of scores using the five SAS definitions for computing percentiles.
   
  

  Source Code	Output Files
  percentiles2.sas	Output

Arrays Example

• Quiz5 -- Use an array to set all missing values of exams to zero.
   
  

  Data Set	Source Code	Output Files
  quiz1.txt	quiz5.sas	Output

  
  
• Grades Example
   
  Use SAS to score midterm and final exams using grading keys, then compute course scores and grades.
   
  

  Data Set	Source Code	SAS Output
  midterms.txt midterm-key.txt finals.txt final-key.txt	grades.sas	Output

• Reference: Delwiche and Slaughter, The Little SAS Book, 5th Edition, SAS Institute, 2012, pp. 106-115.
   
• ProcSort -- Show how various sort options to affect the sort order.
   
  

  Source Code	Output Files
  proc-sort.sas	Output

  
  
• ProcPrint -- Illustrate various features of proc print.
   
  

  Source Code	Output Files
  proc-print1.sas	Output1
  proc-print2.sas	Output2

  
  
• Sheep -- Show how to use various options of proc print.
   
  

  Input File	Source Code	Output Files
  sheep-numbers.txt	sheep.sas	Output

Graphics Examples

• Pearson -- Create scatterplots of the Pearson's historical dataset.
   
  The dataset contains 1079 bivariate observations:
  x = heights of fathers, y = heights of sons.
   
  

  Input File	Source Code	Output Files
  pearson.txt	pearson.sas     normal-plot.sas	Output GPLOT Graph SGPLOT Graph Normal Plot

  
  
• Smoke1 -- Use proc freq to summarize some of the data from the Smoking Survey from the Metro Chicago Information Center.
   
  Summarize whether or not survey respondent is a smoker, the sex, and education level of the respondent.
   
  

  Input File	Source Code	Output Files
  mcic-smoke.txt mcic-smoke-codes.txt	smoke1.sas	Output

  
  
• Smoke2 -- Use SAS/Graph bar charts and pie charts to summarize some of the data from the 1997 MCIC smoking survey.
   
  Summarize smoking status, sex, and education level.
   
  

  Input File	Source Code	Graphics Files
  mcic-smoke.txt mcic-smoke-codes.txt	smoke2.sas	smoke2a.png smoke2b.png smoke2c.png smoke2d.png

  
  
• Smoke3 -- Use ODS sgplot bar graphs to summarize some of the data from the 1997 MCIC smoking survey.
   
  Summarize smoking status, sex, and education level.
   
  

  Input File	Source Code	Graphics Files
  mcic-smoke.txt mcic-smoke-codes.txt	smoke3.sas	graph3a.png graph3b.png graph3c.png

• Iris1,2 -- The sashelp.iris dataset consists of four variables, all measured in millimeters: Petal Length, Petal Width, Sepal Length, Sepal Width. Change the plot statement in gplot or the scatterplot statement to create all six pairwise plots. The four variables were measured on four different iris species: Setosa, Versicolor, and Virginica. Try using the Petal Area and the Sepal Area to classify the three species.
   
  

  Source Code	Graphics Files
  iris1.sas iris2.sas	iris1.png iris2.png

  
  
• Pearson2 -- A SAS/GRAPH Example.  Specify the horizontal and vertical axes on a scatterplot of the Pearson father/son. Set horizontal and vertical axes.
   
  

  Source Code	Graphics Files
  pearson2.sas	pearson2.png

  
  
• Iris3 -- Create a matrix of pairwise scatterplots.
   
  

  Source Code	Graphics Files
  iris3.sas	iris3.png

  
  
• Iris4 -- Create a three dimensional plot of the Iris dataset.
   
  

  Source Code	Graphics Files
  iris4.sas	iris4.png

  
  
• Sgpanel -- Show four sgpanel examples.
   
  Ref: support.sas.com/documentation/cdl/en/grstatproc/62603/HTML/default/viewer.htm#sgpanel-ov.htm
   
  

  Source Code	Graphics Files
  sgpanel.sas	sgpanel1.png sgpanel2.png sgpanel3.png sgpanel4.png

  
  
• DoubleAxis -- Plot temperatures with two vertical axes, one for Celsius and one for Fahrenheit.
  DoubleAxis1 uses gplot;  DoubleAxis2 uses sgplot. 
   
  

  Source Code	Graphics File
  double-axis1.sas double-axis2.sas	double-axis1.png double-axis2.png

ODS Graphics Examples

• BarChart -- Create a barchart using sgplot. Graph favorite chocolate flavors by age.
  Ref: The Little SAS Book, p. 231.
   
  

  Source Code	Output Graphics File
  barchart.sas	barchart.png

  
  
• Histogram -- Create a histogram with superimposed normal density curve.
  Ref: The Little SAS Book, pp. 232, 3;
   
  

  Source Code	Output Graphics File
  histogram.sas	histogram.png

  
  
• BoxPlot --  Create boxplot summarizing number of laps by division.
  Ref: Little SAS Book, p. 235.
  
   
  

  Source Code	Output Graphics File
  boxplot.sas	boxplot.png

  
  
• ScatterPlot -- Create two different scatterplots.
  Ref: The Little SAS Book, p. 236,237; p. 244-247.
   
  

  Source Code	Output Graphics Files
  scatterplot1.sas scatterplot2.sas	scatterplot1.png scatterplot2-vA.png scatterplot2-vB.png

  
  
• Series -- Create two different series plots.
  Ref: The Little SAS Book, p. 238,9; 242,3.
   
  

  Source Code	Output Graphics File
  series1.sas series2.sas	series1.png series2.png

SQL Examples

• Popul -- Use proc sql to display the Popul dataset.
   
  Part 1: Display entire dataset unchanged.
  Part 2: Display only rows with population > 100 million and sorted.
  Part 3: Use proc sql to input the data.

  Input File	Source Code	Output Files
  popul.txt	popul1.sas popul2.sas popul3.sas	Output 1 Output 2 Output 3

  
  
• Finance -- Display table with a date column.
   
  

  Input File	Source Code	Output Files
  finance.sas7bdat	finance.sas	Output

  
  
• Patients -- For a select query with two tables in the from clause, but no where clause, the cartesian product of the table rows is returned. To form the join of patients and doctors, a where clause is needed;
   
  

  Source Code	Output Files
  patients.sas	Output

  
  
• Continents -- Convert the Continents1 Example, which uses SQL statements to Continents2, which uses base SAS construct.
   
  

  Source Code	Output Files
  continents1.sas continents2.sas	Output Output

  
  
• Kids -- Convert the Kids4 Example, which uses SQL statements to Kids5, which uses base SAS construct. In particular, Kids5 uses proc datasets.
   
  

  Source Code	Output Files
  kids4.sas kids5.sas	Output Output

Reports Examples

• ProcMeansSummary -- Print summary statistics using proc means and proc summary.
   
  

  Input File	Source Code	Output Files
  drugstore1.txt	proc-means-summary.sas	Output

  
  
• Drugstores -- Create tables using proc tabular that summarize drugstore data.
   
  

  Input File	Source Code	Output Files
  drugstore1.txt	drugstores.sas	Output

  
  
• Boats -- Create tables using proc tabular that summarize data about pleasure boats.
   
  Reference: Lora Delwiche and Susan Slaughter, The Little SAS Book, 5th Edition, SAS Publishing, 2012, Page 124.
   
  

  Input File	Source Code	Output Files
  boats.txt	boats.sas	Output

  
  
• Treatments -- Create tables using proc tabular that summarize patient treatment data.
   
  Reference: www.ats.ucla.edu/stat/sas/faq/tabulate.htm
   
  

  Input File	Source Code	Output Files
  treatments.txt	treatments.sas	Output

  
  
• NationalParks -- Generate reports using proc report with various options and features.
   
  Reference: Lora Delwiche and Susan Slaughter, The Little SAS Book, 4th Edition, SAS Publishing, 2008, 5th printing 2011, Page 136.
   
  

  Input File	Source Code	Output Files
  national-parks.txt	national-parks.sas	Output

  
  

proc IML Examples

• IML -- A brief introduction to proc iml.
  
  1. Create a matrices by hardcoded assignment and from a dataset,
  2. multiply two matrices with proc iml, and
  3. load matrix columns into a dataset
  
  

  Source Code	Output Files
  iml.sas	Output

  
  

Macros Examples

• Tropical -- Show how to use macros and macro variables.
  
  1. Use a macro variable for simple text substitution in a SAS script.
  2. Define and invoke a macro.
  3. Define and invoke a macro with parameters.
  4. Use a macro with conditional logic.
  5. Use CALL SYMPUT to set macro variables in a data step.
  
  

  Input File	Source Code	Output Files
  tropical-sales.txt	tropical1.sas tropical2.sas tropical3.sas tropical4.sas tropical5.sas	Output 1 Output 2 Output 3 Output 4 Output 5

  
  
• GenerateState -- Generate simulated store sales data for stores in all 50 states. The file california.txt is shown, but files with store sales data is simulated for all 50 states.
   
  

  Input File	Source Code
  states.txt	nstores.sas generate-state.sas get-state-sales.sas