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
- 7017 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 |
In the flow of DATA step processing, what is the first action in a typical DATA Step?
Approximately what date is represented by SAS date value of 730
Dear all, proc means data=dsn noprint completetypes; class trtmntgroup /preloadfmt; output out=tot n=n; format trtmntgroup trtf. ; by vstgrp descending severity; run; This is the code I used for AE table. I got the values without giving the variable ‘trtmntgroup(numeric)’ in var statement. And if I give the var statement for that variable i’m getting the same values.How is that possible? What is the difference between class and var statement? Could any one explain me how does proc means work at the back end. And what is the difference between _freq_ value and N value in proc means. Thanks and regards, Rajesh.
Hot to suppress characters from a given string?
How would you identify a macro variable? : sas-macro
If a variable contains only numbers, can it be a character data type?
Hi, I have one dataset like id date ex: id date 1 13 1 13Oct2011 2 14 2 14Oct2011 3 15 3 15Oct2011 --->this is the current date here i want date format like 13Oct2011,14Oct2011 how we can modify the numeric to date format plz answer.
What is the significance of the ‘OF’ in X=SUM (OF a1-a4, a6, a9);?
Name statements that are execution only.
What are the joins,types of joins and thier functions?
What is the one statement to set the criteria of data that can be coded in any step?
what is sas database server? : Sas-di
Teradata 
