The SASEFAME Interface Engine |
This example shows how to extract date case series. In addition to the existing date case series in your Fame database, you can have formulas that resolve to date 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 date case series to your SAS data set.
libname lib6 sasefame "%sysget(FAME_DATA)" fameout=datecase wildcard="?" ; data cdout; set lib6.alltypes; run; title1 'Using FAMEOUT=DATECASE Option without Range'; title2 'ALLTYPES: FAMEOUT=DATECASE and Open Wildcard for Date Case Series'; proc contents data=cdout; run; proc print data=cdout; run;
Output 36.13.1 and Output 36.13.2 show the results.
Alphabetic List of Variables and Attributes | |||||
---|---|---|---|---|---|
# | Variable | Type | Len | Format | Informat |
1 | DAT0 | Num | 8 | YEAR4. | 4. |
2 | DAT1 | Num | 8 | YEAR4. | 4. |
3 | DAT2 | Num | 8 | YEAR4. | 4. |
4 | DATM | Num | 8 | YEAR4. | 4. |
5 | FRM2 | Num | 8 | YEAR4. | 4. |
Using FAMEOUT=DATECASE Option without Range |
ALLTYPES: FAMEOUT=DATECASE and Open Wildcard for Date Case Series |
Obs | DAT0 | DAT1 | DAT2 | DATM | FRM2 |
---|---|---|---|---|---|
1 | 1991 | 1981 | 1987 | 1981 | 1987 |
2 | 1992 | 1982 | 1986 | 1982 | 1986 |
3 | 1993 | 1983 | 1985 | 1983 | 1985 |
4 | 1994 | 1984 | 1984 | 1984 | 1984 |
5 | 1995 | 1985 | 1983 | 1985 | 1983 |
6 | 1996 | 1986 | . | 1986 | . |
7 | 1997 | 1987 | . | 1987 | . |
8 | 1998 | 1988 | . | 1988 | . |
9 | 1999 | . | 1979 | . | 1979 |
10 | 2000 | . | . | . | . |
11 | 2001 | . | . | . | . |
12 | 2002 | . | . | . | . |
13 | 2003 | . | 1975 | . | . |
14 | 2004 | . | . | . | . |
15 | 2005 | . | . | . | . |
16 | 2006 | . | . | . | . |
17 | 2007 | . | 1971 | . | . |
18 | 2008 | . | . | . | . |
19 | 2009 | . | . | . | . |
20 | 2010 | . | . | . | . |
Copyright © SAS Institute, Inc. All Rights Reserved.