topic looping sas procedure in SAS Procedures

looping sas procedure

mich — Fri, 24 Jan 2014 09:56:50 GMT

Hi,

i have a data table where each row is a customer information, i want to run a procedure (for example Proc gplot) for each customer so for each row.

how can i do that without writing the Proc gplot as many times as the number of customers (actually i have thousands of rows)?

Thank you

Michel

Re: looping sas procedure

mr_qwertzuiop_asdfghjkl — Fri, 24 Jan 2014 12:33:24 GMT

Try this:

data work.loop;

infile datalines;

input col1 $;

datalines;

;

run;

data work.data;

infile datalines;

input col1 $ col2;

datalines;

x 1

y 2

z 3

;

run;

%macro loop(txt);

proc print data=work.data (where=(col1="&txt.")); run;

%mend;

%macro readds;

%let dsid = %sysfunc(open(work.loop,in));

%let nobs = %sysfunc(attrn(&dsid,nlobs));

%put nobs=&nobs;

%do i = 1 %to &nobs;

%let rc = %sysfunc(fetch(&dsid,'NOSET'));

%let col1 = %sysfunc(getvarc(&dsid,%sysfunc(varnum(&dsid,col1))));

%put col1=&col1;

%loop(&col1)

%end;

%let rc = %sysfunc(close(&dsid));

%mend;

%readds

Re: looping sas procedure

Astounding — Fri, 24 Jan 2014 16:07:34 GMT

If the report format comes out OK, you could try:

proc sgplot data=have;

by custid notsorted;

...

Good luck.

Re: looping sas procedure

GraphGuy — Tue, 20 Jan 2015 19:48:05 GMT

When I do this, I put my graph code in a macro (such as %do_graph), and then loop through the items in a data step, and 'call execute' the macro each time through...

/* Loop through, and make a plot for each manufacturer */

proc sql noprint;

create table loopdata as

select unique statecode

from my_data;

quit; run;

data _null_;

set loopdata;

call execute('%do_graph('|| statecode ||');');

run;

Re: looping sas procedure

ballardw — Tue, 20 Jan 2015 21:26:49 GMT

I find most graphs made with a single point to be less than optimum for most uses...

You may end up restructuring data to get a good result from SAS graphical procs compared with the choices you may make with Excel or similar programs.