topic Reading a data from external file in SAS in SAS Programming

Reading a data from external file in SAS

Abhi1212 — Tue, 15 Mar 2016 18:23:57 GMT

Hi,

How to read a data from an external file and store it in a variable.

For example,

Say i have a external file with 62K thousand records. There is no space delimiters nothing. However, i need to read 1 to 30k records and store it A variable and 30K to 60l records i need to store it in B variable. Please guide me how i can achieve.

Thanks,

Abhi

Re: Reading a data from external file in SAS

DartRodrigo — Tue, 15 Mar 2016 19:04:11 GMT

Hi mate,

Try to use the infile and input:

One for the first 30000 values:
  Infile "Your-file.txt" dlm = " " firstobs=1 obs=30000;
  input #1 entire_row1 $1-220;

One for the last values:
  Infile "Your-file.txt" dlm = " " firstobs=30000 obs=62000;
  input #1 entire_row2 $1-220;

Hope this helps

Re: Reading a data from external file in SAS

LinusH — Tue, 15 Mar 2016 21:02:28 GMT

It's a bit unclear what you want to do.

Do you have a text file that is just...text...no natural variables...?

And then, you want to store 30K (no of?) records (how long is a record) into a variable. A data set variable?

Could it be that you are mixing up the terminology. 30K of text (chars), into one variable...?

Then, I'm a bit curious, what's the application?

Re: Reading a data from external file in SAS

Abhi1212 — Wed, 16 Mar 2016 03:58:26 GMT

Hi,
The file is seem to be like extracted from copybook.. As I already
explained. .With that data I need to create a table in SAS. I have
attached the template and raw data. The data starts from ALH ends with the
time. At the middle we have delimiters space and ^T we have to avoid those.
And if suppose the file exceeds the maximum variable size which is 32K at
that case how can I read the data. This is my question.

##- Please type your reply above this line. Simple formatting, no
attachments. -##

Re: Reading a data from external file in SAS

Abhi1212 — Wed, 16 Mar 2016 04:00:26 GMT

Where u r defining the variable like. . Which set of data will be set in A
variable and which in B?

##- Please type your reply above this line. Simple formatting, no
attachments. -##

Re: Reading a data from external file in SAS

DartRodrigo — Wed, 16 Mar 2016 12:37:54 GMT

In my guess, Linus, he want to split his import in two variables.

From the line 1 to 32k will be set in variable A and the last lines will be set in variable B.

Just like

infile "file" firstobs=1 obs=32000;
input Entire_Row1 $1-220; /*This var starts in line one until 32k*/

input Entire_Row2 $1-220; /*This var starts in line 32001 until 62k*/