Hi everyone,
I have a EG 7.1 user who wants to create a SAS view that can contain Ordered Analytical Functions (aka Window Functions), which are not available in SAS. Does anyone know if it can be done and, if so, the code required to do so?
Thanks
SAS usually uses BY groups to accomplish this in a datastep.
I don't think you can replicate it directly in Proc SQL. If you can use pass through then you may be able to use the windowing functions but I don't know if that's possible in a view.
So basically - you can't use window functions directly, but there are other ways to achieve the same thing in SAS.
Thank you Reeza. I'm not familiar enough with using pass through but will research further.
No. Put you can create a data step view and so get any level of complexity you want.
data want/ view=want ;
set have ;
run;
Thanks Tom
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.