how to delete the duplicates by using proc sql?
Answer Posted / arpit
proc sql;
select distinct (*) from sasuser.xyz;
quit.
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
what are the component of range? : Sas-bi
Describe the ways in which you can create macro variables? : sas-macro
how sas deals with business intelligence? : Sas-bi
Give an example where SAS fails to convert character value to numeric value automatically?
what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi
what is PhaseIII, ODS, TLG, Macro and Proc in SAS
Difference between informat and format?
Name validation tools used in SAS
Mention what is SAS data set?
Are you involved in writing the inferential analysis plan? Tables specfications?
What are the default statistics that proc means produce?
AE datasets names? how many types?
What are the different servers in sas? : sas-grid-administration
Give some examples where proc report’s defaults are different than proc print’s defaults?
What is the basic structure of a sas program?