https://communities.sas.com/t5/SAS-Programming/Data-manipulation-of-String-from-Right-side/m-p/967200#M376306 <PRE>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 ; </PRE> Thu, 22 May 2025 07:55:58 GMT Ksharp 2025-05-22T07:55:58Z https://communities.sas.com/t5/SAS-Programming/Data-manipulation-of-String-from-Right-side/m-p/967194#M376304 <P>Hello ALL,</P><P>&nbsp;</P><P>I have data like in below format in one column.</P><P>&nbsp;</P><P>/home<BR />/home/warehouse<BR />/home/warehouse/sasirm<BR />/home/warehouse/sasirm/pa<BR />/home/warehouse/sasirm/report<BR />/sso/transport</P><P>&nbsp;</P><P>I want to output as&nbsp;<BR />home<BR />warehouse<BR />sasirm<BR />pa<BR />report<BR />transport<BR /><BR />Please provide me one liner combo function which can manipulate data.</P> Thu, 22 May 2025 06:17:01 GMT https://communities.sas.com/t5/SAS-Programming/Data-manipulation-of-String-from-Right-side/m-p/967194#M376304 Riteshdell 2025-05-22T06:17:01Z https://communities.sas.com/t5/SAS-Programming/Data-manipulation-of-String-from-Right-side/m-p/967200#M376306 <PRE>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 ; </PRE> Thu, 22 May 2025 07:55:58 GMT https://communities.sas.com/t5/SAS-Programming/Data-manipulation-of-String-from-Right-side/m-p/967200#M376306 Ksharp 2025-05-22T07:55:58Z https://communities.sas.com/t5/SAS-Programming/Data-manipulation-of-String-from-Right-side/m-p/967210#M376309 <P>Thank you, its working.</P> Thu, 22 May 2025 12:25:46 GMT https://communities.sas.com/t5/SAS-Programming/Data-manipulation-of-String-from-Right-side/m-p/967210#M376309 Riteshdell 2025-05-22T12:25:46Z