creating a variable based on the last non-digit-string in another variable

owndan — Thu, 24 Jun 2021 08:19:03 GMT

Hello valued SAS experts,

I am facing the challenge described below and would appreciate an approach/idea on how to solve the problem. My dataset have looks like this:

In the target dataset want there should be a new variable CAR_BRAND which should be created based on the ID according to the following rule:
Always fill the variable CAR_BRAND with the last non-digit string from the variable ID. Accordingly, the dataset want should look like this at the end:

data want;
    input
        ID $
        CAR_BRAND $
    ;
    
    datalines;
        VW VW
        1 VW
        2 VW
        3 VW
        4 VW
        5 VW
        BMW BMW
        6 BMW
        7 BMW
        8 BMW
        9 BMW
        10 BMW
    ;
run;

Thanks in advance for the help/ideas!

Re: creating a variable based on the last non-digit-string in another variable

Amir — Thu, 24 Jun 2021 08:41:22 GMT

Hi @owndan, welcome to the SAS Communities forum and thanks for supplying the data in the form of a data step.

Does the following help?

data want;
   set have;

   length car_brand $ 10;
   retain car_brand;

   if notdigit(strip(id)) then
      car_brand = id;
run;

Thanks & kind regards,

Amir.

topic Re: creating a variable based on the last non-digit-string in another variable in SAS Programming

creating a variable based on the last non-digit-string in another variable

Re: creating a variable based on the last non-digit-string in another variable