Solved
Contributor
Posts: 32

Format numeric variable when transformed to character

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

Accepted Solutions
Solution
‎10-27-2013 09:03 PM
Posts: 5,541

Re: Format numeric variable when transformed to character

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

PG

All Replies
Posts: 3,215

Re: Format numeric variable when transformed to character

use the put function

---->-- ja karman --<-----
Solution
‎10-27-2013 09:03 PM
Posts: 5,541

Re: Format numeric variable when transformed to character

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

PG
🔒 This topic is solved and locked.