Hi,   I have a table with two rows in it, and 18 variables.  The first row contains summary values from other stuff and the second row is my summary of the same values (it's a quality control check).  I want to make sure that my totals match the totals from the other source.   So, two rows, 18 columns.  Looks vaguely like this:                  c4        c5        c6   etc.... all             100    293       284 confirm     100    291       284   And i want to add a row that compares the all value in C4 with the comfirm value for C4, etc.  So i end up with this:                  c4        c5        c6   etc.... all             100    293       284 confirm     100    291       284 match        1        0            1   Thanks, Megan   pw.  Once i get this to work, it'll be applied to about 56 different tables, so it's not that i just don't want to eye scan the values themselves.  There are going to be quite a few of them.   Thanks.         ... View more

Hello,   Does anyone know how to use proc report and get text outside of the table?  The output needs to (vaguely) look like this: PATIENTS: Patient Profile Contains one record per patient in the database, and gives basic demographic and related data. Variable         Type     Length     Format             Comment ADRIND             num         8                                 This patient is included in the cohort ADRINDTXT     char         1         $ADRINDT.     Reason this patient was not included in the cohort BORN                 num         8         MMDDYY10.     Date of Birth [blah blah more meta data...]   ************************ I have the table grid worked out, but not the text above it, which is three variables: [name] : [Desc1] [Desc2]   Here's the code i have so far: ods listing close; ods pdf file="&path.AppendixB.pdf"; proc report data=Formats3 nowd headline headskip wrap center;     column name desc1 desc2 variable type length format comment;     define variable / width=12 "Variable";     define type     / width=9 "Type";     define length    / width=16 "Length";     define format    / width=254 "Format";     define comment    / width=254 "Comment"; run; ods pdf close;   Thanks Megan       ... View more

Hello,   I'm trying to output what is basically just a print out of a formats catalog and two things keep happening: 1.  I cannot for the life of me stop it from printing thousands and thousands of lines in the log.  How do i keep it from writing to the log???  I thought it was ods listing close, (even tried ods _all_ close) but that doesn't appear to do anything at all.   2.  I keep getting this in the log.  I have a run statement before ods pdf close. ?: 1031  /****PDF TEST*****/ 1032  ods _all_ close; 1033  ods pdf file="&path.AppendixC.pdf"; NOTE: Writing ODS PDF output to DISK destination       "[path removed for confidentiality]\AppendixC.pdf", printer "PDF". 1034  data _null_; ... [thousands of lines of crap - no error messages or warnings at all though] ... 1009  ods pdf close; NOTE: ODS PDF printed no output.       (This sometimes results from failing to place a RUN statement before the ODS PDF CLOSE       statement.)     My code: ods _all_ close; ods pdf file="&path.AppendixC.pdf"; data _null_;     set formats2;     by sort;     /*Longest name is 11, Type is 9, Value is 16, Label is 50.*/     put @1 Name @12 Type @23 Value @37 Label1;     if label2 ne "" then do;     put                                @37 Label2;     end;     if label3 ne "" then do;     put                                @37 Label3;     end;     if label4 ne "" then do;     put                                @37 Label4;     end;     if label5 ne "" then do;     put                                @37 Label5;     end; run; ods pdf close;     Thanks, Megan ... View more