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
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: