DATA Step, Macro, Functions and more

Reading from text file

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 8
Accepted Solution

Reading from text file

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.


Accepted Solutions
Solution
‎02-02-2014 11:48 PM
Respected Advisor
Posts: 4,646

Re: Reading from text file

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

PG

View solution in original post


All Replies
Solution
‎02-02-2014 11:48 PM
Respected Advisor
Posts: 4,646

Re: Reading from text file

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

PG
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 152 views
  • 0 likes
  • 2 in conversation