Hello.  I'm trying to do different tables with proc tabulate where I have the first one on a page in portrait orientation, then the next one in landscape orientation, and then back to portrait orientation.   This is the code I am using for the first one in portrait orientation, followed by the error I'm getting.  Any help would be much appreciated.   ods graphics on; 56         ods RTF options (ID=EGRTF Orientation="Portrait");                    _______           ___________                    22                79                    202               202 ERROR 22-322: Syntax error, expecting one of the following: ;, (, ANCHOR,               AUTHOR, BASE, BODY, BOOKMARK, BOX_SIZING, CHARSET, CLOSE,               COLUMNS, CONTENTS, CSSSTYLE, DATAPANEL, DOM, DPI, ENCODING,               EXCLUDE, FILE, FONTSCALE, GFOOTNOTE, GTITLE, HOST, IMAGE_DPI,               KEEPN, LSTPIPE, NEWFILE, NOCONTENTS, NOGFOOTNOTE, NOGTITLE,               NOKEEPN, NOLSTPIPE, NOOUTLINE, NOTRKEEP, OPERATOR, OUTLINE,               PACKAGE, PATH, RECORD_SEPARATOR, SAS, SASDATE, SELECT, SGE, SHOW,               STARTPAGE, STYLE, TEXT, TITLE, TRANTAB, TRKEEP.  ERROR 79-322: Expecting a ). ERROR 202-322: The option or parameter is not recognized and will be ignored. ... View more

I have the code below, which works to create the tables I want.  However, I want the first table to be in portrait orientation on the page, then the second table in landscape orientation, and then the last three tables back to portrait orientation.  This code isn't working to do that.  What do I need to do?   Thanks,   *FIRST TABLE; options orientation=portrait; proc tabulate data=top25wvars  ;    class diag1ccs / order=freq;    class age_3cat;    table diag1ccs=' ',          (all='All' age_3cat=' ') * n=' '          /box='Top 25 CCS diagnoses'    ;   run;     *SECOND TABLE; ods RTF(ID=EGRTF) startpage=now; options orientation=landscape; *second part: gender, weekday vs weekend, discharge disposition; *Now we want the adults only; data adultstop25;  set top25wvars;  if age_3cat ^=2 then delete;  format female gender.;  format aweekend WEEKEND.; run; proc tabulate data=adultstop25;    class diag1ccs / order=freq;    class female aweekend dispuniform_4cat;    table diag1ccs=' ',          (all='Adults' female=' ' aweekend=' ' dispuniform_4cat=' ') * n=' '          /box='Top 25 CCS diagnoses'    ;       run;     *LAST THREE TABLES; ods RTF(ID=EGRTF) startpage=now; options orientation=portrait; proc tabulate data=top25wvars;    class diag1ccs / order=freq;    class age_3cat timeofyear;    table age_3cat, diag1ccs=' ',          (timeofyear=' ') * n=' '          /box='Top 25 CCS diagnoses'    ;    run;   ... View more

I am trying to make a report that would look like this:   Top 25 diagnoses: All Age 0 Ages 1-17 Ages 18+ Most frequent diagnosis 560000 20000 270000 270000 Second most frequent diagnosis 500000       …..         25 th most frequent diagnosis           This is the code I have so far:   proc report data=top25wvars nowd;        column diag1ccs age_3cat;        define diag1ccs / 'Top 25 CCS diagnoses' group style(header)={text_decoration=underline};        define age_3cat/ across; run;   What I haven't been able to figure out is how to get the "All" column into the table.  The "All" column would have the counts of the top 25 diagnoses (all, not broken out by age), in descending order with the most frequent diagnosis at the top to the least frequent diagnosis.  The column with "Top 25 CCS diagnoses" also needs to be in descending order from the most frequent diagnosis at the top to the least frequent diagnosis.   Thanks for your help.   ... View more

I have code like this (see below) where I get the top 25 diagnoses:   proc freq data=&dataems order=freq;     tables diag1CCS/noprint out=counts;  run;   data state;    set counts (obs=25);    drop percent; run;   Then I want to write another program to go back to my original data (&dataems) and keep only the records with the top 25 diag1ccs categories.  How could I do that without having to copy and paste the top 25 diag1ccs categories into another data step?  I want a more automated process, because I will end up having to do this over 100 times.   Thanks for your help. ... View more

I used code like this (see below) to pull the highest 5 scores out of a list of variables, and then I calculated the mean of the 5 highest scores.   array v{*} sd_1wk_1c sd_1wk_2c sd_1wk_3c sd_1wk_4c sd_1wk_5c sd_1wk_6c sd_1wk_7c sd_1wk_8c sd_1wk_9c sd_1wk_10c  sd_1wk_11c sd_1wk_12c sd_1wk_13c sd_1wk_14c sd_1wk_15c sd_1wk_16c;    array l{5};     do i=1 to dim(l);         l[i] = largest(i,of v(*));     end;  mdasisdhigh5_1wk=mean(of l1,l2,l3,l4,l5);   You can see the attachment to see what the resulting data look like.   Now I need to pull which 5 variables supplied the 5 highest values.  That will tell me which of the 16 symptoms were the highest for each subject.   How would I do that?   Thanks!       ... View more

Hello.  I need to delete characters at the end when the string has a delimiter and different lengths.  Here are two examples of my data values:   114wr01_ws02_2_3_MA_6_27_17 123abr01_abs03_2_1_CC_7_12_17   I need to delete the 4th underscore and everything after it.  What would be the easiest way to do this?   Thanks. ... View more