topic Re: How to modify MACRO to display MEDIAN? in SAS Programming

How to modify MACRO to display MEDIAN?

arrytanny — Mon, 18 Dec 2017 21:35:48 GMT

I am having some difficulty fixing this macro code>

libname mylib 'C:\Users\Daddy\Documents';
%include 'C:\Users\Daddy\Desktop\face.sas';
%face (group,sbpbl sbp12 cholbl chol12 hdlbl hdl12 glucosbl glucos12,data=tomhs);
run;


%macro face (group,sbpbl, sbp12, cholbl, chol12, hdlbl, hdl12, glucosbl, glucos12,data=tomhs,dec=3,all=all);
%do I = 1%to902;
%let depvar = %scan(&sbpbl sbp12 cholbl chol12 hdlbl hdl12 glucosbl glucos12,&i);
%let%length (&depvar) = 0 %goto done;
 proc tabulate data=&tomhs noseps;
  class &group; sbpbl&depvar;
  table (&group &all), (&depvar)*(n*f=7.0 mean*f=7.&dec std*f=7.&dec
                                min*f=7.&dec max*f=7.&dec med*f=7.&dec)/rts=30;
 run;
%end;
 %done:
%mend face;
libname mylib'C:\Users\Daddy\Documents';

%include 'C:\Users\Daddy\Desktop\face.sas'
%face (group,sbpbl sbp12 cholbl chol12 hdlbl hdl12 glucosbl glucos12, data=tomhs);
run;

Please how do I modify this macro code to display MEDIAN? Thanks

Re: How to modify MACRO to display MEDIAN?

Astounding — Mon, 18 Dec 2017 22:01:02 GMT

Are you claiming that this code works as intended, except that it fails to print the median? That would be a surprise.

Perhaps you could post the original macro, before you started playing with it. There are many issues to fix here.

Re: How to modify MACRO to display MEDIAN?

arrytanny — Mon, 18 Dec 2017 22:09:40 GMT

The first part runs,

afterwards the remaining part never works. It gives several error that I can not fathom.

Re: How to modify MACRO to display MEDIAN?

arrytanny — Mon, 18 Dec 2017 22:10:50 GMT

Si it fails to give an output that included MEDIAN

Re: How to modify MACRO to display MEDIAN?

Astounding — Mon, 18 Dec 2017 22:15:29 GMT

If the first part runs, then post the contents of C:\Users\Daddy\Desktop\face.sas

It may not print the median, but as long as it is working it can be tweaked to add the median to the report.

Re: How to modify MACRO to display MEDIAN?

ballardw — Mon, 18 Dec 2017 22:18:58 GMT

Hint: Set options mprint symbolgen mlogic;

Run your code;

Paste the generated statements and error messages from the log into a code box.

Re: How to modify MACRO to display MEDIAN?

Reeza — Tue, 19 Dec 2017 01:52:45 GMT

Mistakes from a quick scan

SCAN Is being used incorrectly
Macro is called before it’s declared
Multiple %include for same program
Incorrect use of DATA parameter -> this is a big one. Everything will be wrong if this isn’t done correctly because you’re not pointing at the data you think you are.
I don’t think GOTO does what you think it’s doing

Oddly, the median part is actually correct....

@arrytanny wrote:

I am having some difficulty fixing this macro code>

libname mylib 'C:\Users\Daddy\Documents';
%include 'C:\Users\Daddy\Desktop\face.sas';
%face (group,sbpbl sbp12 cholbl chol12 hdlbl hdl12 glucosbl glucos12,data=tomhs);
run;


%macro face (group,sbpbl, sbp12, cholbl, chol12, hdlbl, hdl12, glucosbl, glucos12,data=tomhs,dec=3,all=all);
%do I = 1%to902;
%let depvar = %scan(&sbpbl sbp12 cholbl chol12 hdlbl hdl12 glucosbl glucos12,&i);
%let%length (&depvar) = 0 %goto done;
 proc tabulate data=&tomhs noseps;
  class &group; sbpbl&depvar;
  table (&group &all), (&depvar)*(n*f=7.0 mean*f=7.&dec std*f=7.&dec
                                min*f=7.&dec max*f=7.&dec med*f=7.&dec)/rts=30;
 run;
%end;
 %done:
%mend face;
libname mylib'C:\Users\Daddy\Documents';

%include 'C:\Users\Daddy\Desktop\face.sas'
%face (group,sbpbl sbp12 cholbl chol12 hdlbl hdl12 glucosbl glucos12, data=tomhs);
run;

Please how do I modify this macro code to display MEDIAN? Thanks

Re: How to modify MACRO to display MEDIAN?

Cynthia_sas — Tue, 19 Dec 2017 02:14:57 GMT

Hi:
In ;your TABLE statement, you have specified many statistics correctly -- for example, N, MEAN, STD, MIN, and MAX. However, you have this
med*f=7.&dec

in your TABLE statement and the correct specification for the MEDIAN statistic is either MEDIAN or P50, as shown in the documentation.
http://go.documentation.sas.com/?docsetId=proc&docsetVersion=9.4&docsetTarget=p0n4welprckk8yn1ro9swaef6x0n.htm&locale=en

Look what happens when I try the "MED" statistic as a keyword in TABULATE:

Cynthia