The SASEHAVR Interface Engine

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

Output 49.10.1, Output 49.10.2, and Output 49.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 49.10.1 shows the output.

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 49.10.2 shows the output.

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 49.10.3 shows the output.