Proc expand

Reply
Occasional Contributor
Posts: 15

Proc expand

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

PROC Star
Posts: 7,467

Re: Proc expand

Posted in reply to wschnell1

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;

Ask a Question
Discussion stats
  • 1 reply
  • 208 views
  • 0 likes
  • 2 in conversation