topic Re: proc transpose in SAS Programming

proc transpose

ZaneleD — Fri, 10 Jan 2020 10:27:04 GMT

I am using proc transpose, how can I make it to put zeros where there is no observation for the variable.

Re: proc transpose

andreas_lds — Fri, 10 Jan 2020 10:56:06 GMT

Please post the code you are using and the data as data-step with datalines, so that we see what you have, then explain what you want/need.

Re: proc transpose

maguiremq — Fri, 10 Jan 2020 13:19:12 GMT

Is this what you're looking for?

data have;
input id value;
datalines;
1 2
1 .
1 3
3 4
5 6
7 8
2 .
3 .
5 0
9 .
;

proc sort data=have;
by id;
run;

proc transpose data=have out=have_2 (drop=_NAME_) prefix=value;
by id;
var value;
run;

data want (drop=i);
set have_2;
array val [*] value:;
do i = 1 to dim(val);
	if val[i] = . then val[i] = 0;
end;
run;

It's a bit unclear what you mean by "no observation" for the variable.

Re: proc transpose

Ksharp — Sat, 11 Jan 2020 11:57:06 GMT

data have;
input id value;
datalines;
1 2
1 .
1 3
3 4
5 6
7 8
2 .
3 .
5 0
9 .
;

proc sort data=have;
by id;
run;

proc transpose data=have out=have_2 (drop=_NAME_) prefix=value;
by id;
var value;
run;
proc stdize data=have_2 out=want reponly missing=0;
var _numeric_;
run;

Re: proc transpose

ZaneleD — Sun, 12 Jan 2020 12:37:04 GMT

Thank you so much. You've helped me.