topic Re: Merge two datasets in SAS Programming

Merge two datasets

Tamertmg — Tue, 05 Jul 2022 15:00:07 GMT

Hi,

I am trying to merge two datasets: dataset A and dataset B, and at the same time, I want to do some calculations based on the TOTAL and the LOS_TOTAL. I tried to merge the data set by year as it is the only variable that matches both datasets, but it did not work. I used the following data step:-

Data test;
Set test1;
Merge work.A
Work.B;
By year;
Run;

The merge should be based on the value (0,1) for variables (_3WX _2SF _4SQ _6SR _7SF _7WO 7ICU _5AA), if the value is 1 then take the same values of GRE and ZDF from the dataset B. If it is 0, then ignore it. If one observation contains value 1 in two different variables, then do a calculation. For example (ID 3 has value 1 for _2SF and _7ICU).

Now, I am stuck. I don’t know how to merge them. Also, I want to do the following calculation (e.g., ID 3):-

If total > 1 then GRE =

ZDF =

Figure 1 dataset A

Figure 2. Dataset B

The outcome should be like this:-

Figure 3. Desired outcomes

Thank you

Re: Merge two datasets

PaigeMiller — Tue, 05 Jul 2022 18:43:36 GMT

I tried to merge the data set by year as it is the only variable that matches both datasets, but it did not work.

Saying "it did not work" and stopping there gives us no information about why it didn't work.

If there are errors in the log, then show us the entire log for this merge step, every single line, with nothing chopped out. Copy the log as text and paste it into the window that appears when you click on the </> icon.

If the output was not correct, then show us the output you got and the desired output.

Lastly, we cannot write programs to read data from screen captures. Data MUST be provided as SAS data step code, which you can type in yourself of follow these instructions.

Re: Merge two datasets

Tom — Tue, 05 Jul 2022 20:08:43 GMT

Which observations for the year "2018/19" do you want to combine? Both of the pictures you posted have multiple observations with that value.

Re: Merge two datasets

Tamertmg — Wed, 06 Jul 2022 08:54:21 GMT

Thank you Paige for the reply. I will share the SAS data as per instructions