Thursday, March 13, 2008

Read SAS data sets

data canada;
set mylib.productsales;
if country='CANADA';
run;

In this DATA step, each observation in the data set Mylib.ProductSales is read into the program data vector. Only those observations whose value of COUNTRY is CANADA are output to the new data set Canada.

data canada2;
set mylib.productsales;
if country='CANADA';
Total_Variance=actual-predict;
Forecast=actual*1.15;
run;

This DATA step creates data set Canada2 by reading data from data set Mylib.ProductSales and by calculating values for the two new variables Total_Variance and Forecast.

data product_sample;
do obsnum=1 to 100 by 2;
set mylib.productsales point=obsnum;
if _error_ then abort;
output;
end;
stop;
run;

These statements create the data set Product_Sample by selecting a subset of 50 observations from the data set Mylib.ProductSales, using the POINT= option to access observations directly by number.

No comments:

Post a Comment