topic Re: Proc Transpose character numeric issue in SAS Programming

Proc Transpose character numeric issue

Satish_Parida — Wed, 19 Jun 2019 07:10:21 GMT

data have;
input byvar a b c;
cards;
1 100 200 300
2 400 500 600
;
run;

proc sort data=have;
by byvar;
run; 
                                                                                   
proc transpose data=have 
				out=want(keep=byvar _name_ Value1 rename=(_name_=var_name Value1=Value))
				prefix=Value;
  by byvar;                                                                          
  var a b c;                                                      
run;

Can we have the datatype of column "Value" in "want" table set to character datatype during transpose?

If we have a mixed datatype in the input "have" table it is working fine.

Re: Proc Transpose character numeric issue

PeterClemmensen — Wed, 19 Jun 2019 07:52:51 GMT

I don't think so. Perhaps simply do it in a data step?

data have;
input byvar a b c;
cards;
1 100 200 300
2 400 500 600
;
run;

data want(keep=byvar name Value);
   set have;
   array _{3} a b c;
   do i=1 to dim(_);
      name=vname(_[i]);
      Value=put(_[i], 8. -l);
      output;
   end;
run;

Re: Proc Transpose character numeric issue

PeterClemmensen — Thu, 20 Jun 2019 07:39:44 GMT

@Satish_Parida did you try my code and did it work for you? 🙂