Selecting String Case Series with the FAMEOUT= Option
/*----------------------------------------------------------------
SAS Sample Library
Name: famex14.sas
Description: Example program from SAS/ETS User's Guide,
The SASEFAME Interface Engine
Title: Selecting String Case Series with the FAMEOUT= Option
Product: SAS/ETS Software
Keys: FAME data extraction, FAMEOUT= stringcase option
Procs: SASEFAME
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, FAME_DATA, to the path of your
writeable folder containing
the alltypes.db file (FAME database).
To assign a fileref to the external file to be processed,
use the following form of the libname statement:
libname lib7 sasefame "%sysget(FAME_DATA)"
fameout=stringcase wildcard="?" ;
----------------------------------------------------------------*/
title1 '***famallt: FAMEOUT option, Different Type Values***';
options validvarname=any;
%let FAME=%sysget(FAME);
%put(&FAME);
%let FAMETEMP=%sysget(FAME_TEMP);
%put(&FAMETEMP);
libname lib7 sasefame "%sysget(FAME_DATA)"
fameout=stringcase wildcard="?" ;
data cstrout;
set lib7.alltypes;
run;
title1 'Using FAMEOUT=STRINGCASE Option without Range';
title2 'ALLTYPES, FAMEOUT=STRINGCASE and Open Wildcard for String Case Series';
proc contents
data=cstrout;
run;
proc print
data=cstrout;
run;