pagestack

[bhaupt]

I need to export a number of balanced series after importing them, balancing the datasets and converting from weeks to days. (I am doing an intermediate export to join them to a preexisting SAS dataset).



I made the assumption that to stack up a datafile that it would be similar to how I unstack the original. I am missing something:

Code: Select all

'# Note: the values of SERIES_ID are formatted SER_###. '# Note: ideally anewpage is an unstructured page 439726 in size. It is currently being created as a multi-dimensional dated page 2/11/1996 5/24/2008 x 98 pagestack(page=anewpage) SER_? @ SER_? @datestr(DATEID)

What I would like to for my identifier is:
SER_001 - 10/10/10
SER_001 - 10/11/10
SER_001 - 10/12/10
...
SER_002 - 10/10/10
etc.

Instead I get:
10/10/10 - 10/10/10
10/10/10 - 10/11/10
10/10/10 - 10/12/10

Below is a sample of my unstack procedure - effectively I'm trying to do the reverse now.

Code: Select all

'# Note: the values of SERIES_ID are formatted SER_###. read(t=txt,a2) %filename SERIES_ID $ MY_DATE $ VALUE pagestruct @date(MY_DATE) SERIES_ID pageunstack(namepat="?_*", page=WEEK,freq=w) SERIESID DATEID