I have a dataset that SAS is adding . form missing data, I run a procedure If X = . then X = 0; However, when I do a proc transpose I loose the 0 and they are back to . How can a get my final data to out put zeros instead of . for missing data. data Cold; set raw temp; Response = 3; if Resp = . then Resp = 0; run; proc transpose data=Cold out=ColdStor prefix = Item_; by Stortype x_sum ID Year Month; var Resp; id ItemCode; run;
... View more
