Iterate Over a List to Create a Report for Each Item

[Perscat1]

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]

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]

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