topic Resolving a macro variable inside of proc format in SAS Programming

Resolving a macro variable inside of proc format

Bill — Mon, 27 Jun 2011 18:08:27 GMT

My code:

proc format;

value &mkt

other="%nrstr(&custname);

run;

This does not resolve to the intended name but remains as &custname. Can anyone help?

Thank you,

Bill

Resolving a macro variable inside of proc format

garybald — Mon, 27 Jun 2011 19:24:44 GMT

It would be nice to see the log to know more about your program.

You only have one double quote.

Try other="%nrstr(&custname)";

other=%nrstr("&custname");

to force it to resolve.

Resolving a macro variable inside of proc format

Reeza — Mon, 27 Jun 2011 19:31:24 GMT

We'd need to see what the &mkt macro variable does resolve to to help out.

If you're trying to create a format and have the data somewhere else consider using CNTLIN option instead of a macro variable. CNTLIN option allows you to create a format from a dataset.

Re: Resolving a macro variable inside of proc format

Bill — Mon, 27 Jun 2011 20:17:25 GMT

Sorry, typing error on my part. I did have

other="%nrstr(&custname)";

The log show no errors.

393 %macro fmt;

395 value $mkt

396 other="%nrstr(&CustName)";

397 run;

398 %mend fmt;

399 %fmt;

NOTE: Format $MKT has been output.

Other placements of the quotes did not help either.

394 proc format;

Re: Resolving a macro variable inside of proc format

Bill — Mon, 27 Jun 2011 20:29:23 GMT

Thanks for the cntlin idea. I hadn't thought of using it in this context. I want with the following:

data Customer;

fmtname='$mkt';

start='other';

label="&custname";

run;

proc format cntlin=Customer;

run;