what is the difference between SET and MERGE?
- 19 Answers
- 66415 Views
- CitiGroup, I also Faced
- E-Mail Answers
Answer Posted / mallikarjuna reddy
set statement joins two datasets vertically, like set
operators in PROC SQL and proc append. merge statements
joins 2 datasets horizontally, like joins in PROC SQL.
| Is This Answer Correct ? | 34 Yes | 7 No |
Post New Answer View All Answers
How to create list output for cross-tabulations in proc freq?
how many display types available in sas bi dashboard? : Sas-bi
Explain the purpose of substr functions in 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.
What is interleaving in SAS?
I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com
What is the difference between where and if statement?
what is data access? : Sas-di
What is the difference between input and infile statement?
What are the data types that sas contain?
What is SAS informats?
Which date function advances a date, time or datetime value by a given interval?
Give some examples where proc report’s defaults are same as proc print’s defaults?
What are the automatic variables for macro? : sas-macro
what is factor analysis? : Sas-administrator
