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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.