The SASEHAVR Interface Engine: Using the GROUP Option to Subset Time Series from a Haver Database

The SASEHAVR Interface Engine

Example 37.10 Using the GROUP Option to Subset Time Series from a Haver Database

To select specific variables that belong to a certain group, you can use the GROUP= or DROPGROUP= option, similar to the way you use the KEEP= or DROP= option.

Output 37.10.1, Output 37.10.2, and Output 37.10.3 show three different cross sections of the same database, haverw, by specifying three unique GROUP= options: GROUP="F*" in LIBNAME LIB1, GROUP="M*" in LIBNAME LIB2, and GROUP="E*" in LIBNAME LIB3.

The following statements specify GROUP="F*" in the LIBNAME LIB1 statement.

libname lib1 sasehavr "%sysget(HAVER_DATA)"
        freq=week.6 
        force=freq 
        start=20040102 
        end=20041001 
        group="F*";

data hwoutwA;
   set lib1.haverw;
run;

title1 'Haver Analytics Database, Frequency=week.6, infile=haverw.dat';
title2 '   Define a range inside the data range for OUT= dataset';          
title3 '   Using the START=20040102 END=20041001 LIBNAME options.';          
title4 '   Subset further: Using group="F*" LIBNAME option';              
proc print data=hwoutwA;
run;

Output 37.10.1 shows the output.

Output 37.10.1 Using the GROUP=F* Option and Defining a Range

Haver Analytics Database, Frequency=week.6, infile=haverw.dat

Define a range inside the data range for OUT= dataset

Using the START=20040102 END=20041001 LIBNAME options.

Subset further: Using group="F*" LIBNAME option

Obs	DATE	FCM1M	FTA1MA	FTB3
1	02JAN2004	0.86	16.089	0.885
2	09JAN2004	0.88	12.757	0.920
3	16JAN2004	0.84	12.141	0.870
4	23JAN2004	0.79	12.593	0.875
5	30JAN2004	0.86	17.357	0.890
6	06FEB2004	0.90	21.759	0.920
7	13FEB2004	0.90	21.557	0.920
8	20FEB2004	0.92	21.580	0.915
9	27FEB2004	0.96	21.390	0.930
10	05MAR2004	0.97	24.119	0.940
11	12MAR2004	0.96	24.294	0.930
12	19MAR2004	0.94	23.334	0.945
13	26MAR2004	0.95	21.400	0.930
14	02APR2004	0.95	21.818	0.945
15	09APR2004	0.94	17.255	0.930
16	16APR2004	0.92	14.143	0.915
17	23APR2004	0.89	14.136	0.935
18	30APR2004	0.87	16.946	0.970
19	07MAY2004	0.89	22.772	0.985
20	14MAY2004	0.89	23.113	1.060
21	21MAY2004	0.91	25.407	1.040
22	28MAY2004	0.94	25.043	1.050
23	04JUN2004	0.97	27.847	1.130
24	11JUN2004	1.01	27.240	1.230
25	18JUN2004	1.05	17.969	1.390
26	25JUN2004	1.08	12.159	1.315
27	02JUL2004	1.11	12.547	1.355
28	09JUL2004	1.14	21.303	1.320
29	16JUL2004	1.16	25.024	1.315
30	23JUL2004	1.21	25.327	1.330
31	30JUL2004	1.30	21.823	1.425
32	06AUG2004	1.34	21.631	1.465
33	13AUG2004	1.37	28.237	1.470
34	20AUG2004	1.36	26.070	1.470
35	27AUG2004	1.39	27.342	1.515
36	03SEP2004	1.46	25.213	1.580
37	10SEP2004	1.57	25.255	1.635
38	17SEP2004	1.57	15.292	1.640
39	24SEP2004	1.56	15.068	1.685
40	01OCT2004	1.54	21.549	1.710

The following statements specify GROUP="M*" in the LIBNAME LIB2 statement:


libname lib2 sasehavr "%sysget(HAVER_DATA)"
        freq=week.6 
        force=freq start=20040102 
        end=20041001 
        group="M*";
        
data hwoutwB;
   set lib2.haverw;
run;
  
title1 'Haver Analytics Database, Frequency=week.6, infile=haverw.dat';
title2 '   Define a range inside the data range for OUT= dataset';        
title3 '   Using the START=20040102 END=20041001 LIBNAME options.';        
title4 '   Subset further: Using group="M*" LIBNAME option';            
proc print data=hwoutwB;
run;

Output 37.10.2 shows the output.

