Format numeric variable when transformed to character

Accepted Solution Solved
Reply
Contributor
Posts: 32
Accepted Solution

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
Respected Advisor
Posts: 4,936

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

View solution in original post


All Replies
Trusted Advisor
Posts: 3,215

Re: Format numeric variable when transformed to character

use the put function

---->-- ja karman --<-----
Solution
‎10-27-2013 09:03 PM
Respected Advisor
Posts: 4,936

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.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 195 views
  • 3 likes
  • 3 in conversation