Interested to Buy Any Domain ? << Click Here >> for more details...
How would you code a merge that will keep only the
observations that have matches from both sets.
- 5 Answers
- 14706 Views
- Accenture, Bank Of America, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / nishant
Using "IN" variable option. Look at the following example.
data three;
merge one(in=x) two(in=y);
by id;
if x=1 and y=1;
run;
| Is This Answer Correct ? | 13 Yes | 1 No |
Answer / pallavi
data three;
merge one(in=x) two(in=y);
by id;
if x and y;
run;
| Is This Answer Correct ? | 13 Yes | 1 No |
Answer / madhavi
proc sort data=one;
by id;
run;
proc sort data=two;
by id;
run;
data comm_rec;
merge one(in=a) two(in=b);
by id;
if a and b;
run;
proc print data=comm_rec;
run;
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / sheetal
Using joins in proc sql statement, see following example
proc sql;
select *
from a, b
where a.case_id = b.case_id;
quit;
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / kamudu
here we used simple answer ia
data merge;
merge(tables------);
by (same colum);
if e1 and e2 then
output;
keep-----;
run;
| Is This Answer Correct ? | 0 Yes | 5 No |
what are the advantages of using SAS in clinical data mangement? why should not we use other software products in managing clinical data?
1.How many ways are there to create variables? 2.What is CLM,how can we use it? 3.what are the advontages of data step? 4.what is the extension of editor window in SAS 9.1.3? 5.How do you copy a particular data set from one library to another? 6.what is the use of double option? 7.Advontages of Proc Report? 8.what is the basic use of where statement? 9.How do you terminate the statments in SAS Programming? 10.What is the difference between symput and symget? 11.How would a identify the local and global variable? can any one answer for the 4'th question
what is sas olap server? : Sas-di
Does anybody has SAS Platform Administration certification dumps. pls send to hariithepalli@gmail.com
You have a data set of 100 observations,how can you restrict the output so that the output has only data from row no. 10 to row no. 20
what is chi-square test? have you used that?
1 Answers Accenture, Quintiles,
what is the Population you used in your project, is it ITT or PP?
0 Answers Accenture, Quintiles,
How can you limit the variables written to output dataset in data step?
Explain append procedure?
What is the difference between a PROC step and a DATA step?
Describe what are the different levels of administrative users in sas? : sas-grid-administration
how can you get the single data set from the library(which has the number of data sets)?
3 Answers Accenture, Deloitte,
Teradata 
