Macro variable in filename not resolved

[Cornelis]

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

[Ksharp · Accepted solution]

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

[Cornelis]

Thank you for your contribution. it works!

[FreelanceReinh]

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";

[Cornelis]

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