Resources

Selecting Variables Based on Short Source Key Codes


/*----------------------------------------------------------------

                    SAS Sample Library

        Name: havex12.sas
 Description: Example program from SAS/ETS User's Guide,
              The SASEHAVR Interface Engine
    Title: Selecting Variables Based on Short Source Key Codes 
  Product: SAS/ETS Software
     Keys: SASEHAVR
    Procs:
    Notes: Read this before you run this sample.                      
           The database resides in the ets/sasmisc folder. You        
           must copy the database to a writeable folder before        
           using it. Then define your Windows system environment      
           variable, HAVER_DATA, to the path of your                
           writeable folder containing                                
           the haverd.dat and haverd.idx files (Haver database files).                                     
           To assign a fileref to the external file to be processed,  
           use the following form of the libname statement:
       
Libname lib1 sasehavr "%sysget(HAVER_DATA)"
        short="GOLDMAN, FRB, CRB";  
----------------------------------------------------------------*/
Libname lib1 sasehavr "%sysget(HAVER_DATA)"
        short="GOLDMAN, FRB, CRB";
data validE2;
   set lib1.haverd;
   where date  between '18jan2005'd and '29mar2005'd;
run;

title1 'SHORT= option list: GOLDMAN, FRB, CRB';
title2 'Should contain these time series:';
title3 'FCM10, FCM1M, FFED, FFP1D';
title4 'SHORT= option, Print the OUT= ValidE2 Data Set';
proc print data=validE2; 
run;

title4 'SHORT= option, Print the Contents of OUT= ValidE2 Data Set';
proc contents data=validE2;
run;