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
- 6826 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 |
What are some problems you might encounter in processing missing values? In Data steps? Arithmetic? Comparisons? Functions? Classifying data?
How you can read the variables that you need?
what is validvarname and varnum? why we are using this options; explain with a syntax for this options?
Hi im new to sas. I have a file with some charecter variables and some numeric variables now i want to load charecter variables into one datastep and numeric variables into another data step pls let me know Thanks
What is the difference between INPUT and INFILE ?
What are all the problems you faced while validating tables and reports?
0 Answers Accenture, Quintiles,
Name the option to produce a frequency line items rather that a table.
which features do you use to check the data validations and errors? : Sas-administrator
What do the sas log messages “numeric values have been converted to character” mean? What are the implications?
What makes sas stand out to be the best over other data analytics tools?
what are informats in sas? : Sas-administrator
How to convert a given date value into SAS date
9 Answers CitiGroup, Quintiles,
Teradata 
