dm "log; clear; output; clear; odsresults; clear;";
Data Test;
infile datalines dlm = ',' ;
input group_cat :$12. racethx :$20. statistic :$3. value :8. ;
datalines;
final_sample, Hispanic, CV, 69.9
final_sample, Non-Hispanic Black, CV, 82
final_sample, Asian, CV, 56.5
final_sample, Other, CV, 66.3
final_sample, Hispanic, Max,61436
final_sample, Non-Hispanic Black, Max, 77065
final_sample, Asian, Max, 49129
final_sample, Other, Max, 101795
;
run;
data Test1;
set Test;
value_f = put(value, mixedvalue. -r);
run; * get the desired output
proc print data=Test1 noobs blankline=4;
var racethx statistic;
var value_f;
id group_cat;
run;
* do not get the desired output (as above) in Excel (Issue)
ods listing close;
ods excel file = "C:\Data\test.xlsx"
options (sheet_name = 'Sheet1');
proc print data=Test1 noobs blankline=4;
var racethx statistic;
var value_f / style(data)={tagattr="format:###,###"}
style(data)={just=r};
id group_cat;
run;
ods listing;
This part is not working: var value_f / style(data)={tagattr="format:###,###"}
style(data)={just=r};
Desired output in Excel
group_cat racethx statistic value_f
final_sample Hispanic CV 69.9 final_sample Non-Hispanic Black CV 82.0 final_sample Asian CV 56.5 final_sample Other CV 66.3
final_sample Hispanic Max 61,436 final_sample Non-Hispanic Black Max 77,065 final_sample Asian Max 49,129 final_sample Other Max 101,795
... View more