DATA Step, Macro, Functions and more

Proc sql

Reply
Contributor
Posts: 22

Proc sql

Is there any LEAD (VAR,1) OVER (PARTITION BY VAR ORDER BY VAR) LIKE FUNCTION in proc sql which we can use to read next observation values ??? i can see some example in google but when tried to apply same it resulted in syntax error????

Respected Advisor
Posts: 2,647

Re: Proc sql

[ Edited ]
Posted in reply to Bhargav_Movva

In SAS PROC SQL (as opposed to perhaps other implementations of SQL), there is no such function. Please explain what you are trying to do so that we may advise further. Most likely a data step could get the job done.

 

i can see some example in google but when tried to apply same it resulted in syntax error????

 

We don't know what this means. You have to show us your code and the SASLOG.

--
Paige Miller
Ask a Question
Discussion stats
  • 1 reply
  • 111 views
  • 0 likes
  • 2 in conversation