topic Re: need help to input sas code as a source file to SAS in SAS Programming

need help to input sas code as a source file to SAS

Defense — Thu, 04 May 2017 02:35:40 GMT

I try to infile a sas file (CRF.sas) to sas using the following code. The output dataset is “Want”.

data want;

infile "C:\Users\weig3\Desktop\CRF.sas" ;

input col $ 1-300;

RUN;

The CRF.sas contain 6 line as below

The “want” contains only 4 line as below

It sounds the line “data data1 (label=”Demographics”);” is missing( Please see attached file for details.)

Could anyone help me to avoid the error?

Thanks

Reeza — Thu, 04 May 2017 02:42:57 GMT

If you want us to test it, you should upload the text file. To test it, I'd have to type it out and I don't do that on principle 🙂

Try changing LRECL on the infile statement and include the TRUNCOVER option.

infile "C:\Users\weig3\Desktop\CRF.sas" lrecl=300 truncover ;

Defense — Thu, 04 May 2017 02:49:11 GMT

Thanks.

Attached is CRF.sas file

Defense — Thu, 04 May 2017 02:49:13 GMT

Thanks.

Attached is CRF.sas file

Defense — Thu, 04 May 2017 02:54:39 GMT

NOTE: 0 records were read from the infile "C:\Users\weig3\Desktop\CRF.sas".

NOTE: The data set WORK.WANT has 1 observations and 0 variables.

NOTE: DATA statement used (Total process time):

real time 0.03 seconds

cpu time 0.01 seconds

Reeza — Thu, 04 May 2017 03:32:55 GMT

My initial answer was correct in my tests.

Defense — Thu, 04 May 2017 12:28:01 GMT

Thanks.

I did not add "input col $1-300;"

complete code is

data want;

infile "C:\Users\weig3\Desktop\CRF.sas" lrecl=300 truncover;

input col $1-300;

RUN;

Works. Thanks