topic Re: Macro variable in filename not resolved in SAS Programming

Macro variable in filename not resolved

Cornelis — Wed, 19 Jun 2024 08:02:13 GMT

Dear SAS users,

The macro variable "thisyear" cannot be resolved in the Filename statement.

%let thisyear = 2024;

filename DIRLIST2 pipe 'dir "\\msnlgoudcp3102\nlgouddata\GLC\LZ-analyses\to be printed\&thisyear\vetzuur" /s';

data dirlist_LZ;
     length buffer $256 ;
	 format file $200. GLC_where $3.;
     infile dirlist2 length=reclen ;
     input buffer $varying256. reclen;
run;

Could you please offer a solution how to solve?

Thank you,

Cornelis

Re: Macro variable in filename not resolved

Ksharp — Wed, 19 Jun 2024 08:25:50 GMT

filename DIRLIST2 pipe %sysfunc(quote(dir "\\msnlgoudcp3102\nlgouddata\GLC\LZ-analyses\to be printed\&thisyear\vetzuur" /s));

Re: Macro variable in filename not resolved

FreelanceReinh — Wed, 19 Jun 2024 08:27:06 GMT

Hello @Cornelis,

The outer single quotes prevent the resolution of the macro variable reference. Use double quotes instead and duplicate the existing inner double quotes:

filename DIRLIST2 pipe "dir ""\\msnlgoudcp3102\nlgouddata\GLC\LZ-analyses\to be printed\&thisyear\vetzuur"" /s";

Re: Macro variable in filename not resolved

Cornelis — Wed, 19 Jun 2024 08:33:43 GMT

Thank you for your contribution. it works!

Re: Macro variable in filename not resolved

Cornelis — Wed, 19 Jun 2024 08:35:47 GMT

Indeed, this option works also. Great to see that there are different option and of course, your prompt action.