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!
zone_from = substr(left(from),1,1));
The left() function left-adjusts the contents and so eliminates any leading blanks, if such were present.
zone_from = substr(left(from),1,1));
The left() function left-adjusts the contents and so eliminates any leading blanks, if such were present.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.