topic how to extract The last 4 characters or numbers of a variable in SAS in SAS Programming

how to extract The last 4 characters or numbers of a variable in SAS

aalyoseef — Thu, 19 Nov 2020 03:04:27 GMT

Provide a list of all customers by name, the customer’s street address, the customer’s city/state/zip code
(concatenated into a single field such as Radford, VA 24142 – do not show the last 4 digits of the zip code and
make sure that any extra spaces are eliminated) as Address, the customer’s phone number, the name of the pet
and the pet’s date of birth for all animals who are not current on their vaccinations (do not show the vaccination
field in your results).

Re: how to extract The last 4 characters or numbers of a variable in SAS

ballardw — Thu, 19 Nov 2020 03:41:54 GMT

Example data, some values, variable names, something to work with. Approach makes a big difference on what you have.

And what have you tried?

Re: how to extract The last 4 characters or numbers of a variable in SAS

andreas_lds — Thu, 19 Nov 2020 06:13:25 GMT

Hardly possible to suggest something useful without seeing the data you have and what you already tried.

Some hints:

to control which variable is written to a dataset, use keep OR drop statement
alphanumeric variables are always padded with blanks to fill the length, so "make sure that any extra spaces are eliminated" could be a challange
the if-statement is used to decide which observation to write to a dataset