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.
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;
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
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.