SAS University Edition - proc expand

RPSAS — Sun, 19 Nov 2017 01:49:04 GMT

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.

Re: SAS University Edition - proc expand

Reeza — Sun, 19 Nov 2017 02:05:46 GMT

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.

topic SAS University Edition - proc expand in SAS Forecasting and Econometrics

SAS University Edition - proc expand

Re: SAS University Edition - proc expand