Re: Data from one dataset based on number of observations - SAS Support Communities

Pyrite | Level 9

Pyrite | Level 9

Data from one dataset based on number of observations

Posted 01-20-2018 03:36 AM (1245 views)

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.

3 REPLIES 3

Tourmaline | Level 20

Tourmaline | Level 20

Re: Data from one dataset based on number of observations

Posted 01-20-2018 04:13 AM (1231 views) | In reply to india2016

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

The DATA to DATA Step Macro
Blog: SASnrd

Tourmaline | Level 20

Tourmaline | Level 20

Re: Data from one dataset based on number of observations

Posted 01-20-2018 04:14 AM (1228 views) | In reply to india2016

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

The DATA to DATA Step Macro
Blog: SASnrd

Lapis Lazuli | Level 10

Lapis Lazuli | Level 10

Re: Data from one dataset based on number of observations

Posted 01-20-2018 04:20 AM (1224 views) | In reply to india2016

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

Norman.
SAS 9.4 (TS1M6) X64_10PRO WIN 10.0.17763 Workstation

April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Call for Content EXTENDED

Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.

Submit your proposal!