"Why did you use a RETAIN statement for B321 if you did not want the values retained? Why did you use a RETAIN statement for NATBAT when it already exists in the dataset SASHELP.BASEBALL?" Because I'm ignorant. That doesn't entitle you to be condescending.
... View more
data want;
set test;
format z_char $5.;
/* Remove leading */
z_char=strip(put(input(strip(textchar), 5.), 5.));
/* Remove trailing */
P=findc(z_char, "0", 'K', -length(z_char));
if P then Y = substr(z_char, 1, P);
run;
... View more
Could anyone tell me why this sometimes happens if I do not explicitly include an else statement? I was expecting b321 to only equal 1 for nAtBat=321. Most of the time I have no problems with this, but once in awhile I spend half the day troubleshooting and am usually so fed up that I just add all the else statements and say good riddance. But I would like to understand why this happens. To be clear, nAtBat is the 2nd field. I appreciate any input! data bb;
retain b321 nAtBat;
set sashelp.baseball;
if nAtBat=321 then b321=1;
run;
... View more