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. 


 

SAS INNOVATE 2024

innovate-wordmarks-white-horiz.png

SAS is headed back 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.

Interested in speaking? Content from our attendees is one of the reasons that makes SAS Innovate such a special event!

Submit your idea!

Multiple Linear Regression in SAS

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.

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