how to delete the duplicates by using proc sql?
- 3 Answers
- 7907 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 |
how does sas handle missing values in a merge? : Sas programming
Describe the ways in which you can create macro variables?
Hi im new to sas. I have a file with some charecter variables and some numeric variables now i want to load charecter variables into one datastep and numeric variables into another data step pls let me know Thanks
How do dates work in sas?
Hi I have list of products in a dataset, which are classified by other name for eg:- there is a product A> Malambo Shiraz Malbec 750ML(0388) which is a Red wine.Now i need to generate a report where it shows if this product appears then it should b displayed as red wine,similarly for other products and other classification. I dont wan use proc format.
Enlist the functions performed by sas.
Did you used proc test? when?
0 Answers Accenture, Quintiles,
Why Info School? BUILD YOUR CAREER WITH RIGHT GUIDANCE AND SUPPORT
Mention the category in which sas informats are placed?
what is the use of proc sql? : Sas programming
data task; input id date date9. visit; cards; 101 01jan2015 1 101 02jan2015 2 101 06jan2015 3 102 04jan2015 1 102 07jan2015 2 102 12jan2015 3 103 06jan2015 1 103 13jan2015 2 ; run; write a program to find out missing dates between visits by each subject.
What does a PROC TRANSPOSE do?
Teradata 
