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
- 7002 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 is difference between sas rename and lable?
AE datasets names? how many types?
You need to perform an analysis on a massive dataset by groups, but are unable to sort the data due to memory constraint. How would you accomplish the task?
how would you determine the number of missing or nonmissing values in computations? : Sas programming
Hi, I need to create a SAS Map of USA using SAS Graphs(Proc Gmap).The data i have dosent contain any co-ordinates of USA cities or counties or states, and the zip codes are diffrent in the data i have from the zip code in the Maps.US dataset in the Maps Library for SAS MAPS. the data i have is a sales report. i have to generate the maps according to the states,cities aligned in the sales data, HELP Appriciated
How do you connect the desktop application to metadata server? : sas-grid-administration
hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana
What areas of SAS are you most interested in?
How would you include common or reuse to be processed along with your statements?
What is the difference between the proc sql and data step?
what is the effect of the options statement errors=1? : Sas programming
How many missing values are available? When might you use them?
Teradata 
