what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming



what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sa..

Answer / Kuldeep Chahal

"A method for assigning FIRST.VAR and LAST.VAR to the BY GROUPVARIABLE on unsorted data is to use Proc Sort beforehand, or use the 'keep=first' and 'drop=last' options within a DATA step."

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SAS Interview Questions

Explain the special input delimiters used in sas programming.

1 Answers  


What is the role of administrative users? : sas-grid-administration

1 Answers  


where to use sas business intelligence? : Sas-bi

1 Answers  


how we can call macros with in data step?

17 Answers   Allianz, ManPower,


What has been your most common programming mistake?

4 Answers   Wipro,


What is the difference between an informat and a format? Name three informats or formats.

13 Answers   Accenture, IBM,


If you could design your ideal job, what would it look like?

1 Answers   Oracle,


How do you define proc in sas? : sas-grid-administration

1 Answers  


how do u test a pros sql(works or not) without executing it?

1 Answers   DELL, HSBC,


How to get the repeated values by using sql in sas ?

2 Answers  


What are all the problems you faced while validating tables and reports?

1 Answers   Accenture, Quintiles,


How would you delete duplicate observations?

9 Answers  


Categories