topic Re: Troubleshooting macro codes in SAS Programming

Troubleshooting macro codes

sonic_poem — Thu, 30 May 2019 13:27:53 GMT

Hi,

I inherited a program containing macro codes and saw the log message below. Can you help troubleshoot what the issue is regarding the following codes?

	data _null_;
		set test8 end=eof;
		call symputx('Product'||left(_n_), product, 'G');
		call symputx('Environment'||left(_n_), environment, 'G');
		if eof then call symputx('numrows',_n_, 'G');
	run;

NOTE: Numeric values have been converted to character values at the places given by:
(Line) : (Column).
1463:35 1464:35

Re: Troubleshooting macro codes

PeterClemmensen — Thu, 30 May 2019 13:28:41 GMT

This happens because the Left Function requires a character string. If the argument is numeric, the function attempts to convert it to character before left aligning. The code below gives the same Note. Probably nothing no worry about.

data test;
   set sashelp.class;
   a=left(_n_);
run;

Re: Troubleshooting macro codes

tomrvincent — Thu, 30 May 2019 13:30:21 GMT

display product and system from test8...are they numeric?
comment out lines 3-5, run, then uncomment one at a time to figure out where the error is.

Re: Troubleshooting macro codes

Ksharp — Thu, 30 May 2019 13:31:26 GMT

call symputx(  cats('Product',_n_)   , product, 'G');

Re: Troubleshooting macro codes

sonic_poem — Thu, 30 May 2019 13:43:51 GMT

Thank you! It worked!!