Help with a if then statement

NewUserFrank — Wed, 21 Oct 2009 21:33:36 GMT

I'm a new user to SAS and am in the process of updating someone elses code, for the most part no issues, except this one which has left me puzzled. I'm running a data step that is adding new fields (only showing one in my example) and applying formats run earlier as part of a Proc Format process.

Issue: When the process runs, only one of the formats is pickedup. Meaning, all records regardless of bsnss_unt_id get the same format . . . any help would be appreciated

data Table5;
set Table4;

naalr_bnd = naalr_scr;

/* groups naalr band */
if bsnss_unt_id = 702 then do;
format naalr_bnd naalrs.;
end;
else if bsnss_unt_id = 803 then do;
format naalr_bnd naalra.;
end;

run;
endrsubmit;

proc format;
value naalra
0 - 0 = '01_000-000'
1 - 349 = '02_001-349'
350 - 354 = '03_350-354'
355 - 359 = '04_355-359'
360 - 364 = '05_360-364'
365 - 369 = '06_365-369'
370 - 374 = '07_370-374'
375 - 379 = '08_375-379'
380 - 384 = '09_380-384'
385 - 389 = '10_385-389'
390 - 394 = '11_390-394'
395 - 399 = '12_395-399'
400 - 404 = '13_400-404'
405 - 409 = '14_405-409'
410 - 414 = '15_410-414'
415 - 419 = '16_415-419'
420 - 424 = '17_420-424'
425 - 429 = '18_425-429'
430 - 434 = '19_430-434'
435 - 439 = '20_435-439'
440 - high= '21_440-999 '
other = 'missing';

value naalrs
0 - 384 = '01_000-384'
385 - 399 = '02_385-399'
400 - 414 = '03_400-414'
415 - 424 = '04_415-424'
425 - 459 = '05_425-459'
460 - high= '6_460+'
other = 'missing';

Re: Help with a if then statement

Cynthia_sas — Wed, 21 Oct 2009 22:34:35 GMT

Hi:
I believe the problem is not with the IF statement, per se, but with understanding the difference between "execution-time" statements and "compile-time" statements. As explained in this documentation topic, the format statement is a "declarative" statement that only gets used by SAS one time in a program -- at compile time.
http://support.sas.com/documentation/cdl/en/lrdict/62618/HTML/default/a001225397.htm

Perhaps you meant to create the variable NAALR_BND from NAALR_SCR by using the PUT function with the appropriate format. Something like this:
[pre]
data table5;
set table4;
length naalr_bnd $10;

if bsnss_unt_id = 702 then do;
naalr_bnd=put(naalr_scr, naalrs.);
end;
else if bsnss_unt_id = 803 then do;
naalr_bnd= put(naalr_scr, naalra.);
end;
else do;
naalr_bnd = naalr_scr; /* this will be an unformatted value */
end;
run;

[/pre]

If you could possibly have more than 2 values for bsnss_unt_id, you might want to code a final ELSE condition.
cynthia

topic Re: Help with a if then statement in SAS Procedures

Help with a if then statement

Re: Help with a if then statement