One of my variable looks as follows:
| STAGE_9 |
| 1.0=LIMITED |
| 10.0=IN SITU |
| 11.0=RAD OCCULT |
| 2.0=EXTENSIVE |
| 3.0=STAGE IA |
| 4.0=STAGE IB |
| 5.0=STAGE IIA |
| 5.5=EARLYSTAGE |
| 6.0=STAGE IIB |
| 7.0=STAGE IIIA |
| 7.5=LATESTAGE |
| 8.0=STAGE IIIB |
| 9.0=STAGE IV |
| N |
| U |
How can I truncate the variable base on the "=" sign and make it 1.0, 2.0 etc.
Thank you!
stage9 = scan(stage9,1,'=');
in a data step, of course.
stage9 = scan(stage9,1,'=');
in a data step, of course.
function compress will work even stage_9='U' or 'N'.
new_stage_9=compress(stage_9, '.','kd');
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
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.
Ready to level-up your skills? Choose your own adventure.