Help! I have the attached quarterly employment data, I need a method that matches the results from someone else's eviews conversion. I need the middle observation month to equal the quarterly value and the average of all 3 months in the quarter to average to the middle value. I tried changing the months to 2,5,7 and 11 and that didn't work. where am I going wrong?
procexpand data=have out=temp1 from=qtr to=month;
id date; convert employmentqrtr / observed=middle; run;
procexpand data=have out=temp2 from=qtr to=month;
id date; convert employmentqrtr / observed=(mi,average); run;
procexpand data=have out=temp4 from=qtr to=month;
id date; convert employmentqrtr / observed=(middle) transformout=(movave 3); run;
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.