topic Re: Data from one dataset based on number of observations in SAS Programming

Data from one dataset based on number of observations

india2016 — Sat, 20 Jan 2018 08:36:30 GMT

Hello all,

I have a dataset wherein I have 1 lakh records based on data I need 300 samples of each based on one variable for example :

I have dataset which has data for India,Singapore,Malaysia

So I need 100 for India 100 for Singapore and 100 for Malaysia in one dataset . I cannot use where condition because I have more than 300 conditions for which I need 100 data in one dataset.

Any suggestion would really appreciate.

Re: Data from one dataset based on number of observations

PeterClemmensen — Sat, 20 Jan 2018 09:13:13 GMT

Do you need 300 samples or 1 sample of 300 observations?

Re: Data from one dataset based on number of observations

PeterClemmensen — Sat, 20 Jan 2018 09:14:09 GMT

Show us some sample of your data, makes it much easier to help you.

Re: Data from one dataset based on number of observations

Norman21 — Sat, 20 Jan 2018 09:20:52 GMT

It sounds like you want simple random sampling by strata. The following SESUG paper describes this well (example 2 on page 7):

https://www.lexjansen.com/sesug/2015/190_Final_PDF.pdf