data x; set l; z=compress(userno,'1234567890') ; n=1*userno; use=catx("",z,n); use1=compress(use,"."); drop z n use; run; As a new bie I will be doing in this way ...please let me know any efficient ideas . Giridhar.
... View more
Hello All, Thank You very much for helping me through this type of output . I have been working on text pad and as I use this tabulate I would get all the unwanted stuff .Any ways it was very much helpful. Thanks a Lot. Giridhar Goutham Y
... View more
Hi Plz check this and reply back. If this is not what you want I can learn from this. DATA a; INPUT VAR1 $ VAR2 $ VAR3 $; DATALINES; Yes No Maybe No Yes Maybe No No Yes ; RUN; proc tabulate data=a out=b; class var1 var2 var3; table var1 var2 var3; run; data c; set b; if var1='' and var2 ne '' then var1=var2; if var1='' and var3 ne '' then var1=var3; drop var2 var3; run; proc sort data=c;by _type_;run; options missing=0; proc transpose data=c out=d(drop=_name_ _type_); id var1; by _TYPE_; var n; run;
... View more