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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: