how to delete the duplicates by using proc sql?
Answer Posted / chowdary
In constraints time using unique
In datasets using distinct()
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how sas deals with business intelligence? : Sas-bi
What is program data vector (pdv) and what are its functions?
I have a dataset concat having a variable a b & c. How to rename a b to e & f?
explain the main difference between the nodup and nodupkey options? : Sas-administrator
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.
Mention the difference between ceil and floor functions in sas?
Intern stastical programmer written test
Explain input and put function?
what is hierarchy flattening? : Sas-di
What are the applications primarily used by business analyst? : Sas-bi
how do you debug and test your sas programs? : Sas programming
What is the difference between the proc sql and data step?
What is SAS? What are the functions does it performs?
what does the run statement do? : Sas programming
What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?