Format numeric variable when transformed to character

[EzPaste]

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

[jakarman]

use the put function

[PGStats · Accepted solution]

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;

PG