Proc expand

[wschnell1]

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

[art297]

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;