Desktop productivity for business analysts and programmers

Import Problems

Reply
Occasional Contributor Ted
Occasional Contributor
Posts: 16

Import Problems

Hi, I've got a user who has created a project which starts with an Import of data. This has all worked fine until he got a colleague to run the same Project and gets the following error.

ERROR: Physical file does not exist, /usr/local/sas/***/Lev1/SASNew/TRUNCOVER.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.CRA_CLM may be incomplete.

This is the portion of the code I think it is refering to

OPTIONS DATESTYLE=DMY;
DATA WORK.CRA_CLM;
/* Enterprise Guide creates this temporary asterisk delimited text file from the original data source */

INFILE
TRUNCOVER
DSD
%IF &IsMVS=FALSE %THEN %DO;
LRECL=32767

%END;

The project is saved on a server which each user has to log on to.
Any idea's why this is happening.

Cheers

Ted
Respected Advisor
Posts: 3,788

Re: Import Problems

I can tell you the problem but I don't know what happened to your program probably a macro variable with null value. In the INFILE statement the first parameter is positional and is FILEREF or Physical file. In your code that is missing and TRUNCOVER infile is now the first parameter.

I think SAS then says "truncover is too long for a fileref then it must be a physical file but I can't find" error message.

> ERROR: Physical file does not exist,
> /usr/local/sas/***/Lev1/SASNew/TRUNCOVER.
> INFILE
> TRUNCOVER
> DSD
> %IF &IsMVS=FALSE %THEN %DO;
> LRECL=32767
Ask a Question
Discussion stats
  • 1 reply
  • 147 views
  • 0 likes
  • 2 in conversation