Stored Compiled DATA Step Programs

Examples of DATA Step Programs

Example of DATA Step Program: Quality Control Application

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 Application Output

                             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.

Top of Page