topic Extracting words from a string after a specific character in SAS Programming

Extracting words from a string after a specific character

lisa2002 — Mon, 30 Dec 2019 21:34:33 GMT

Hello SAS experts,

I have a string of characters that I need everything before '.csv' and I fail to get the whole thing

this is literally how they are naming the files and the file names can not be changed...

Valdoste T.C. 8-19.csv

Valdoste T.C Nov 2019.csv

Valdoste T.C. Sept 2019.csv

Valdoste T.C. December 2018.csv

I keep changing to '.' and '-' and to the 1,2,3 word but nothing is working. I new to sas so what seems like an easy fix has me going round and round. please assist.

code

data dirlist3 ;
set want;

Sheetname1=scan(name,2,'-');

run;

Re: Extracting words from a string after a specific character

PaigeMiller — Mon, 30 Dec 2019 21:59:18 GMT

Sheetname1=tranwrd(name,'.csv','');

Re: Extracting words from a string after a specific character

novinosrin — Mon, 30 Dec 2019 21:41:34 GMT

Try

want=substr(str,1,find(str,'.csv','i')-1);

Re: Extracting words from a string after a specific character

unison — Mon, 30 Dec 2019 22:21:16 GMT

If they all end in ".csv", then replace the last 4 characters with '' (null).

data have;
	length name $50.;
	name = 'Valdoste T.C. 8-19.csv';
	output;
	name = 'Valdoste T.C Nov 2019.csv';
	output;
	name = 'Valdoste T.C. Sept 2019.csv';
	output;
	name = 'Valdoste T.C. December 2018.csv';
	output;
run;

data want;
	set have;
	substr(name,length(name)-3,4)='';
run;

Re: Extracting words from a string after a specific character

novinosrin — Mon, 30 Dec 2019 22:36:52 GMT

Hi @unison You know what, At 5:36 PM my eyes are red and damn tired and I wanna get a can of beer, go home and crash. That simplicity in your solution has alerted me to go home and crash. Well thought out. Kudos!

Re: Extracting words from a string after a specific character

ed_sas_member — Tue, 31 Dec 2019 08:08:25 GMT

Sheetname1=prxchange('s/\.csv//', 1, name);