The SASEFAME Interface Engine

Example 41.13 Selecting Date Case Series with the FAMEOUT= Option

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 41.13.1 and Output 41.13.2 show the results.

Output 41.13.1: Contents of OUT=CDOUT Using FAMEOUT=DATECASE

Using FAMEOUT=DATECASE Option without Range
ALLTYPES: FAMEOUT=DATECASE and Open Wildcard for Date Case Series

The CONTENTS Procedure

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.


Output 41.13.2: Listing of OUT=CDOUT Using FAMEOUT=DATECASE

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 . . . .