topic Re: Iterate Over a List to Create a Report for Each Item in SAS Programming

Iterate Over a List to Create a Report for Each Item

Perscat1 — Sun, 18 Sep 2022 23:41:38 GMT

I have a query which creates a report for a specified order number as follows

proc sql;

Select orderid, productid,orderdate,linetotal

From Salesorders

where orderid = 'A1234'

quit;

Now I have a list of order IDs in a dataset from here:

Select orderid from JulySales

I would like to create a report like the first query but for every orderid in the second query.

Any help is greatly appreciated.

SASKiwi — Mon, 19 Sep 2022 00:42:52 GMT

How about just one report grouped by ORDERID like this?

proc sort data = JulySales;
  by orderid;
run;

proc print data = JulySales;
  by orderid;
  id oderid;
run;

FM_MF — Wed, 21 Sep 2022 08:17:50 GMT

You can correct it as follows:

proc sql;
　select orderid, productid,orderdate,linetotal
　from Salesorders
　where orderid in (select orderid from JulySales);
quit;

But you should first ensure that the attributes(length, format etc) of orderID in dataset-JulySales and dataset-Salessorders are same.

Hope this helps.

Thanks,

Fred