Interested to Buy Any Domain ? << Click Here >> for more details...
· What are some good SAS programming practices for
processing very large data sets?
- 6 Answers
- 20680 Views
- Quintiles, I also Faced
- E-Mail Answers
Answer Posted / sibin
Use
1.WHERE Condition
2.DROP KEEP in Set Statement
3.ARRAY
4.Mutually Exclusive Conditions like DO ,DO UNTIL,DO WHILE
| Is This Answer Correct ? | 16 Yes | 1 No |
Post New Answer View All Answers
how can you put a "trace" in your program? : Sas programming
What is the role of administrative users? : sas-grid-administration
Explain the main difference between the sas procedures and functions? : Sas-administrator
What does the trace option do?
What is a put statement?
Explain the difference between nodup and nodupkey options?
What is slibref?
Mention the category in which sas informats are placed?
how will you locate the sas platform applications? : Sas-bi
What are the difference between sas functions and procedures?
Give e an example of..
Are you sensitive to code walk-throughs peer review or QC review?
What are the implications?
explain about data integrator metadata reports? : Sas-di
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.
