How would you delete duplicate observations?
Answer Posted / soniya
use nodupkey, noduprec in sort processure
Is This Answer Correct ? | 8 Yes | 8 No |
Post New Answer View All Answers
what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming
What sas features do you use to check errors and data validation?
What are symget and symput? : sas-macro
Mention common programming errors committed in sas ?
What does the RUN statement do?
Describe crosslist option in tables statement?
I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.
explain about sas business intelligence? : Sas-bi
How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?
where to use sas business intelligence? : Sas-bi
This entry was posted in General. Bookmark the permalink. Post a comment or leave
What are the prime responsibilities of data integration administrator? : Sas-di
what is sas application server? : Sas-di
what is the difference between unique key and primary key? : Sas-di
How to specify variables to be processed by the freq procedure?