About edoyle1

edoyle1 · ‎12-15-2023

That did it, thanks!

edoyle1 · ‎12-14-2023

I have data in a txt file. I'm trying to figure out how to specify that a special character (or multiple characters) signify the end of a line of data. In the example below, the ~ and the * are the characters which signify that the row of data is complete and it's time for a new row. The data set HAVE is how I'm currently reading the data in. The data set WANT is how I want it to look. data HAVE; infile datalines truncover; input line $500.; datalines ; cat dog ~ mouse cat rat* cat snake * dog bat rat~cat~ ; run; WANT Obs line 1 cat dog ~ 2 mouse cat rat* 3 cat snake* 4 dog bat rat~ 5 cat~ Is this possible? Thanks in advance for any help.

edoyle1 · ‎12-11-2023

Thanks!

edoyle1 · ‎12-08-2023

In the code below, I'm trying to get yr='2018'. Instead it is blank. What am I doing wrong? Using SAS 9.4. data out; retain prx_yr; if _n_=1 then do; prx_yr=prxparse('/20\d\d/'); end; text='dir 2018 - Subject'; p=prxmatch(prx_yr,text); if prxmatch(prx_yr,text) then yr=prxposn(prx_yr,1,text); output; run;

Online Status	Offline
Date Last Visited	‎12-15-2023 12:43 PM

Re: Reading in data--special characters trigger new line

Reading in data--special characters trigger new line

Re: prxposn

prxposn

Re: Reading in data--special characters trigger new line

Reading in data--special characters trigger new line

Re: prxposn

prxposn