topic Re: Creating a new column in New SAS User

Creating a new column

Ramin1 — Sun, 20 Dec 2020 03:44:47 GMT

Actually, I want to create a new column name h_67 which will be equal one if the column/variable avg_percent_moneyness >=.67 twice within the sample period otherwise it will be zero. Here, in the code count function is not working as is it not correct. I need help in this regard, hope I will get the reply from you.
I tried the following code but it does not work. Variable holder in the data, is equal 1 if avg_percent_moneyness>= .67 or remains o

Data want;
set have;
If (count(avg_percent_moneyness>=.67))>=2 then holder_67=1;
else 0;
run;

Re: Creating a new column

PGStats — Mon, 21 Dec 2020 14:28:55 GMT

Assuming that by sampling period you mean by gvkey (?), you could use two do until() loops:

data want;
count = 0;
do until (last.gvkey);
    set sasforum.t; by gvkey;
    if avg_percent_moneyness >= 0.67 then count + 1;
    end;
h_67 = count >= 2;
do until (last.gvkey);
    set sasforum.t; by gvkey;
    output;
    end;
drop count;
run;

Re: Creating a new column

Ramin1 — Mon, 21 Dec 2020 06:02:26 GMT

Thanks a lot for your quick reply, PGStats. Sampling period means, I have 20 years of data and if the executive scored more than .67 in avg_percent_moneyness twice within that sample year then h_67 will be 1 for that person else 0. I forget to give you one more column in the data that is the ID for each executive and I use by executive id in the do until loop.
In the second do until loop, is it outout or it should be output? When I code outout SAS corrected it as output.

Re: Creating a new column

PGStats — Mon, 21 Dec 2020 14:30:10 GMT

I edited my post. I meant output, of course.