topic Re: how to create boxplot referencing multiple variables of a %let statement in New SAS User

how to create boxplot referencing multiple variables of a %let statement

ari2495 — Fri, 04 Nov 2022 13:49:49 GMT

Hi! I run my code correctly, the i created a macro with let statement, and the other commands work. The only one which does not work is boxplot. please, help is welcome.

here is the code

proc import
datafile="file"
dbms= xlsx
out=pdrating;
run;

/*macro*/
%let vars= mean_PD loss_days;

/*proc freq variabili */

proc freq data=pdrating;
tables &vars./missing;
run;

/*Boxplot verticale e orizzontale*/

proc sgplot data= pdrating;
vbox &vars.;
run;

here's log:

what is the error of the second variable about?

Re: how to create boxplot referencing multiple variables of a %let statement

Tom — Fri, 04 Nov 2022 13:55:01 GMT

Unlike the TABLES statement in PROC FREQ, the VBOX statement in PROC SGPLOT only accepts ONE variable.

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/grstatproc/n1waawwbez01ppn15dn9ehmxzihf.htm

You could try issue multiple VBOX statements?

Get the actual SAS code working without macro logic first. Then figure out how to get the macro to generate that code.

So what PROC SGPLOT code do you want to run when you have multiple analysis variables?

Re: how to create boxplot referencing multiple variables of a %let statement

ari2495 — Fri, 04 Nov 2022 13:58:17 GMT

Thank you for the help. Actually, I have already run this code for singular variables and it works

Re: how to create boxplot referencing multiple variables of a %let statement

Tom — Fri, 04 Nov 2022 14:50:26 GMT

@ari2495 wrote:

Thank you for the help. Actually, I have already run this code for singular variables and it works

Like I said, try creating the PROC SGPLOT code manually first. Once you have code that works then you can see how to get the macro to generate it.

So if you have a macro variable named VARS you and want to do something with each name in the list you would use code like this:

%do index=1 %to %sysfunc(countw(&vars,%str( )));
   %let varname=%scan(&vars,&index,%str( ));
.... code that uses &VARNAME ....
%end;

Re: how to create boxplot referencing multiple variables of a %let statement

Tom — Fri, 04 Nov 2022 18:24:11 GMT

@ari2495 wrote:

Thank you for the help. Actually, I have already run this code for singular variables and it works

And did you try it for multiple variables or not?
Does something like this do what you want?

proc sgplot data=sashelp.class;
  vbox age;
  vbox height;
run;
quit;

Or do you want something like this instead?

proc sgplot data=sashelp.class;
  vbox age;
run;
  vbox height;
run;
quit;

Re: how to create boxplot referencing multiple variables of a %let statement

ari2495 — Mon, 07 Nov 2022 09:18:43 GMT

proc sgplot data=sashelp.class;
  vbox age;
  vbox height;
run;
quit;

this one does not work for me because I need a code that generates a single boxplot for every single variable.

proc sgplot data=sashelp.class;
  vbox age;
run;
  vbox height;
run;
quit;

with regard to this one, I run this too but it only gave me boxplot for age variable.

Re: how to create boxplot referencing multiple variables of a %let statement

Tom — Mon, 07 Nov 2022 13:47:06 GMT

So did you try a separate PROC step for each one?

proc sgplot data=sashelp.class;
  vbox age;
run;
proc sgplot data=sashelp.class;
  vbox height;
run;

Re: how to create boxplot referencing multiple variables of a %let statement

ari2495 — Mon, 07 Nov 2022 14:02:51 GMT

yes and it worked but I need an automatized code

Re: how to create boxplot referencing multiple variables of a %let statement

PaigeMiller — Mon, 07 Nov 2022 14:12:06 GMT

@ari2495 wrote:
yes and it worked but I need an automatized code

This was already posted by @Tom earlier in this thread at https://communities.sas.com/t5/New-SAS-User/how-to-create-boxplot-referencing-multiple-variables-of-a-let/m-p/842519#M36528