Example of DATA Step Program

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-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-library-1';
libname testlib 'SAS-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.