DATA Step, Macro, Functions and more

first.id and last.id

Accepted Solution Solved
Reply
Contributor
Posts: 20
Accepted Solution

first.id and last.id

error.PNG

 

please explain me the error formed?

 


Accepted Solutions
Solution
‎11-05-2016 07:53 AM
Super User
Posts: 5,437

Re: first.id and last.id

Posted in reply to ROHINISDAS
Whenever you are using the BY statement the source data need to be sorted in the same way as specified in the BY statement.
Exception: when the data is stored in SPDE, SPDS or an external RDBMS the sorcerer engine sorts the data on the fly based on your BY statement.
Data never sleeps

View solution in original post


All Replies
Solution
‎11-05-2016 07:53 AM
Super User
Posts: 5,437

Re: first.id and last.id

Posted in reply to ROHINISDAS
Whenever you are using the BY statement the source data need to be sorted in the same way as specified in the BY statement.
Exception: when the data is stored in SPDE, SPDS or an external RDBMS the sorcerer engine sorts the data on the fly based on your BY statement.
Data never sleeps
Contributor
Posts: 20

Re: first.id and last.id

thank you for clearing my doubt.:-)
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 265 views
  • 1 like
  • 2 in conversation