topic Re: Bootstrap sampling from a long formatted file in SAS Programming

Bootstrap sampling from a long formatted file

BlueNose — Tue, 26 Jan 2016 13:14:04 GMT

Hello all,

I have a long formatted file, in which every subject has more than one row. For each row, I have several variables, two of them are "ID" and "Visit". Each subject has 5 visits. I have 50 subjects.

I want to make a random sampling with replacement, in order to get a larger file, with 100 subjects.

The problem is, when I use PROC SURVEYSELECT (which is straightforward), SAS chooses rows, not subjects. I want SAS to sample a subject, and to keep all his rows, rather than randomly selecting rows.

Can it be done ? I am pretty much lost here.

Thank you.

Re: Bootstrap sampling from a long formatted file

Kurt_Bremser — Tue, 26 Jan 2016 13:20:24 GMT

Have you already tried to use proc transpose to reformat the file into rows?

Re: Bootstrap sampling from a long formatted file

BlueNose — Tue, 26 Jan 2016 13:22:11 GMT

No. I have too many variables per visit (10 variables * 5 visits will give 50 variables wide).

Re: Bootstrap sampling from a long formatted file

BlueNose — Tue, 26 Jan 2016 13:25:12 GMT

I have an idea. Can I save the number of times each subject is selected, and then build different datsets for subjects with number of hits of up to 1, up to 2, etc... and then append these datasets ?

Re: Bootstrap sampling from a long formatted file

data_null__ — Tue, 26 Jan 2016 13:31:35 GMT

SAMPLINGUNIT | CLUSTER variables < / options > ;