The SASEFAME Interface Engine |
This example shows how to extract string case series. In addition to the existing string case series in your Fame database, you can have formulas that resolve to string case series. SASEFAME resolves all formulas that belong to the class and type of series data object that you specify in your FAMEOUT= option. The following statements write all string case series to your SAS data set.
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;
Output 36.14.1 and Output 36.14.2 show the results.
Alphabetic List of Variables and Attributes | |||
---|---|---|---|
# | Variable | Type | Len |
1 | STR0 | Char | 16 |
2 | STR1 | Char | 16 |
3 | STR2 | Char | 16 |
4 | STRM | Char | 16 |
Using FAMEOUT=STRINGCASE Option without Range |
ALLTYPES, FAMEOUT=STRINGCASE and Open Wildcard for String Case Series |
Obs | STR0 | STR1 | STR2 | STRM |
---|---|---|---|---|
1 | -9 | 0 | 1.333333 | 0 |
2 | -8 | 1 | 1 | 1 |
3 | -7 | 2 | 0.6666667 | 2 |
4 | -6 | 3 | 0.3333333 | 3 |
5 | -5 | 4 | 0 | 4 |
6 | -4 | 5 | 5 | |
7 | -3 | 6 | ||
8 | -2 | 7 | 7 | |
9 | -1 | -1.333333 | ||
10 | 0 | |||
11 | 1 | |||
12 | 2 | |||
13 | 3 | -2.666667 | ||
14 | 4 | |||
15 | 5 | |||
16 | 6 | |||
17 | 7 | -4 | ||
18 | 8 | |||
19 | 9 | |||
20 | 10 |
Copyright © SAS Institute, Inc. All Rights Reserved.