topic Re: can i use between in if statement in SAS Programming

can i use between in if statement

vraj1 — Wed, 23 Mar 2016 09:05:44 GMT

Hi,

I want to create a new variable for which i have var1 as 1 to 20.

if var1 is 1 to 10 then create a new var as var2='first' and from 11 to 20 as var2='Last'.

Can i do this in datastep?

Re: can i use between in if statement

RW9 — Wed, 23 Mar 2016 09:22:46 GMT

Yes, that is no problem:

data want;
 do var1=1 to 20;
   var2=ifc(var1<=10,"First","Last");
   output;
 end;
run;

Not sure why you think you would not be able to do that in a datastep?

Re: can i use between in if statement

vraj1 — Wed, 23 Mar 2016 09:28:34 GMT

Yes, but this step is also doubling the obs.

I want like

id var1 var2

101 1 first

102 2 first

103 19 last

Re: can i use between in if statement

Kurt_Bremser — Wed, 23 Mar 2016 09:39:28 GMT

No, it is not doubling the obs:

data have;
input id var1;
cards;
101 1
101 10
101 15
;
run;

title "Dataset HAVE";

proc print;
run;

data want;
set have;
var2=ifc(var1<=10,"First","Last");
run;

title "Dataset WANT";

proc print;
run;

gives this result:

                                                            Dataset HAVE

                                                         Obs     id    var1

                                                          1     101      1 
                                                          2     101     10 
                                                          3     101     15 
                                                            Dataset WANT

                                                    Obs     id    var1    var2

                                                     1     101      1     First
                                                     2     101     10     First
                                                     3     101     15     Last

You see, there are the same number of observations in both datasets.

Maybe you need to be more specific with your requirements.

Re: can i use between in if statement

RW9 — Wed, 23 Mar 2016 09:45:40 GMT

Your requirement states, and I quote:

"I want to create a new variable for which i have var1 as 1 to 20."

Therefore your output dataset will have 20 observations, per my code. If you requirements are not like, please clarify your problem, post test data - in the form of a datastep, and what the output should look like.

Re: can i use between in if statement

FreelanceReinh — Wed, 23 Mar 2016 12:26:18 GMT

Hi @vraj1,

I see. You "want to create a new variable" in an existing dataset "for which [you] have var1 as 1 to 20."

Whether you really need a new variable (with redundant information!) depends on what you plan to do with it. Maybe it's sufficient to create a format:

proc format;
value grp
 1-10 = 'first'
11-20 = 'last';
run;

You can do many things with your existing VAR1 together with this format. For example, perform a frequency count:

proc freq data=have;
format var1 grp.;
tables var1;
run;

If you really need the new variable, you can still create it using the format:

data want;
set have;
var2=put(var1, grp.);
run;