BookmarkSubscribeRSS Feed
L_L
Calcite | Level 5 L_L
Calcite | Level 5
Dear all

hereafter you'll find my code:

proc format;
value $ans 'Important'='Important'
'fairly important'='fairly important'
'Not important'='Not important'
'NA'='Not available'
;
run;
PROC TABULATE DATA=file;
CLASS score / missing ORDER=formatted;
keyword N colpctn;
TABLE
score=' '
all='Total',
(all=' ')*(N colPctN='%') /style=[cellpadding=7 cellspacing=0]
misstext='0';
format score $ans.;
RUN;


I would like to have in the output table the variable "score" in the following order: Important - Fairly Important - Not important - Not avaliable (the same given in proc format).
I suppose the option ORDER=formatted is not what I need: could anyone help me?

Thank in advance
1 REPLY 1
L_L
Calcite | Level 5 L_L
Calcite | Level 5
I've found the solution

proc format;
value $ans (notsorted) 'Important'='Important'
'fairly important'='fairly important'
'Not important'='Not important'
'NA'='Not available'
;
run;
PROC TABULATE DATA=file;
CLASS score / missing PRELOADFMT ORDER=data;
keyword N colpctn;
TABLE
score=' '
all='Total',
(all=' ')*(N colPctN='%') /style=[cellpadding=7 cellspacing=0]
misstext='0';
format score $ans.;
RUN;

I hope that could be useful ..
regards
What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1118 views
  • 0 likes
  • 1 in conversation