topic Re: Simplify the repeat format procedure? in SAS Programming

Simplify the repeat format procedure?

ybz12003 — Fri, 31 Jan 2020 22:45:48 GMT

Hello,

I have the follow repeat coding. Any idea how to simply them? Thanks.

data want (drop = A B C);
	set test;
	if A in ('No', 'n') then AA=0;
	if A in ('Yes', 'y') then AA=1;

	if B in ('No', 'n') then BB=0;
	if B in ('Yes', 'y') then BB=1;

	if C in ('No', 'n') then CC=0;
	if C in ('Yes', 'y') then CC=1;

run;

Re: Simplify the repeat format procedure?

novinosrin — Fri, 31 Jan 2020 22:54:47 GMT


data want;
 set test;
 array t a b c;
 array u  aa bb cc;
 do over t;
  if t in ('No', 'n') then u=0;
  else if t in ('Yes', 'y') then u=1;
 end;
 drop a b c;
run;

Alternatively, you can use PROC Format aka User defined format/In-format as a look up.

Re: Simplify the repeat format procedure?

SASKiwi — Fri, 31 Jan 2020 22:56:02 GMT

Arrays are good for this:

data want (drop = A B C);
 set test;
 array answers (*) A B C;
 array answers_flag (*) AA BB CC;
 do i = 1 to dim(answers); 
  if answers(i) in ('No', 'n') then answers_flag(i)=0;
  else if answers(i) in ('Yes', 'y') then answers_flag(i)=1;
end;
run;

Re: Simplify the repeat format procedure?

ybz12003 — Fri, 31 Jan 2020 22:58:05 GMT

Thank you so much for all of your wonderful help!

Re: Simplify the repeat format procedure?

ballardw — Mon, 03 Feb 2020 17:22:33 GMT

For some of these things I prefer informats.

proc format library=work;
invalue myyesno (upcase)
'NO','N' = 0
'YES','Y' =1
' '=.
other= _error_;
run;

data example;
   infile datalines truncover;
   informat a myyesno.;
   input a;
datalines;
Y
y
Yes
YES
yEs
N
n
NO
no
nO

YN
3
;

Note the definition has (UPCASE). That means SAS will make the value uppercase before comparing to the key values. So if you have issues with humans entering data where the case may change as shown then you still get expected results. The explicit case of missing, ' ', allows the use of the other predicate to create warnings for invalid/unexpected data values as shown.

The informats can be used with an input statement if you already have the data read:

AA = input(a,myyesno.);

BB = input(b,myyesno.);

CC = input(c,myyesno.);

(or array). If there were 25 of these variables the array approach becomes very preferred.

Note that since the informat creates a numeric value there is no $ at the start of the informat name.