Macro for stratified sample

[Rimz]

Hi
I have only one column in my excel sheet. I need to create a macro for getting a stratified data for the column which has data.

Example - column A is where i paste the data i need to be stratified and then click on a tab where i can put the number of products i need as my stratified data for example - 1500. This data either comes as a "open or save file"option or it can come in sheet 2 in that same macro.

Can someone help me with this please????

[Rimz]

Hi
I have only one column in my excel sheet. I need to create a macro for getting a stratified data for the column which has data.

Example - column A is where i paste the data i need to be stratified and then click on a tab where i can put the number of products i need as my stratified data for example - 1500. This data either comes as a "open or save file"option or it can come in sheet 2 in that same macro.

Can someone help me with this please????

[PaigeMiller]

Duplicate question, the exact same question was asked https://communities.sas.com/t5/SAS-Programming/Macro-for-stratified-sample/td-p/738342

[PaigeMiller]

This doesn't appear to be a SAS question.

And please don't post the same question twice.