BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
RPSAS
Calcite | Level 5

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. 

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User

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. 


 

View solution in original post

1 REPLY 1
Reeza
Super User

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. 


 

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

Discussion stats
  • 1 reply
  • 1650 views
  • 1 like
  • 2 in conversation