I have a text file that has really long string with delimiter as ^ inbetween.
I want to read in this file as SAS dataset such it will be read in under a single varaibale (Say VAR1) with different observations whenever it encounters the delimiter '^'
Say the text file is as below
"This is my text file this is my text file ^ This is my ^ This is "
and the dataset should be read in as below
OBS VAR1
1 This is my text file this is my text file
2 This is my
3 This is
Is there any way to read in this text file as the example shown above? SAS Gurus, Please advise.
Simply use option DLM= and hanging @@ :
data want;
infile datalines dlm='^';
length var1 $64;
input var1 @@;
datalines;
This is my text file this is my text file ^ This is my ^ This is
This is my text file this is my text file ^ This is my ^ This is
This is my text file this is my text file ^ This is my ^ This is
;
proc print data=want noobs; run;
PG
Simply use option DLM= and hanging @@ :
data want;
infile datalines dlm='^';
length var1 $64;
input var1 @@;
datalines;
This is my text file this is my text file ^ This is my ^ This is
This is my text file this is my text file ^ This is my ^ This is
This is my text file this is my text file ^ This is my ^ This is
;
proc print data=want noobs; run;
PG
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.