topic Re: use macro to select one order id in SAS Programming

use macro to select one order id

mrahouma — Sat, 16 Nov 2019 12:54:25 GMT

I have the following dataset

data orders;
input customerid OrderDate DATE7. Model $13-24 Quantity;
cards;
287 15OCT03 Dealr Breeze 15
287 15OCT03 Sarah Ana 15
274 16OCT03 Gee Stream 1
174 17OCT03 Sarah Ana 20
174 17OCT03 Nor'easter 5
174 17OCT03 Scirocco 1
347 18OCT03 Mistral 1
287 21OCT03 Dealr Breeze 30
287 21OCT03 Gee Ana 25
;

run;

I want to write a macro called pick_order that will print a subset of the data set orders
for a selected customer---> So I wrote the following code;

%macro pick_order (id=);
proc print data=Orders noobs;
where customerid = "&id."; 
title "&id. Orders";
run;
%mend pick_order;

*THEN I want to run my macro I have written to print the table for customer 287;

%pick_order (id=287);

I got the following error:

ERROR: WHERE clause operator requires compatible variables.

Any advie will be greatly appreciated.

Re: use macro to select one order id

yabwon — Sat, 16 Nov 2019 13:24:55 GMT

Hi,

your customerId is numeric, and in the WHERE you are using "&id." which is character

Make it:

where customerid = &id.;

All the best

Bart

Re: use macro to select one order id

mrahouma — Sat, 16 Nov 2019 13:37:26 GMT

Thanks a lot. Greatly appreciated

Re: use macro to select one order id

Kurt_Bremser — Sat, 16 Nov 2019 13:56:41 GMT

OTOH, it would be better to store the customer ID as character. You'll never do calculations with it.