BookmarkSubscribeRSS Feed
Perscat1
Calcite | Level 5

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.

 

2 REPLIES 2
SASKiwi
PROC Star

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
Calcite | Level 5

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

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 777 views
  • 5 likes
  • 3 in conversation