topic Re: Create dataset from count data? in SAS Procedures

Create dataset from count data?

sasques — Sat, 13 Feb 2010 12:08:32 GMT

Hi

I would like to convert a table that contains count data into a dataset that contains individual observations but I'm not sure how

For example, I would like to convert a table that looks like this

X Y count
1 3 2
2 6 4
5 4 3

into a dataset that looks like this

X Y
1 3
1 3
2 6
2 6
2 6
2 6
5 4
5 4
5 4

Does anyone know of a SAS code that can carry out this conversion?

Thanks!

Re: Create dataset from count data?

sbb — Sat, 13 Feb 2010 14:48:17 GMT

DATA step with a KEEP and SET statement. And you would add a DO UNTIL (); / END; loop containing an OUTPUT statement. With the expression, you reference variable COUNT.

Scott Barry
SBBWorks, Inc.

Recommended Google advanced search argument, this topic/post:

data step programming do loop output site:sas.com

Re: Create dataset from count data?

deleted_user — Mon, 15 Feb 2010 06:30:41 GMT

Hello friend,

Try checking this code.
As Scott suggested the right method to do this.

data test;
input x y count;
cards;
1 3 2
2 6 4
5 4 3
;
run;

data new (drop= i count) ;
set test;
i=count;
do until (i=0);
output;
i=i-1;
end;
run;

Thanks,
Saurabh.

Re: Create dataset from count data?

sasques — Mon, 15 Feb 2010 07:27:50 GMT

Thanks everyone -- these suggestions are helpful.