Combining two SAS data sets vertically and horizontally using PROC SQL

deleted_user — Wed, 12 Sep 2007 12:32:29 GMT

Hi

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

regards
rupa

Re: Combining two SAS data sets vertically and horizontally using PROC SQL

Cynthia_sas — Wed, 12 Sep 2007 14:22:11 GMT

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

Re: Combining two SAS data sets vertically and horizontally using PROC SQL

deleted_user — Thu, 13 Sep 2007 06:27:01 GMT

thanks!!! Cynthia

topic Re: Combining two SAS data sets vertically and horizontally using PROC SQL in ODS and Base Reporting

Combining two SAS data sets vertically and horizontally using PROC SQL

Re: Combining two SAS data sets vertically and horizontally using PROC SQL

Re: Combining two SAS data sets vertically and horizontally using PROC SQL