topic Re: Proc expand in SAS Programming

Proc expand

wschnell1 — Thu, 16 Jan 2014 21:05:57 GMT

Hi everyone,

I am a new user and am trying to convert some datasets from annual,quarterly and monthly all to daily.

However, I keep getting an error message when I use the proc expand command. The error message is

" Statement is not valid or it is used out of proper order."

I am trying the following code;

proc expand data=monthly_data

out=temp1

from=month to=day;

id date;

convert returns / observed = average;

run;

Any help is greatly appreciated

Re: Proc expand

art297 — Thu, 16 Jan 2014 22:02:17 GMT

It worked for me! Do you license SAS/ETS? You would have to show your log.

data monthly_data;

set sashelp.citimon (keep=date luinc rename=(luinc=returns));

where date >= '1jan1990'd &

date < '1jan1992'd ;

run;

proc expand data=monthly_data

out=temp1

from=month to=day;

id date;

convert returns / observed = average;

run;