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
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
use the put function
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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.