Solved: Data manipulation of String from Right side - SAS Support Communities

☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.

Quartz | Level 8

Quartz | Level 8

Data manipulation of String from Right side

Posted 05-22-2025 02:17 AM (769 views)

Hello ALL,

I have data like in below format in one column.

/home
/home/warehouse
/home/warehouse/sasirm
/home/warehouse/sasirm/pa
/home/warehouse/sasirm/report
/sso/transport

I want to output as
home
warehouse
sasirm
pa
report
transport

Please provide me one liner combo function which can manipulate data.

1 ACCEPTED SOLUTION

Accepted Solutions

Super User

Super User

Re: Data manipulation of String from Right side

Posted 05-22-2025 03:55 AM (728 views) | In reply to Riteshdell

data have;
input str $80.;
want=scan(str,-1,'/');
cards;
/home
/home/warehouse
/home/warehouse/sasirm
/home/warehouse/sasirm/pa
/home/warehouse/sasirm/report
/sso/transport
;

View solution in original post

2 REPLIES 2

Super User

Super User

Re: Data manipulation of String from Right side

Posted 05-22-2025 03:55 AM (729 views) | In reply to Riteshdell

data have;
input str $80.;
want=scan(str,-1,'/');
cards;
/home
/home/warehouse
/home/warehouse/sasirm
/home/warehouse/sasirm/pa
/home/warehouse/sasirm/report
/sso/transport
;

Quartz | Level 8

Quartz | Level 8

Re: Data manipulation of String from Right side

Posted 05-22-2025 08:25 AM (683 views) | In reply to Ksharp

Thank you, its working.

April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

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!

Call for Content EXTENDED

Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.

Submit your proposal!