how to assign values based on condition

vraj1 — Sun, 07 Oct 2018 07:38:09 GMT

i want to assign values for EXD based on the below condition

EXT is "pine", EXD should be assigned by value 2 for the first 2 days, value 4 for the next 2 days and value 6 for the remaining Period A. If EXT is "ozi", EXD should be assigned by value 5 for the first 2 days, value 10 for the next 2 days and value 15 for the remaining Period A.

Attached test data. can any one suggest how to do it.?

Re: how to assign values based on condition

FreelanceReinh — Sun, 07 Oct 2018 12:16:24 GMT

Hi @vraj1,

There are at least two possible interpretations of your criteria and hence different solutions:

The "first 2 days" are days 1 and 2 (according to variable DAY), the "next 2 days" are days 3 and 4 and so on.

data want;
set test(drop=exd);
if period='A' then do;
       if ext='pine' then exd=2*min(int((day+1)/2),3);
  else if ext='ozi'  then exd=5*min(int((day+1)/2),3);
end;
run;

The "first 2 days" with EXT='pine' correspond to the first two observations with PERIOD='A' and EXT='pine' within an ID regardless of DAY (but assuming chronological sort order), etc.

data want;
set test(drop=exd);
by id day;
if first.id then call missing(_cp, _co);
if period='A' then do;
       if ext='pine' then do; _cp+1; exd=2*min(int((_cp+1)/2),3); end;
  else if ext='ozi'  then do; _co+1; exd=5*min(int((_co+1)/2),3); end;
end;                                     
drop _:;
run;

topic Re: how to assign values based on condition in SAS Programming

how to assign values based on condition

Re: how to assign values based on condition