How would you combine 3 or more tables with different
structures?
Answer Posted / nandu
sort all datasets before going to merge
data abc ;
merge aa (in=a) bb (in=b) cc(in=c) ;
by empid /*by variable*/
if a or b or c;/*based on your requirement*/
run;
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5
What do you know about symput and symget?
What areas of SAS are you most interested in?
what are all the reports you generated in your recent project?
What is program data vector (pdv)?
What are the five ways to do a table lookup in sas? : sas-grid-administration
If money were no object, what would you like to do?
which date functions advances a date time or date/time value by a given interval? : Sas programming
What are the data types that sas contain?
explain about data integrator metadata reports? : Sas-di
What is the use of divide function?
what are _numeric_ and _character_ and what do they do? : Sas programming
what is ae onset date n what is RDS
where are dashboard components are created and maintained? : Sas-bi
What is maximum number of rows and cols can be handled in SAS?