
Suppose you want to select your time series based on geography codes or source codes. To construct 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 49.11.1 shows the output values for each key selection variable.
Output 49.11.1: OUTSELECT=ON Option Shows the Values for Key Selection Variables
| OUTSELECT=ON, Print the OUT= Data Set |
| Shows the Values for Key Selection Variables: |
| Name, Source, Geog1, Geog2, Shortsrc, Longsrc |
| OUTSELECT=ON, the CONTENTS Procedure with Variable Names and Labels |
| Obs | NAME | SOURCE | GEOG1 | GEOG2 | SHORTSRC | LONGSRC | FCM10 | FCM1M | FFED | FFP1D | FXAUS | TCC |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | NAME | SOURCE | GEOG1 | GEOG2 | SHORTSRC | LONGSRC | ||||||
| 2 | FCM10 | FRB | 0000000 | FRB | Federal Reserve Board | |||||||
| 3 | FCM1M | UST | 0000000 | FRB | Federal Reserve Board | |||||||
| 4 | FFED | FRB | 0000000 | FRB | Federal Reserve Board | |||||||
| 5 | FFP1D | FRB | 0000000 | FRB | Federal Reserve Board | |||||||
| 6 | FXAUS | FRB | 0000000 | FRBNY | Federal Reserve Bank of New York | |||||||
| 7 | TCC | UST | 0000000 | TREASURY | U.S. Treasury |
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 49.11.2 shows the contents of the output data set.
Output 49.11.2: OUTSELECT=ON Option Shows the Contents of HAVERD.DAT
| Alphabetic List of Variables and Attributes | ||||
|---|---|---|---|---|
| # | Variable | Type | Len | Label |
| 7 | FCM10 | Char | 8 | 10-Year Treasury Note Yield at Constant Maturity (Avg, % p.a.) |
| 8 | FCM1M | Char | 8 | 1-Month Treasury Bill Market Bid Yield at Constant Maturity (%) |
| 9 | FFED | Char | 8 | Federal Funds [Effective] Rate (% p.a.) |
| 10 | FFP1D | Char | 8 | 1-Day AA Financial Commercial Paper (% per annum) |
| 11 | FXAUS | Char | 8 | Foreign Exchange Rate: Australia (US$/Australian$) |
| 3 | GEOG1 | Char | 8 | DLXRECORD.Geography1 |
| 4 | GEOG2 | Char | 8 | DLXRECORD.Geography2 |
| 6 | LONGSRC | Char | 70 | DLXRECORD.LongSource |
| 1 | NAME | Char | 10 | DLXRECORD.VarName |
| 5 | SHORTSRC | Char | 10 | DLXRECORD.ShortSourc |
| 2 | SOURCE | Char | 6 | DLXRECORD.Source |
| 12 | TCC | Char | 8 | Treasury: Closing Operating Cash Balance (Today, Mil.$) |