topic Using 2 variables with same name from different datasets in New SAS User

Using 2 variables with same name from different datasets

beleeve — Fri, 10 Mar 2023 20:17:16 GMT

I'm trying to run bivar logistic regression on 2 variables but from 2 datasets that have the same var names just from different timepoints. I've listed the code I have so far but essentially, var 2 needs to be from the first dataset and var 1 and 3 need to be from a combination of both datasets. I've tried renaming the variable that needs data from only one data set but when I add the other set, there are fewer values for some reason.

data work.asdf;
set 'dataset1'(rename=(var2=var2a));

set 'dataset2';

...

This is what I was trying to run:

proc sort;
by var1;

proc freq;
by var1;
table var2a*var3 / expected cellchi2 chisq;

run;

Re: Using 2 variables with same name from different datasets

Quentin — Fri, 10 Mar 2023 20:23:31 GMT

Hi,

It's hard to understand your goal. Can you please show five records of dataset1, five records of dataset2, and what you want to create when you combine them into work.asdf?

If you are combining variables from dataset1 and dataset2, typically you would do that with a MERGE statement.

If you are combining rows from dataset1 and dataset2, typically you would do that with a single SET statement which lists both datasets.

Your current code, with two SET statements, is almost certainly not doing what you want. But I'm not sure what you're trying to do, so not sure how to help.

Re: Using 2 variables with same name from different datasets

ballardw — Fri, 10 Mar 2023 20:57:26 GMT

You might also indicate exactly how you need to use the variable with the same name.

You can add an variable than indicates which data set a specific record comes from such as

data work.combined;
   set dataset1  (in=in1)
         dataset2  (in=in2)
   ;
   if in1 then Source='Dataset1';
   else if in2 then Source='Dataset2';
run;

You could then use the Source variable in analysis to differentiate between the original set such as

proc freq data=combined;
   tables source*var2;
run;

Note that multiple SET statements, while allowed by syntax, will get you into some pretty complex behaviors. I suspect that you only have as many records from the larger data set as appeared in the smaller one, especially if dataset1 is the smaller.