Import Problems

Ted — Wed, 21 Jan 2009 09:44:44 GMT

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

Re: Import Problems

data_null__ — Wed, 21 Jan 2009 11:23:05 GMT

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

topic Import Problems in SAS Enterprise Guide

Import Problems

Re: Import Problems