BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
SASAna
Quartz | Level 8

Hi SAS users,

 

 

i need some help in going to last  word which is after  last slash (/) and get word  "file" ( scan and find the first word after first underscore(_)

currently i am printing all words. 

 

%let filenm=/path1/div1/test1/list1/file_client_case1;



data run_type;
length type $30;
do i=1 to countw("&filenm.","/");
type=scan("&filenm.",i,"/");
output;
end;
run;

Thanks,

Ana

1 ACCEPTED SOLUTION

Accepted Solutions
novinosrin
Tourmaline | Level 20

%let filenm=/path1/div1/test1/list1/file_client_case1;



data run_type;
length type $30;
type=scan(scan("&filenm.",-1,"/"),1,'_');
run;

View solution in original post

2 REPLIES 2
novinosrin
Tourmaline | Level 20

%let filenm=/path1/div1/test1/list1/file_client_case1;



data run_type;
length type $30;
type=scan(scan("&filenm.",-1,"/"),1,'_');
run;
SASAna
Quartz | Level 8
Thanks for the help . It worked very well.
How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 12779 views
  • 0 likes
  • 2 in conversation