02-09-2016 09:41 AM - edited 02-11-2016 05:16 AM
PROC REPORT DATA=meanout2;
TITLE "DEMOGRA table Summary of demographic characteristics ";
COLUMN (num)_stat_ Bp_status,(report_stat percent) total percent;
define _stat_/group 'Parameters or Categories';
DEFINE num/group noprint;
DEFINE BP_status/ACROSS ORDER=freq DESCENDING WIDTH=10;
DEFINE report_stat/'Blood Pressure';
02-09-2016 10:08 AM
What do you want a percent and total of? It isn't clear from your code what you are attempting.
For instance, what is the purpose of this bit of code? I don't see a real need for a new dataset if all you are doing is renaming a variable.
DATA meanout2(DROP=_type_ _freq_); LENGTH percent 8 ; SET meanout1; Percent='' ; RENAME ageatstart=report_stat; RUN;