topic Macro doesn't resoleve in file statement csv in SAS Programming

Macro doesn't resoleve in file statement csv

mona4u — Fri, 06 Jul 2018 14:59:15 GMT

Hi,

I'm trying to output a CSV file and the macro can't be resolved for some reasons it output the macro without resolving

ods csvall file='R:Location\Adjudication Status Metrics_&date..csv';

in the destination that's the file name I got

Adjudication Status Metrics_&date.csv

Tom — Fri, 06 Jul 2018 15:01:35 GMT

The macro processor ignores literals inside of single quote characters. Use double quote characters instead.

ods csvall file="R:Location\Adjudication Status Metrics_&date..csv";

Also did you really mean to use a relative path on the R: drive instead of an absolute path?

ods csvall file="R:\Location\Adjudication Status Metrics_&date..csv";

mona4u — Fri, 06 Jul 2018 15:01:24 GMT

Oh. Right

Thanks so much