proc transpose blanks

Ayooo1 — Wed, 14 Dec 2022 18:06:56 GMT

This might be a simple question but I would to replace the blank with a zero, how can I do that? The picture is the data after transposed.

data Merged_CP (keep= DoseC_P EXDSTXT SEX);
set listing2_1;
by EXDSTXT;
retain COUNT PERCENT EXDSTXT SEX;
length DoseC_P $20;
DoseC_P= strip(put(COUNT,comma12.)||''|| put(-PERCENT/100,percent7.1));
run;
proc sort data=Merged_CP;
by SEX;
run;
proc transpose data=Merged_CP out=EXDM (drop=_NAME_);
by SEX;
id EXDSTXT;
var DoseC_P;
run;
proc print data=EXDM;
run;

Re: proc transpose blanks

PeterClemmensen — Wed, 14 Dec 2022 18:11:28 GMT

Obviously, there are way to do this.

However, if your end goal is to simply create a frequency table with percentages, then there are better ways to go.

topic Re: proc transpose blanks in SAS Programming

proc transpose blanks

Re: proc transpose blanks