The SASEHAVR Interface Engine

Example 41.11 Using the OUTSELECT=ON Option to View the Key Selection Variables in a Haver Database

Suppose you want to select your time series based on geography codes or source codes. To contruct your wildcard for selection, first run with the OUTSELECT=ON option to see the possible values for each selection key.

Libname lib1 sasehavr "%sysget(HAVER_DATA)" 
        outselect=on ;
        
data validD1;
   set lib1.haverd;
run;

title1 'OUTSELECT=ON, Print the OUT= Data Set';
title2 'Shows the Values for Key Selection Variables:';
title3 'Name, Source, Geog1, Geog2, Shortsrc, Longsrc';
title4 'OUTSELECT=ON, the CONTENTS Procedure with Variable Names and Labels';
proc print data=validD1; 
run;

proc contents data=validD1;
run;

Output 41.11.1 shows the output values for each key selection variable.

If you also want to see a list of all the variables and their corresponding labels for this OUTSELECT=ON data set, you can run the CONTENTS Procedure.

Output 41.11.2 shows the contents of the output data set.