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

qadri0345 — Mon, 08 Jul 2024 21:36:10 GMT

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!

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

A_Kh — Mon, 08 Jul 2024 22:04:48 GMT

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;

topic How can I change a postal code variable to a 1 or an "Available" in SAS Programming

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

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