The SAS Output Delivery System and reporting techniques

Combining two SAS data sets vertically and horizontally using PROC SQL

Reply
N/A
Posts: 0

Combining two SAS data sets vertically and horizontally using PROC SQL

Hi

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


regards
rupa
SAS Super FREQ
Posts: 8,740

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

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
N/A
Posts: 0

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

thanks!!! Cynthia
Ask a Question
Discussion stats
  • 2 replies
  • 121 views
  • 0 likes
  • 2 in conversation