topic Re: If Criteria in Current Dataset and Prev Dataset then 1 in SAS Programming

If Criteria in Current Dataset and Prev Dataset then 1

KC_16 — Thu, 07 Nov 2019 09:41:09 GMT

Hi,

I need some logic to carry out the following requirements if possible please.

My current table (New_Orders) has the following variables

Name

REF

Last Name

Order

Region

Status

TelNo

Login_id

What I need is to create 2 new variables within this table called

'New_Order'

and

'Curr_User'

Requirements

New Variable 'New_Order' = if Login_ID is in table New_Orders and New_Orders_Prev_Month then 'Existing' else 'N/A'

New Variable 'Curr_User' = if Email is in table New_Orders and New_Orders_Prev_Month then '1' else 'N/A'

Thanks

Re: If Criteria in Current Dataset and Prev Dataset then 1

PeterClemmensen — Thu, 07 Nov 2019 09:43:26 GMT

Can you describe your problem with some sample data and what you want the result to look like from that data? Makes it much easier to provide a usable code answer.

Re: If Criteria in Current Dataset and Prev Dataset then 1

KC_16 — Thu, 07 Nov 2019 09:59:56 GMT

What I am trying to understand is how many existing customers do we have (these will be captured within previous months table) that have made a new order vs newly on boarded customers (that won't exist in the previous months table).

Re: If Criteria in Current Dataset and Prev Dataset then 1

PeterClemmensen — Thu, 07 Nov 2019 10:02:41 GMT

Ok. How big is your data?

Re: If Criteria in Current Dataset and Prev Dataset then 1

andreas_lds — Thu, 07 Nov 2019 10:04:41 GMT

Repeating what @PeterClemmensen already said: please post data showing what you have and what you expect as result. From the description it seems that you need a simple merge with some logic to mark those customers not already in the previous month table.

Re: If Criteria in Current Dataset and Prev Dataset then 1

PeterClemmensen — Thu, 07 Nov 2019 10:08:49 GMT

I can't see your data, so needless to say, this is untested

data New_Orders_1;

	if _N_=1 then do;
		declare hash h(dataset:'New_Orders_Prev_Month');
		h.definekey('Login_id');
		h.definedone();
	end;

	set New_Orders;
	
	if h.check()=0 then New_Order='Existing';
	else New_Order='N/A';
run;