I have a basic question:
data test; set temp1 temp2;run;
Temp1 and temp2 are 2 datasets with similar columns. Can somebody explain what this command is doing. Is it a union of the two datasets. Is there a better proc sql alternative to combine temp1 and temp2.
Thanks
This is like a union all in sql. But compare your data step code with the necessary sql code:
proc sql;
create table test as
select * from temp1
union all
select * from temp2;
quit;
and you'll see why it's rarely used when the data step is much more concise. Aside from the fact that the data step has capabilities beyond those of sql.
This is like a union all in sql. But compare your data step code with the necessary sql code:
proc sql;
create table test as
select * from temp1
union all
select * from temp2;
quit;
and you'll see why it's rarely used when the data step is much more concise. Aside from the fact that the data step has capabilities beyond those of sql.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.