Output 37.10.2 Using the GROUP=M* Option and Defining a Range

Haver Analytics Database, Frequency=week.6, infile=haverw.dat

Define a range inside the data range for OUT= dataset

Using the START=20040102 END=20041001 LIBNAME options.

Subset further: Using group="M*" LIBNAME option

Obs	DATE	FA	FM1
1	02JAN2004	7302.9	1298.2
2	09JAN2004	7351.2	1294.3
3	16JAN2004	7378.5	1286.8
4	23JAN2004	7434.7	1296.7
5	30JAN2004	7492.4	1305.1
6	06FEB2004	7510.4	1303.1
7	13FEB2004	7577.8	1309.1
8	20FEB2004	7648.7	1317.0
9	27FEB2004	7530.6	1321.1
10	05MAR2004	7546.7	1316.2
11	12MAR2004	7602.0	1312.7
12	19MAR2004	7603.0	1324.0
13	26MAR2004	7625.5	1337.6
14	02APR2004	7637.3	1337.9
15	09APR2004	7667.4	1327.3
16	16APR2004	7692.5	1321.8
17	23APR2004	7698.4	1322.2
18	30APR2004	7703.8	1331.6
19	07MAY2004	7686.8	1342.5
20	14MAY2004	7734.6	1325.5
21	21MAY2004	7695.8	1330.1
22	28MAY2004	7704.7	1337.7
23	04JUN2004	7715.1	1329.0
24	11JUN2004	7754.0	1324.4
25	18JUN2004	7753.2	1336.4
26	25JUN2004	7796.2	1345.8
27	02JUL2004	7769.8	1351.4
28	09JUL2004	7852.3	1330.1
29	16JUL2004	7852.8	1326.3
30	23JUL2004	7854.7	1323.5
31	30JUL2004	7859.5	1340.6
32	06AUG2004	7847.9	1337.3
33	13AUG2004	7888.7	1340.1
34	20AUG2004	7851.8	1347.3
35	27AUG2004	7890.0	1360.8
36	03SEP2004	7906.2	1353.7
37	10SEP2004	7962.7	1338.3
38	17SEP2004	7982.1	1345.6
39	24SEP2004	7987.9	1359.7
40	01OCT2004	7949.5	1366.0

The following statements specify GROUP="E*" in the LIBNAME LIB3 statement:

libname lib3 sasehavr "%sysget(HAVER_DATA)"
        freq=week.6 
        force=freq 
        start=20040102 
        end=20041001 
        group="E*";

data hwoutwC;
   set lib3.haverw;
run;

title1 'Haver Analytics Database, Frequency=week.6, infile=haverw.dat';
title2 '   Define a range inside the data range for OUT= dataset';        
title3 '   Using the START=20040102 END=20041001 LIBNAME options.';        
title4 '   Subset further: Using group="E*" LIBNAME option';            
proc print data=hwoutwC;
run;

Output 37.10.3 shows the output.

Output 37.10.3 Using the GROUP=E* Option and Defining a Range

Haver Analytics Database, Frequency=week.6, infile=haverw.dat

Define a range inside the data range for OUT= dataset

Using the START=20040102 END=20041001 LIBNAME options.

Subset further: Using group="E*" LIBNAME option

Obs	DATE	LICN
1	02JAN2004	552.8
2	09JAN2004	677.9
3	16JAN2004	490.8
4	23JAN2004	382.3
5	30JAN2004	406.3
6	06FEB2004	433.2
7	13FEB2004	341.6
8	20FEB2004	328.2
9	27FEB2004	342.1
10	05MAR2004	339.0
11	12MAR2004	312.1
12	19MAR2004	304.5
13	26MAR2004	296.8
14	02APR2004	304.2
15	09APR2004	350.7
16	16APR2004	335.0
17	23APR2004	313.7
18	30APR2004	283.2
19	07MAY2004	292.8
20	14MAY2004	297.1
21	21MAY2004	294.0
22	28MAY2004	304.1
23	04JUN2004	308.2
24	11JUN2004	312.4
25	18JUN2004	322.5
26	25JUN2004	318.7
27	02JUL2004	349.9
28	09JUL2004	444.5
29	16JUL2004	394.4
30	23JUL2004	315.7
31	30JUL2004	282.1
32	06AUG2004	291.5
33	13AUG2004	268.0
34	20AUG2004	272.1
35	27AUG2004	275.2
36	03SEP2004	273.7
37	10SEP2004	250.6
38	17SEP2004	275.8
39	24SEP2004	282.7
40	01OCT2004	279.6

Top of Page