topic Re: Format numeric variable when transformed to character in SAS Programming

Format numeric variable when transformed to character

EzPaste — Sun, 27 Oct 2013 16:29:20 GMT

Hello,

From a proc tabulate , I get the average score of a variable for levels of of a class variable then I create a character variable that include all these values as a string

retain seriesYou seriesOthers ;

seriesYou = catx(',',seriesYou,&YouAsDirMgr) ;

The problem is that the values in the sting appear unformatted (3.31131313,4.4546464656....) while I want them to appear as (3.31,4.45...)

Any help

Abe

Re: Format numeric variable when transformed to character

jakarman — Sun, 27 Oct 2013 20:50:48 GMT

use the put function

Re: Format numeric variable when transformed to character

PGStats — Mon, 28 Oct 2013 01:03:03 GMT

If I understand what &YouAsDirMgr might contain (a list of variable names or numbers), you could use it in the list form of a DO loop :

%let YouAsDirMgr=a,b,123.12345;

data _null_;
length str $200;
a = 345.876543;
b = 987;
seriesYou = 9.9889;
do v = seriesYou, &YouAsDirMgr.;
str = catx(",", str, round(v, 0.01));
end;
put str=;
run;