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
- 7018 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 the data types does SAS contain?
name some data transformation used in sas di? : Sas-di
How would you define the end of a macro?
1.How to draw pivot tables in Excel by using SAS and in which version we can use VB script for to draw pivot tables in Excel? Answer with example data. 2.What are the advantages of _NULL_ in Data steps? Can we use _NULL_ in Proc steps also? 3. How to call the macro variable into Data Steps? 4. Can we draw pivot tables in Excel using Proc SQL? Please post answers for the above questions with suitable examples, and how to use VB script for Excel using SAS.
Which date function advances a date, time or datetime value by a given interval?
how to generate report for 0 observation dataset?
what are sas/access and sas/connect? : Sas programming
Tell me more about the parameters in macro? : sas-macro
How would you include common or reuse code to be processed along with your statements?
what is the difference between proc means and proc tabulate?
What are Dashboard reports?And significance of these in analysis?
How would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable?
Teradata 
