how to delete the duplicates by using proc sql?
- 3 Answers
- 8191 Views
- Genpact, I also Faced
- E-Mail Answers
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 |
What is the order of application for output data set options, input data set options and SAS statements?
Mention what are the data types does SAS contain?
How can a SAS WEB REPORT STUDIO USER identify which report tabs they have been permitted without entering the SAS WEB REPORT STUDIO
Hi, I have one dataset, could you please ans for this. id amount paid_amount 1 700 400 2 900 250 3 300 300 a 400 250 b 500 320 c 800 650 x 200 190 y 900 250 z 300 180 i want create new dataset having id and paid_amount who are paid high amount comparing amount. ex: 1d paid_amount 3 300 c 650 x 190
Name statements that are recognized at compile time only?
How would you code a merge that will keep only the observations that have matches from both sets?
Are you familiar with special input delimiters How are they used?
How to Rename Library?
How would you generate 1000 observations from a normal distribution with a mean of 50 and standard deviation of 20. How would you use PROC CHART to look at the distribution? Describe the shape of the distribution.
One way of creating a new variable in Macros is by % Let....What is the other way..?
How the date 04oct1994 is stored in SAS,not only give the answer explain in brief?
How to test the debugging in sas?
Teradata 
