Desktop productivity for business analysts and programmers

Creating a view in EG containing Window Functions

Reply
SAS Employee
Posts: 3

Creating a view in EG containing Window Functions

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

Grand Advisor
Posts: 17,360

Re: Creating a view in EG containing Window Functions

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.

SAS Employee
Posts: 3

Re: Creating a view in EG containing Window Functions

Thank you Reeza. I'm not familiar enough with using pass through but will research further.

 

Super User
Super User
Posts: 6,351

Re: Creating a view in EG containing Window Functions

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;
SAS Employee
Posts: 3

Re: Creating a view in EG containing Window Functions

Thanks Tom

Ask a Question
Discussion stats
  • 4 replies
  • 266 views
  • 0 likes
  • 3 in conversation