topic Re: How do I select a customer with a pattern in Score using Macro? in SAS Programming

How do I select a customer with a pattern in Score using Macro?

arunvaibhav21 — Sun, 15 Jul 2018 09:30:08 GMT

Hello All,

I need find out which CUSTOMER has given a "5" score immediately followed by a missing score (among the data shown above, it is C).

*Q10;
data feedback;
infile datalines missover;
input Customer $
	  Score 
	  Comment $30. ;
datalines;
A	3	The is no parking
A	5	The food is expensive
B	.	I like the food
C	5	It tastes good
C	.	 
C	3	I like the drink
D	4	The dessert is tasty
D	2	I don't like the services
;
run;
proc print data = feedback;
run;

proc sql;
select count(distinct Customer) into :n from feedback;
select distinct Customer into :cust1 - from feedback;
run;

%macro main();
%do i=1 %to &n.;
 data feedback_&&cust&i; set feedback;
 where Customer = "&&cust&i";
run;
%feedback_mn(cust=&&cust&i);
%end;
%mend;

%macro feedback_mn(cust=);
	data have;
	set feedback;
	where Customer = "&&cust&i";
 %if %length(Score)= 0 and lag1(Score) = 5 %then output;
 run;

 proc print data  = have;
 run;
%mend;
	
%main();

Any help is highly appreciated. please check the code, I am getting this error,

A character operand was found in the %EVAL function or %IF condition where a numeric operand
is required. The condition was: %length(Score)= 0 and lag1(Score) = 5
ERROR: The macro FEEDBACK_MN will stop executing.

Re: How do I select a customer with a pattern in Score using Macro?

Ksharp — Sun, 15 Jul 2018 11:11:07 GMT

data feedback;
infile datalines missover;
input Customer $
	  Score 
	  Comment $30. ;
datalines;
A	3	The is no parking
A	5	The food is expensive
B	.	I like the food
C	5	It tastes good
C	.	 
C	3	I like the drink
D	4	The dessert is tasty
D	2	I don't like the services
;
run;
data _null_;
 set feedback;
 if customer=lag(customer) and score=. and lag(score)=5 then put (_all_) (:);
run;

Re: How do I select a customer with a pattern in Score using Macro?

arunvaibhav21 — Sun, 15 Jul 2018 18:07:10 GMT

Hello,

Thanks for the answer. But I dont see the output?

Thanks,

Arun

Re: How do I select a customer with a pattern in Score using Macro?

Ksharp — Mon, 16 Jul 2018 12:08:32 GMT

If you want a table .

data want;
 set feedback;
 if customer=lag(customer) and score=. and lag(score)=5 ;
run;