Desktop productivity for business analysts and programmers

add computed column based on first letter of previous column

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 13
Accepted Solution

add computed column based on first letter of previous column

Hi all,

 

I would like to add an indicator column named 'Zone' for postcode data for  'From' and 'To' in my shipment dataset.

These columns are of character format.

 

I have data as below:

ShipmentID    Typeofservice   From     To       Quantity      Price

     xx1                    y              1010     2010        5               100

     xx2                    y              3030     1050        4               80

     xx3                    z              2010     4050        4               100

     xx4                    y              7050     1010        2               150

 

so above I would like to create a column named Zone dependent on the first letter of the From and To columns..

which means

1000 - 1999 is zone 1...

2000-2999 is zone 2

3000-3999 is zone 3 and so on...

 

Thank you in advance for any help!

 

 


Accepted Solutions
Solution
‎03-05-2018 07:27 AM
Super User
Posts: 9,593

Re: add computed column based on first letter of previous column

zone_from = substr(left(from),1,1));

The left() function left-adjusts the contents and so eliminates any leading blanks, if such were present.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code

View solution in original post


All Replies
Solution
‎03-05-2018 07:27 AM
Super User
Posts: 9,593

Re: add computed column based on first letter of previous column

zone_from = substr(left(from),1,1));

The left() function left-adjusts the contents and so eliminates any leading blanks, if such were present.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Occasional Contributor
Posts: 13

Re: add computed column based on first letter of previous column

Posted in reply to KurtBremser
brilliant! thanks Kurt Smiley Happy
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 106 views
  • 1 like
  • 2 in conversation