Help using Base SAS procedures

question about proc tabulate

Reply
Contributor L_L
Contributor
Posts: 56

question about proc tabulate

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
Contributor L_L
Contributor
Posts: 56

Re: question about proc tabulate

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
Ask a Question
Discussion stats
  • 1 reply
  • 118 views
  • 0 likes
  • 1 in conversation