06-27-2016 03:27 PM
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?
06-27-2016 03:48 PM
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.
06-27-2016 03:49 PM
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.
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.
06-27-2016 04:02 PM
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
06-27-2016 04:11 PM
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
06-27-2016 05:08 PM
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?
Need further help from the community? Please ask a new question.