Hi,
I have a simple problem I want to solve. I have a column where the output is, ex. 1303/0000/1. But I only need '1303' that I'll eventually convert into a currency value later.
Current output
Desired output
STATUS_CD | SALES_NPV |
S04 | 1302 |
S04 | 1485 |
S04 | 0967 |
For this they have invented the SUBSTR function:
SALES_NPV = SUBSTR(SALES_NPV, 1, 4);
This function is very basic. I would recommend you have a look at the other SAS functions as well.
Regards,
- Jan.
Since you have the / as a delimiter you can also use the SCAN() function.
I can name that tune with 0 functions:
data want;
length sales_npv $ 4;
set have;
run;
There's only room to save the first four characters, once the length has been defined.
Thanks everyone! I was almost too embarassed to ask.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: