topic Re: double trailing option in SAS Programming

double trailing option

Bal23 — Mon, 27 Jun 2016 19:27:37 GMT

I tried to use sas to read a large raw dataset. It can read the first 100+ variables but the rest values are all missing.

INPUT  
@8 id $1.	 @@;
run;

SAS ran very slowly without error message. Any advice?

Re: double trailing option

Astounding — Mon, 27 Jun 2016 19:48:59 GMT

Advice: don't retest this under any circumstances.

It's likely that someone canceled the job. This is an infinite loop, that continuously reads the contents of column 8 from the first line of raw data.

Perhaps there are later statements that might cause the program to eventually finish on its own. More likely, it began taking up so much disk space that an administrator took action.

Re: double trailing option

Riteshdell — Mon, 27 Jun 2016 19:49:51 GMT

I am not understadning your question completly, but I am guessing , your record length is less.

So just try to increase the length of input data file.

syntax:

LINESIZE=n | MIN | MAX | hexX

give maximum length of record.

LS= 1024(I am assuming max number).

try this or let us know complete issue.

Re: double trailing option

Bal23 — Mon, 27 Jun 2016 20:02:15 GMT

LINESIZE=256

 

LS= 1024

I do not know I understand it correctly, when i add @@ and put these two you mentioned, it still ran so slowly and had to terminate each time

Re: double trailing option

Riteshdell — Mon, 27 Jun 2016 20:08:33 GMT

why you are using double trail option to read it...

@@ is used to divide varible name in to two observation.....any specific requirement for using double trail?

Re: double trailing option

Bal23 — Mon, 27 Jun 2016 20:11:54 GMT

Thanks. no i only want sas not stop readding

I only want SAS to read all those correctly. Now it can only read the first 100+ variables, leaving the rest 50 variables missing values/blank

I have set linesize=32767

still same

Re: double trailing option

Reeza — Mon, 27 Jun 2016 20:58:18 GMT

Can you post a sample of your data? Is it possible you have a line feed character that would cause reading a line to be truncated?

Re: double trailing option

Bal23 — Mon, 27 Jun 2016 21:08:14 GMT

Would you please let me know the line feed chacters.

I tried to create a sample dataset, it wonot work

currently the code can read the first 180 variables, only 20 var values are missing. Because many obs lack of values for many variables, it is hard to tell exactly which variable it stops at

I find it canot read a certain date

it might be the format of date, any advice for that

or maybe because of space for next page?

Re: double trailing option

Astounding — Mon, 27 Jun 2016 21:14:58 GMT

It would also help to see the full INPUT statement. The one you posted doesn't match the results you are describing.