106 proc sort data = sasuser.houses out = houses;
107 by style;
NOTE: There were 15 observations read from the data set SASUSER.HOUSES.
NOTE: The data set WORK.HOUSES has 15 observations and 6 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.02 seconds
cpu time 0.00 seconds
109 proc print data = houses;
110 id style;
111 by style;
112 var bedrooms baths price;
NOTE: There were 15 observations read from the data set WORK.HOUSES.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.07 seconds
cpu time 0.03 seconds
SAS uses ID statement variables to group the results in PROC REPORT and display results according to ascending values in ID variables, but it reprints the same values again. To make the report more presentable, the BY statement can be used, it will suppress the reprint of the values within a group. To get the desired output we need to add following statements: id style;
var bedrooms baths price;
The one and only FREE resource for general SAS online training as well as study guides for the SAS Base Certification. My goal is to create the SAS Certification prep guide that I never found but always wanted. This should also be a place to come if you are new to the language but are simply looking for online SAS training.