Interested to Buy Any Domain ? << Click Here >> for more details...
When merging 2 datasets with a common variable (not merge
key), how to keep both?
- 3 Answers
- 6983 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / reshma
data newdata;
merge dataset1 (in=a) datset2 (in=b);
if a or b;
by commonvar;
run;
| Is This Answer Correct ? | 7 Yes | 2 No |
Answer / vigneshwaran.s
Rename the variable in First data or in The Second Data:
Like,
Merge A(rename=(comman_var=New_var))(in=x)
B (in=y);
by New_var;
Run;
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / madhavi.nowduru@gmail.com
set dataset1 dataset2;
by var;
| Is This Answer Correct ? | 0 Yes | 3 No |
If a variable contains only numbers, can it be a character data type?
Mention what is PROC in SAS?
here is a string like chq.2312244%4452- from that i want only special characters in a column. dont use compress. bcoz i have 1.2 billion of records.i want another process to find the values instant from the data.
what is data access? : Sas-di
What is the difference between Regression and Logistic Regression? Can u explain the Assumptions/Conditions?
what is star schema? : Sas-di
What are the main differences between sas versions 8.2, 9.0, 9.1?
is it possible to generate sas datasets using proc print ???
1 Answers GSK GlaxoSmithKline,
How would you delete observations with duplicate keys?
If you have a data set that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variable?
What is the pound sign used for the DATA _NULL_?
Explain data_null_?
Teradata 
