How would you code a merge that will keep only the observations that have match

Categories >> Software >> Data Warehouse >> SAS
Suggest New Category

How would you code a merge that will keep only the
observations that have matches from both sets?

Question Posted / sasguru

5 Answers
11946 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How would you code a merge that will keep only the observations that have matches from both sets?..

Answer / vijay

Dear Guest,
Merge won't accept NODUPKEY option. it is for PROC SORT.
the following code will get only matched observations in
both datasets

data three;merge one (in=a) two (in=b);by **;if a and b;run;

Is This Answer Correct ?

12 Yes

0 No

How would you code a merge that will keep only the observations that have matches from both sets?..

Answer / naveen

data qqq;
merge aaa(in=a) bbb(in=b);
if a and b;
run;

Is This Answer Correct ?

1 Yes

0 No

How would you code a merge that will keep only the observations that have matches from both sets?..

Answer / murray

Both answers #2 and #3 will work fine, however the '= 1'
part is superfluous, and will work fine without.

Is This Answer Correct ?

0 Yes

3 No

How would you code a merge that will keep only the observations that have matches from both sets?..

Answer / san

data c;
merge data a(in=a)
dat b(in=b);
if a=1 and b=1;
by<common column>;
run;

Is This Answer Correct ?

0 Yes

5 No

How would you code a merge that will keep only the observations that have matches from both sets?..

Answer / guest

nodupkey option in the merge statement

Is This Answer Correct ?

0 Yes

8 No

Post New Answer

More SAS Interview Questions

Do you know the features of sas?

0 Answers

What are the data types in sas?

0 Answers

How would you determine how far down on a page you have printed in order to print out footnotes?

3 Answers

DATA ABC; INPUT TDATE DATE9. AVG; CARDS; 18APR2008 150.00 19APR2008 167.00 20APR2008 123.00 21APR2008 145.00 ; RUN HOW CAN I FIND THE DIFFERENCE BETWEEN AVG OF 18APR2008 ANF 21APR2008?? IF ANY ONE GETS IT PLS TRY TO POST IT.

8 Answers Verinon Technology Solutions,

Best trainer in hyderabad for sas banking.if any one have details pls provide contact details.

1 Answers

How do you debug macros?

3 Answers Accenture,

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.

0 Answers

What commands are used in the case of including or excluding any specific variables in the data set?

0 Answers

Diff between proc sql merge and join?

1 Answers HSBC, Sristek,

what is chi-square test? have you used that?

1 Answers Accenture, Quintiles,

Mention how to limit decimal places for the variable using proc means?

0 Answers

What are the efficacy variables in your study?

2 Answers Accenture, Quintiles,

For more SAS Interview Questions Click Here