This example illustrates how to use a stored compiled DATA step program for a simple quality control application. This application processes several raw data files. The source program uses the fileref DAILY in the INFILE statement. Each DATA step that is used to execute the stored program can include a FILENAME statement to associate the fileref DAILY with a different external file.
The following statements compile and store the program:
libname stored ' SAS-data-library-1 '; data flaws / pgm=stored.flaws; length Station $ 15; infile daily; input Station $ Shift $ Employee $ NumberOfFlaws; TotalNumber + NumberOfFlaws; run;
The following statements execute the stored compiled program, redirect the output, and print the results:
libname stored ' SAS-data-library-1 '; libname testlib ' SAS-data-library-2 '; data pgm=stored.flaws; redirect output flaws=testlib.daily; run; proc print data=testlib.daily; title 'Quality Control Report'; run;
Quality Control Report 1 Number Total Obs Station Shift Employee OfFlaws Number 1 Cambridge 1 Lin 3 3 2 Northampton 1 Kay 0 3 3 Springfiled 2 Sam 9 12
Note that you can use the TITLE statement when you execute a stored compiled DATA step program or when you print the results.