76 data work.shoes
77 work.furniture(drop=cat_code quality);
78 set sales(keep=prod_name price cat_code
79 cat_name quality);
80 if cat_name = 'SHOES' then output work.shoes;
81 else if cat_name='FURNITURE' then output work.furniture;
82 drop cat_name;
NOTE: There were 2 observations read from the data set WORK.SALES.
NOTE: The data set WORK.SHOES has 1 observations and 4 variables.
NOTE: The data set WORK.FURNITURE has 1 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.30 seconds
cpu time 0.01 seconds
The variables prod_name, price, cat_code, cat_name, and quality are read in. The variable cat_name is dropped from both of the new data sets being created and the variables cat_code and quality are dropped from Work.FURNITURE. So, the dataset Work.shoes contains prod_name, price, cat_code, and quality and the dataset Work.FURNITURE contain prod_name and price. The only 2 variables that end up in both data sets are price and prod_name. The following datasets are created from the original Work.SALES:
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.