topic Re: creating classdata in SAS Procedures

creating classdata

michtka — Tue, 28 May 2013 23:19:10 GMT

Hi guys, there is any alternative way to create a classdata dataset,

not using cards, or datalines? Thanks in advance. V

I need to create a classdata dataset like this one:

dataset classdata:

Re: creating classdata

Reeza — Tue, 28 May 2013 23:45:29 GMT

You need to provide more information on what you're trying to do.

You can use a do loop and output statement but I have no idea if that's what you're looking for.

data want;

do i=1 to 3;

output;

end;

run;

Re: creating classdata

michtka — Tue, 28 May 2013 23:59:54 GMT

The idea is that, I got this dataset:

cat population trt count

A population_d 1 1

A total 3 1

B population_d 1 1

B total 3 1

C population_d 1 1

C total 3 1

In terms of show the report, populationx_p (trt=2), count=0 is not appear, and rather to put it manually (hardcode), I want to introduce it using classdata:

classdata population

population_d

population_p

total

classdata trteatment

to get the final dataset:

A population1_d 1 1

A population2_p 2 0

A total 3 1

B population1_d 1 1

B population2_p 2 0

B total 3 1

C population1_d 1 1

C population2_p 2 0

C total 3 1

Re: creating classdata

michtka — Wed, 29 May 2013 00:01:11 GMT

sorry that one:

A population_d 1 1

A population_p 2 0

A total 3 1

B population_d 1 1

B population_p 2 0

B total 3 1

C population_d 1 1

C population_p 2 0

C total 3 1

Re: creating classdata

Reeza — Wed, 29 May 2013 02:40:04 GMT

You posted a similar question a few days ago, regarding color and models.

The solution is similar, create an empty dataset and join via proc sql.

A better solution is to ensure the data is generated will all the values, using sparse option in proc freq or another option.