Hi. I want to convert a macro variable value, which is all numerals (which is character text, of course) to a numeric format. I followed Chris Yindra's insightful paper "%SYSFUNC - The Brave New Macro World" but am not successful. Chris has the following example, which I can replicate to work: %LET MYDATE = 971006; %put NOTE: original value: &MYDATE.; %macro chngfmt(invar,infmt); %let &invar = %sysfunc(inputn(&&&invar,&infmt)); %mend chngfmt; %chngfmt(MYDATE,YYMMDD6.); %put NOTE: sas data value: &MYDATE.; But, I want to convert to a simple comma format. Typically, I want to display the row count in output with commas. My code looks like the following, but does not change the format (I used a %let statement in my example for simplicity): %let row_count=10000; %put NOTE: original value: &row_count.; %macro chngfmt(invar,infmt); %let &invar = %sysfunc(inputn(&&&invar,&infmt)); %mend chngfmt; %chngfmt(row_count,comma15.); %put NOTE: sas data value: &row_count.; Any suggestions?
... View more