what is the difference between SET and MERGE?
- 19 Answers
- 64679 Views
- CitiGroup, I also Faced
- E-Mail Answers
Answer Posted / prabhakar
Set statement reads observations from one or more sas data set.
Merge statement joins two or more sas data sets into singe observations.
(or)
Set statement reads observations from one sas data sets at a time and joins into one data set.
Merge statement reads observations from one or more sas data sets simultaneously and joins into one data set.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
how do you debug and test your sas programs? : Sas programming
How do you convert basic cube to transaction cube and transaction cube to basic cube?
What is the different between functions and PROCs that calculate the same simple descriptive statistics?
Hello, I have PROC SQLs results group by 3 fields and I use SUM and COUNT functions in SQL. The problem is when I try to display my result with PROC TABULATE. I am getting very big numbers. I believe I make a mistake some where in Tabulate. Here is my Proc Tabulate. PROC TABULATE DATA=OUT04_05 FORMAT=12.; CLASS YR CENTRE VISA / PRELOADFMT EXCLUSIVE; VAR NEWUSER FRAUD TRANSFER AUTUSER REISSUE; TABLE CENTRE ALL, (YR ALL)*VISA, (NEWUSER*F=COMMA12. AUTUSER*F=COMMA12. FRAUD*F=COMMA12. TRANSFER*F=COMMA12. REISSUE*F=COMMA12.) / MISSTEXT={LABEL='0'} PRINTMISS RTS=20; FORMAT VISA VISAFMT.; KEYLABEL SUM = ' ' ALL = 'TOTAL'; LABEL YR = 'DATE YEAR' NEWUSER = 'TOTAL NEW ACCT' TRANSFER = 'TOTAL TRANSFER' FRAUD = 'TOTAL FRAUD TRANSFER' AUTUSER = 'TOTAL AUTH USERS' REISSUE = 'TOTAL REISSUE'; When I code it like : NEWUSER*N*F=COMMA12. AUTUSER*N*F=COMMA12. I get same amount numbers but to find a NEWUSER I use COUNT(*) and to find AUTUSER I use SUM(xxxx) function so both result shouldn’t be the same my problem is in this point. Could you tell me where the problem in code is. How can I display my result? TX.
What is the difference between using drop = data set option in data statement and set statement?
Explain why double trailing @@ is used in input statement?
How to convert a numeric variable to a character variable?
what are all the reports you generated in your recent project?
What are the data types does SAS contain?
What do you know about sas and what we do? : sas-grid-administration
What is the sas data set? : sas-grid-administration
what is slowly changing dimension? : Sas-di
What is SAS informats?
What is the difference between one to one merge and match merge? Give an example.
Explain proc sort?
