Please write codes to merge two datasets and keep every
record in the first dataset.
Answer / reshma
proc sort data=dataA;
by commonvar;
run;
proc sort data=dataB;
by commonvar;
run;
data new;
merge dataA (in=a) dataB (in=b);
if a ;
by commonvar;
run;
| Is This Answer Correct ? | 14 Yes | 0 No |
I need to find the numeric field which contains blank in between..Ex:123 456...there is blank in between the 123 456..I need to know if there is any SAS function to find a field.. Please suggest...
If you were told to create many records from one record show how you would do this using arrays and with PROC TRANSPOSE?
what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming
How would you remove a format that has been permanently associated with a variables?
i have a macro variable var1,var2. i want titles for the each macro variable separately? how it is possible?
explain about data integrator metadata reports? : Sas-di
How would you include common or reuse to be processed along with your statements?
What is the role of administrative users? : sas-grid-administration
If you could design your ideal job, what would it look like?
wat is sas? is a package or programming language?
Does anybody have SAS Training manual or documentation or can you refer me any book to have better understanding on SAS. I am fresher to SAS tool. (Ready to pay)
Name validation tools used in SAS