topic Re: CLASSDATA in VISIT variable in SAS Procedures

CLASSDATA in VISIT variable

michtka — Wed, 06 Mar 2013 16:25:17 GMT

Hi everyone, I have these two datasets:

data have1;

input week $ ord count;

datalines;

week1 1 2

week2 1 3

week3 1 4

week4 1 3

week5 1 5

;

run;

data have2;

input week $ ord count;

datalines;

week1 2 1

week3 2 3

week4 2 4

;

run;

I want to obtain the final dataset (you can see, I want to keep the same structure in ord=2 that I have for ord=1):

week1 2 1

week2 3 1

week3 4 1

week4 3 1

week5 5 1

week1 1 2

week2 0 2

week3 3 2

week4 4 2

week5

I think CLASSDATA would do this job, but I do not remember How to apply to this particular problem.

Thank you.

Re: CLASSDATA in VISIT variable

michtka — Wed, 06 Mar 2013 16:26:26 GMT

sorry week5 0 2 is the last record

Re: CLASSDATA in VISIT variable

michtka — Wed, 06 Mar 2013 16:59:16 GMT

I just remembered it from data_null in other conversation

*creating classdata;

data classdata;

set have1 (keep=week);

run;

*creating my final dataset;

data have3;

set have1 have2;

by ord;

run;

*data_null code structure from other problem;

proc summary nway data=have3 classdata=classdata order=data;

by ord;

class week;

output out=want(drop=_freq_ _type_) idgroup(out(count)=);

run;