About Rose1

Rose1 · ‎03-22-2021

No, group8 is an arbitrary variable name I am trying to create based on these diagnosis and treatment variables. It does not exist in the input data set. The input for the other variables is something like this - What I want is SAS to code my data based on these variables so it puts out something like this:

Rose1 · ‎03-22-2021

I've attached an example of my input (i've tried with and without parentheses) When I print the new variable "group8", I would expect to see it coded 1,2,3 or 4 for each subject, but it is just blank At the end of this I basically want a new variable "group8" coded so I have 4 levels based on those original variables: treatment 1 + diagnosis 1 = 1 treatment 2 + diagnosis 1 = 2 treatment 1 + diagnosis 2 = 3 treatment 2 + diagnosis 2 = 4 Hope this makes sense. Thank you for your help.

Rose1 · ‎03-22-2021

Hello, I have some data and want to create a new variable from my current variables. I basically want the following outcome: IF var1 = 0 and var2 = 0 then newvariable = 1 If var1 =0 and var2 = 1 then newvariable=2 If var1 = 1 and var2=0 then newvariable = 3 if var1 = 1 and var2=1 then newvariable = 4 I have tried the following and it has not worked Data new; set old; IF var1 = 0 and var2 = 0 then newvariable = 1; else If var1 =0 and var2 = 1 then newvariable=2; else If var1 = 1 and var2=0 then newvariable = 3; else if var1 = 1 and var2=1 then newvariable = 4; RUN; Any help would be greatly appreciated!

Online Status	Offline
Date Last Visited	‎03-23-2021 03:53 AM

Re: How to create a new categorical variable from two other categorica...

Re: How to create a new categorical variable from two other categorica...

How to create a new categorical variable from two other categorical va...

Re: How to create a new categorical variable from two other categorica...

Re: How to create a new categorical variable from two other categorica...

How to create a new categorical variable from two other categorical va...