10-17-2017 12:51 PM - edited 10-17-2017 01:00 PM
I am trying to pull a string out from a free text. I was able to use the substring and find function to pull out the specific area around the string. but there are periods marking the end of a sentence that I would like to remove. Not all rows have a period at the end (my assumption would be I could use compress, but then any decimals would be removed as well.
And I would like:
I was thinking maybe I could use the find function to find the second period and then delete? Any suggestions would be much appreciated.
EDIT: My apologies, I forgot to remove the string
10-17-2017 01:00 PM
I agree with the other posters, your test data is wrong. One solution:
data want; set have; if char(thestring,lengthn(thestring)-1)="." then thestring=substr(thestring,1,lengthn(thestring)-1); run;
As you haven't provided test data in the form of a datastep I have made up a variable thestring.
Need further help from the community? Please ask a new question.