topic Re: how to output partition? in SAS Programming

how to output partition?

viva0521 — Wed, 02 Nov 2016 19:46:33 GMT

Hello,

I have following code running in SAS,

proc adaptivereg data=imported_excel
SEED = 123
PLOTS = ALL
details=bases;
partition fraction(validate=0.25 test=0.25);
model Y = A B C;
RUN;

is there anyway I can output the partition dataset, test,validate, respectively? Thanks.

Re: how to output partition?

Reeza — Wed, 02 Nov 2016 21:00:33 GMT

Ok...I tried to run it to check, but it keeps crashing in SAS Studio.

If you generate an OUTPUT data set, does it contain a _ROLE_ variable that denotes what each observation was categorized?

You can generate the OUTPUT data set using something like


   output out=dataset_role;

If you have partitioned the input data by using a PARTITION statement, then a character variable _ROLE_ is included in the output data set. For each observation the value of _ROLE_ is as follows:

_ROLE_ Observation

TEST Testing

TRAIN Training

VALIDATE Validation

Re: how to output partition?

viva0521 — Fri, 04 Nov 2016 21:39:04 GMT

Reeza,

Thanks for your reply.

I did your suggestion, but no data set was generated. Where should I insert "output out=dataset_role" to my model? Thanks.

Re: how to output partition?

Reeza — Fri, 04 Nov 2016 21:53:53 GMT

proc adaptivereg data=imported_excel 
SEED = 123 
PLOTS = ALL
details=bases;
partition fraction(validate=0.25 test=0.25);
model Y = A B C;
output out=dataset_role;
RUN;

If this doesn't work post your log. I ran it using the example in the documentation and it worked fine.

https://support.sas.com/documentation/cdl/en/statug/68162/HTML/default/viewer.htm#statug_adaptivereg_examples03.htm

Re: how to output partition?

viva0521 — Tue, 08 Nov 2016 19:57:54 GMT

Reeza,

Thanks for your reply. It does work, but I still got one question. So I am using 25% of the whole dataset as "test", the number of observations in my whole data set is 816, literally I should get 204 "test" observations. However, I found there were 211 observations pulled out as "test" with the code above, is there anything wrong with this? Not a big deal, just curious, thanks!

Re: how to output partition?

Reeza — Wed, 09 Nov 2016 02:33:47 GMT

No idea, I would consider passing that on to Tech Support.