topic Re: Combining variables in SAS Procedures

Combining variables

UGAstudent — Fri, 08 Mar 2019 17:23:37 GMT

Hello,

I would like to know to combine 2 variables into one. For instance, if we are talking about admission to colleges, one variable would be 'undergrad' and the other would be 'masters'. I want to combine all the yes and no's from 'undergrad' and 'masters' into one variable called 'admittance'. I then want to use 'admittance' to do a bi-variate comparison or logistical regression with another variable say 'gender' how would I do this?

Re: Combining variables

PaigeMiller — Fri, 08 Mar 2019 17:48:34 GMT

Can you tell us what values 'admittance' should have when we combine the YES and NO values in 'undergrad' and 'masters'?

Re: Combining variables

ballardw — Fri, 08 Mar 2019 18:25:10 GMT

Example Input;

Desired example output.

For all possible cases of your variables.

Also do you want a numeric or character result?

Re: Combining variables

UGAstudent — Fri, 08 Mar 2019 18:45:13 GMT

I would like 'yes' and 'no' for admittance results as well

Re: Combining variables

UGAstudent — Fri, 08 Mar 2019 18:48:19 GMT

I would like 'yes' and 'no' for admittance results as well? w\Would there be an issue for a dis-coordinate input?Say 'yes' to undergrad and no to 'masters'?

Re: Combining variables

PaigeMiller — Fri, 08 Mar 2019 18:51:36 GMT

What you said doesn't really seem to answer the question. We need to know your logic in determining whether Admittance gets a YES or a NO.

There are four cases:

Undergrad        Masters          Admittance
YES                  NO                 ???
YES                  YES                ???
NO                    YES               ???
NO                    NO                ???

Tell us what value you want for Admittance in each of the four cases.

Re: Combining variables

UGAstudent — Mon, 25 Mar 2019 19:34:44 GMT

Undergrad        Masters          both Admittance
YES                  NO                 ???
YES                  YES                Yes
NO                    YES               ???
NO                    NO                ???

in this case, 'admittance' needs to only represent people who got into both undergrad and masters