how to delete the duplicates by using proc sql?
Answers were Sorted based on User's Feedback
Answer / shivakrishna.yenaganti
Proc SQL noprint;
create table unique as select distinct (*) from dsn;
quit;
Is This Answer Correct ? | 22 Yes | 2 No |
Answer / arpit
proc sql;
select distinct (*) from sasuser.xyz;
quit.
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / chowdary
In constraints time using unique
In datasets using distinct()
Is This Answer Correct ? | 1 Yes | 0 No |
Which is Best Institute for learning SAS BASE & SAS BI in Hyderabad? Can anyone suggest me ?
Does anybody has lastest SAS certification dumps,if anybody has please mail me on saggydesai@gmail.com
What is the use of stop statement?
what the use of proc glm
How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?
How do you read in the variables that you need?
i am importing large data from oracle to work library. in log there is a error message worklibrary space is not enough. then how to import the data safely to sas environment.
tell me about intnx, intcx functions?
Give some examples where proc report’s defaults are same as proc print’s defaults?
how to generate report for 0 observation dataset?
How would you include common or reuse code to be processed along with your statements?
What are the data types that sas contain?