Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete the duplicates by using proc sql?
- 3 Answers
- 9014 Views
- Genpact, I also Faced
- E-Mail Answers
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
which date function advances a date, time or datetime value by a given interval? : Sas programming
data data1; input dt account; format dt date9.; cards; 1745 1230 1756 1120 1788 1130 1767 1240 ; data data2; input startdt enddt total; format startdt date9. enddt date9.; cards; 1657 1834 12300 1557 1758 16800 1789 1789 12300 1788 1345 12383 1899 1899 13250 ; proc sql; create table data3 as select * from data1 as x left join data2 as y on x.dt>=y.startdt and x.dt<=y.enddt; quit; Here, we are getting cartision product. But,I want left join report consisting of this program. It should not get duplicate values. you can modify the program also.
Do you need to rearrange the order of the data for the report?
For what purpose would you use the RETAIN statement?
What is a macro routine?
AE datasets names? how many types?
What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro
which features do you use to check the data validations and errors? : Sas-administrator
What is the difference between where and if statement?
how would you determine the number of missing or nonmissing values in computations? : Sas programming
What are the differences between proc means and proc summary?
Are you involved in writing the inferential analysis plan? Tables specfications?
What is program data vector (pdv) and what are its functions?
What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?
how could you generate test data with no input data? : Sas programming
