topic Re: Sequential display using macro variables in log window in SAS Enterprise Guide

Sequential display using macro variables in log window

satish123 — Tue, 08 Nov 2016 13:04:52 GMT

Hi,

Its been so long,

here is the macro that i've used.

data _null_;
set sashelp.cars end=eof;
by make;
retain mk 0;
if first.make then do;
mk=mk+1;
call symput('Mfg'||strip(put(mk,3.)),make);
end;
if eof then do;
call symput('mfg_no',strip(put(mk,3.)));
end;
run;

%macro sat(count);
%do i=1 %to &count;
Manufacturer&i is &&mfg&i;
%end;
%mend sat;

%put number of mfgs are &mfg_no;
%put %sat(&mfg_no);

the code suppose to display for all 'i' in SAS log, but its not working some how.

if possible how to save these in a sas dataset.

Thanks in advance,

Satish.A.

Re: Sequential display using macro variables in log window

Kurt_Bremser — Tue, 08 Nov 2016 13:27:05 GMT

a) You can use the put statement directly in the data step to write your values to the log

b) from what I see, you're just missing a %put in the %do loop:

%put Manufacturer&i is &&mfg&i;

Re: Sequential display using macro variables in log window

RW9 — Tue, 08 Nov 2016 13:38:53 GMT

Sorry, I am really not seeing the point in this code, what is it your trying to do? Is it just the unique makes and count if so:

proc sort data=have out=want nodupkey;
  by make;
run;
data _null_;
  set want nobs=n;
  length string $2000;
  string=cats("N=",put(_n_,best.),", Make=",make,", Total Obs=",put(n,best.));
  put string;
run;

No need to make a macro hill out of a molehill.

Re: Sequential display using macro variables in log window

Tom — Tue, 08 Nov 2016 13:50:34 GMT

What are you trying to do? Looks like you just want to run PROC FREQ.

proc freq data=sashelp.cars;
  tables make;
run;

Re: Sequential display using macro variables in log window

Astounding — Tue, 08 Nov 2016 13:55:57 GMT

While you've received valid comments so far, here's another variation on the theme:

data _null_;
set sashelp.cars;
by make;
if first.make;
mk=mk+1;

put 'Manufacturer ' mk 'is ' make;
run;

You can turn this into a macro problem for the practice, but it's not really an application that requires any macro language.

Re: Sequential display using macro variables in log window

satish123 — Tue, 08 Nov 2016 14:02:42 GMT

yes, it was my practise on macros.

thanks for your sugesion and code that made this possible.

is there any way that my macro can do the same? and save in a dataset?

Re: Sequential display using macro variables in log window

Kurt_Bremser — Tue, 08 Nov 2016 14:09:56 GMT

@satish123 wrote:

is there any way that my macro can do the same? and save in a dataset?

By $DEITY, no!!

MACRO IS FOR GENERATING CODE, NOT DATA!!

Re: Sequential display using macro variables in log window

Astounding — Tue, 08 Nov 2016 14:16:17 GMT

Yes, that's true. Macro language does not create a data set. The best it can do is generate the SAS code that would be needed to create a data set.

You could probably get your macro to work by removing a semicolon. It would still be complex code, and I'm not sure if you could visualize why this would make a difference. But the offending semicolon is inside the %DO loop:

Manufacturer&i is &&mfg&i ;

Re: Sequential display using macro variables in log window

RW9 — Tue, 08 Nov 2016 14:18:37 GMT

Practice lesson 1 would be knowing where to use macro code. Macro itself does nothing, it is merely a tool to generate some text. That text is generally valid Base SAS code which is then compiled and executed. Therefore the main part to learn is Base SAS which is the bit that does the work.

Re: Sequential display using macro variables in log window

satish123 — Tue, 08 Nov 2016 14:28:33 GMT

thanks every one.

each reply told me a lot.