proc expand match eviews output

Josie1 — Wed, 09 Jun 2021 06:24:21 GMT

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?

thanks

proc expand data=have out=temp1 from=qtr to=month;

id date; convert employmentqrtr / observed=middle; run;

proc expand data=have out=temp2 from=qtr to=month;

id date; convert employmentqrtr / observed=(mi,average); run;

proc expand data=have out=temp4 from=qtr to=month;

id date; convert employmentqrtr / observed=(middle) transformout=(movave 3); run;

proc expand data=have out=temp4 from=qtr to=month;

id date; convert employmentqrtr /TRANSFORMIN=( / 3 ) OBSERVED=average ; run;

Re: proc expand match eviews output

ballardw — Wed, 09 Jun 2021 15:02:51 GMT

Likely to have a better answer if you provide 1) example of your data and 2) example of the data to "match".

Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712 will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the </> icon or attached as text to show exactly what you have and that we can test code against.

topic proc expand match eviews output in SAS Forecasting and Econometrics

proc expand match eviews output

Re: proc expand match eviews output