Can proc expand be used in University Edition? I tried to use proc expand to find a 12 month rolling average and I was given a “cannot find” error for the proc expand statement.
No, PROC EXPAND is part of SAS/ETS. Only certain procedures are available in SAS UE.
You can use a temporary array approach within a data step:
http://support.sas.com/kb/41/380.html
From my personal reference library:
https://gist.github.com/statgeek/27e23c015eae7953eff2
Macro approach
https://gist.github.com/statgeek/e5e43ff45a4ba1f64d0873ff3bc35974
@RPSAS wrote:
Can proc expand be used in University Edition? I tried to use proc expand to find a 12 month rolling average and I was given a “cannot find” error for the proc expand statement.
No, PROC EXPAND is part of SAS/ETS. Only certain procedures are available in SAS UE.
You can use a temporary array approach within a data step:
http://support.sas.com/kb/41/380.html
From my personal reference library:
https://gist.github.com/statgeek/27e23c015eae7953eff2
Macro approach
https://gist.github.com/statgeek/e5e43ff45a4ba1f64d0873ff3bc35974
@RPSAS wrote:
Can proc expand be used in University Edition? I tried to use proc expand to find a 12 month rolling average and I was given a “cannot find” error for the proc expand statement.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.
Find more tutorials on the SAS Users YouTube channel.