topic Re: It keeps coming up with warnings and issues... Help! Importing txt file? in Advanced Programming

It keeps coming up with warnings and issues... Help! Importing txt file?

scottyniven — Mon, 11 Jul 2022 21:16:33 GMT

libname perm 'C:\Users\Eden\OneDrive\Documents';
data perm.fungal;
infile 'C:\Users\Eden\OneDrive\Documents\fungal.txt' firstobs=2
expandtabs;
input patno treat $ age sex $ severity clears
run;

WARNING: The data set PERM.FUNGAL may be incomplete. When this step was stopped there were 0
observations and 7 variables.
WARNING: Data set PERM.FUNGAL was not replaced because this step was stopped.

Re: It keeps coming up with warnings and issues... Help! Importing txt file?

PaigeMiller — Mon, 11 Jul 2022 21:24:17 GMT

Show us the ENTIRE log from this DATA step. Please copy the log as text and paste it into the window that appears when you click on the </> icon.

Re: It keeps coming up with warnings and issues... Help! Importing txt file?

TheresaStemler — Mon, 11 Jul 2022 21:37:08 GMT

It looks like you are missing a semicolon on the INPUT statement.

Re: It keeps coming up with warnings and issues... Help! Importing txt file?

scottyniven — Thu, 14 Jul 2022 14:12:06 GMT

1    libname perm 'C:\Users\Eden\OneDrive\Documents';
NOTE: Libref PERM was successfully assigned as follows:
      Engine:        V9
      Physical Name: C:\Users\Eden\OneDrive\Documents
2    data perm.fungal;
3    infile 'C:\Users\Eden\OneDrive\Documents\fungal.txt' firstobs=2
4    expandtabs;
5    input patno treat $ age sex $ severity clears;
6    run;

ERROR: Physical file does not exist, C:\Users\Eden\OneDrive\Documents\fungal.txt.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set PERM.FUNGAL may be incomplete.  When this step was stopped there were 0
         observations and 6 variables.
WARNING: Data set PERM.FUNGAL was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
      real time           0.07 seconds
      cpu time            0.03 seconds

Re: It keeps coming up with warnings and issues... Help! Importing txt file?

Tom — Thu, 14 Jul 2022 14:17:00 GMT

That error seems obvious. The file doesn't exist. Make sure the file actually exists.

You seem to be using ONEDRIVE so perhaps that is messing things up somehow?

Re: It keeps coming up with warnings and issues... Help! Importing txt file?

SuCheeTay — Mon, 01 Aug 2022 20:42:55 GMT

This does not appear to be a syntax error but rather the input text file fungal.txt does not exist or is misspelled. It also looks like using EXPANDTABS is used to indicate the text file is a tab delimited file.