topic Re: 50/50 Split Help in New SAS User

50/50 Split Help

MagD — Mon, 16 Sep 2019 10:18:37 GMT

Hi All,

I hope this message finds you all well.

Please kindly assist me. I am stuck. I have 841 accounts and would like to do a 50/50 of these accounts between 2 debt collectors. Please see my current code below:

data _null_;
prev_month = intnx('month',today(),-1);
last_month = intnx('month',today(),0);
call symputx("prev_month_m2y2",put(month(prev_month),z2.)||put(prev_month,year2.),4.);
call symputx("last_month_m2y2",put(month(last_month),z2.)||put(last_month,year2.),4.);
call symputx("this_month_m2y2",put(month(today()),z2.)||put(today(),year2.),4.);
run;

proc sql;
create table INSPIRE.INSPIRE_MATTERS_&last_month_m2y2._updated as
select a.*, b.current_edc_no2, b.current_edc_no2_date, c.account_guid, c.cd
from INSPIRE.INSPIRE_MATTERS_&last_month_m2y2 as a
left join (
select distinct case when substr(account_guid,1,4) = "7300" then substr(account_guid,5,6)||substr(account_guid,1,4) else account_guid end as account_guid,
"ARA Wayne Druian" as current_edc_no2, today() as current_edc_no2_date format date9.
from ara_accounts
) as b
on a.'matter number'n = b.account_guid
left join (
select account_guid, cd
from INSPIRE.STATEMENTS_STATS_&last_month_m2y2
) as c
on a.'matter number'n = c.account_guid;
quit;

data ara_matter_import_&last_month_m2y2;
set INSPIRE.INSPIRE_MATTERS_&last_month_m2y2._updated;
if current_edc_no2 = "ARA Wayne Druian";
drop last_month_edc edc_action current_edc current_edc_no2 current_edc_no2_date;
run;

proc export data= ara_matter_import_&last_month_m2y2
outfile="\\lewexcal\ARA Inspire\Inbox\ara_matter_import_blake_&last_month_m2y2..csv"
dbms=dlm replace; delimiter=";";
run;

Re: 50/50 Split Help

PeterClemmensen — Mon, 16 Sep 2019 10:37:12 GMT

Do you want to split up the data into two data sets or simply a 1/2 variable to indicate the debt collector?

Re: 50/50 Split Help

MagD — Mon, 16 Sep 2019 10:39:13 GMT

I'd like to split into 2 data sets, please.

Re: 50/50 Split Help

PeterClemmensen — Mon, 16 Sep 2019 10:43:27 GMT

Ok. Just to be clear.. I assume that you want to split the data set ara_matter_import_&last_month_m2y2 into two equally sized data sets correct?

Re: 50/50 Split Help

MagD — Mon, 16 Sep 2019 11:26:30 GMT

Yes, that is correct.

Re: 50/50 Split Help

PeterClemmensen — Mon, 16 Sep 2019 11:31:11 GMT

Ok. There are many ways to do this. Here is a small example that splits the sashelp.class data set into two data sets one and two

data one two;
    set sashelp.class;
    if mod(_N_, 2) = 0 then output one;
                       else output two;
run;

Re: 50/50 Split Help

Ksharp — Mon, 16 Sep 2019 12:32:35 GMT

proc surveyselect data=sashelp.class out=temp groups=2;
run;

data one two;
 set temp;
 if groupid=1 then output one;
  else output two;
  run;

Re: 50/50 Split Help

MagD — Mon, 16 Sep 2019 12:34:19 GMT

Thank you! It works perfectly!

Re: 50/50 Split Help

PeterClemmensen — Mon, 16 Sep 2019 12:36:00 GMT

Glad you found your answer