How can I change a postal code variable to a 1 or an "Available"

[qadri0345]

Hello 🙂

Hoping I can get some help here. I have a variable that has postal codes listed for case ID's. Some are available and some are not. I am trying to re-code my 'Postal Code' variable so that it either has 0 for missing and 1 for available, or I can also change it to "Available" and "Not Available" ...I managed to change the missings to 0 but I can't figure out how to change the many diff postal codes into a single number or word. Any help would be really appreciated!

[A_Kh]

If you have recoded 'Missing' as 0 you should be able to recode the 'Non-missing' values to 1 eg., with simply IF/THEN, ELSE statement:

data want;
	set have;
	if not missing(PostalCode) then PostalCode=1;
	else PostalCode=0;
run;