ERROR: Physical file does not exist ( macro)

[adil256]

Hi everyone,

I create a variable to store the file directory in it in order to modify the path easier in the futur but when i run the sas code I get this error "ERROR: Physical file does not exist." It works perfectly when i refer the path in the Infile statement.

I begin my code with :

%let path=H:\database\SAS\Txt_file\Database.txt;

then I import my txt file.

DATA MyDB;
             LENGTH
              ...
             FORMAT
              
              ...
             INFORMAT
               
              ...

            INFILE '&path'
                LRECL=584                             
                ENCODING="WLATIN1"
                DLM=';'
                MISSOVER
                DSD 
                firstobs=2;
            
INPUT
              ...
        RUN;

 thank u in advance

[novinosrin]

Macro variable references do not resolve withing single quotes when called within a string literal.

Try

INFILE "&path"

[Kurt_Bremser]

Macro variables are not resolved when enclosed by single quotes. Use double quotes in your infile statement.

[RW9 · Accepted solution]

Hi,

Why not just put it in a filename statement rather than juming through macro loops?:

filename dbfile 'h:\database\sas\txt_file\database.txt';

data mydb;
  length ...;
  format ...;
  informat ...;
  infile dbfile lrecl encoding="wlatin1" dlm=";" missover dsd firstobs=2;
  input ...;
run;

Also, considering coding in lower case, it makes code easier to read.

[adil256]

Because i didn't know the statement. Now I know :-D.

Thanks and sorry for upper case.