When merging 2 datasets with a common variable (not merge
key), how to keep both?
Answer Posted / 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 |
Post New Answer View All Answers
Name validation tools used in SAS
How necessary is it to be creative in your work?
how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming
Describe the function and utility of the most difficult SAS macro that you have written?
Why and when do you use proc sql?
Mention the category in which sas informats are placed?
what is sas metadata server? : Sas-di
hi here is a problem can anybody solve this? i want to report the data through third party file. by using data _null_ or proc report or macro automation process. but i want to insert the 'titles and footnotes' in between the data and also starting of 2nd and ending of 2nd and starting of 3rd and ending of the 3rd page. tell me how and write the code?
Explain how merging helps to combine data sets.
What is the SAS data set?
What are the data types that sas contain?
Enlist the functions performed by sas.
what are the best practices to process the large data sets in sas programming? : Sas-administrator
Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?
What is the use of function Proc summary?