topic Re: Pull same variable observations from multiple datasets in SAS Programming

Pull same variable observations from multiple datasets

pdhokriya — Fri, 20 Oct 2023 12:20:27 GMT

Hello,

I have 5 datasets (a,b,c,d,e) and all these 5 datasets has xyz variable with same datatype, please suggest in 1 query how can I pull observations (in 1 dataset) from xyz from all 5 datasets.

From: Priyanka

Re: Pull same variable observations from multiple datasets

PaigeMiller — Fri, 20 Oct 2023 12:48:54 GMT

@pdhokriya wrote:

I have 5 datasets (a,b,c,d,e) and all these 5 datasets has xyz variable with same datatype, please suggest in 1 query how can I pull observations (in 1 dataset) from xyz from all 5 datasets.

Given the wording above, it is not clear if you are trying to find when observations have the same value of XYZ in all five data sets, or are you trying to find cases where a value in XYZ appears in more than one (but not all five) data sets, or even the situation where a value in XYZ appears in just one data set. Clarification would help.

Also, do you want to combine these data sets horizontally (MERGE or JOIN) or vertically (SET or UNION)?

Re: Pull same variable observations from multiple datasets

Quentin — Fri, 20 Oct 2023 13:19:55 GMT

Without much more information, sounds like a LEFT JOIN.

If you can post a small example of work.A, work.B, and work.C (so DATA steps using CARDS statement to create each, maybe 5 rows of data, 3 variables) and then post the output you would want, along with the code you have tried, it will help people help you.

Re: Pull same variable observations from multiple datasets

ballardw — Fri, 20 Oct 2023 14:26:00 GMT

Strongly suggest that you provide some small examples and what the result is supposed to look like.

For example are any other variables to be included in the result? If they are have you verified the other variables that have the same name are of the same data type and length?

Is there supposed to be any indication of which data set a specific value came from?

How many values are involved? Do they need to change? (Goes to how to provide the list for selection, 2 or three are easy to place directly in code, 200 not so much).

Re: Pull same variable observations from multiple datasets

Reeza — Fri, 20 Oct 2023 14:55:27 GMT

data want;
set a b c d e;
keep xyz;
run;

I suspect this isn't quite what you want so you'll need to provide more information - fake examples of your situation are fine.