Combining two SAS data sets vertically and horizontally using PROC SQL

[deleted_user]

Hi

In SAS ,how can we combine two data sets horizontally, vertically using Proc sql.(SAS)


regards
rupa

[Cynthia_sas]

Hi:
This question does not fall into the ODS category or the Base Report procedure category.

There are several ways to do data manipulation on your data sets. PROC SQL uses join operators, like OUTER UNION CORRESPONDING, LEFT JOIN, RIGHT JOIN, FULL JOIN in order to bring data sets or tables together.

In the SAS documentation, there is a main section for "The SQL Procedure". Underneath that topic are two sub-topics, entitled
--PROC SQL and the ANSI Standard
--query-expression (yes, the topic is all lower case)
which describes the various set operators that you can use to bring your tables together. If reading the PROC SQL documentation does not help, then you might consider contacting Tech Support. You can explain your specific task and they can help you with the code.

cynthia

[deleted_user]

thanks!!! Cynthia