I’m just learning ODS and Report Writing Interface. I'm trying to duplicate the attached report. From what I’ve read I don’t think I can use containers because the containers will not go from one page to the next page. You can see from the attached sample report that the report is basically a header/detail. There can be multiple contacts and the text for the note could be long and need to go from one page to the next. I started coding it with just a table with 4 columns – 2 cols for the labels and 2 cols for the data. I’m still working on trying to get rid of the borders on the cells and size the columns. I need to keep the border around the entire form. But I’m wondering if maybe there is a different, better way to go about the report rather than using tables. Will using a template give me the border around the report? Also I need to get rid of the first page that only has the title on it and start the table on the first page. I haven't been able to size the columns. What I try has no effect. Here is the code I have so far. %let destn =&csg_basepath./users/; ods listing close; options nodate nonumber; ods escapechar="^"; options papersize=(7in 7in); ods pdf notoc startpage=no file="&destn./RWITest4.pdf"; title "^{style [ just=center font_size=8pt backgroundcolor=cxccffff font_weight=bold font_face=arial] Summary Report for CCS, DWH and HSR}"; data _null_; set sashelp.class end=eof; if _n_ = 1 then do; dcl odsout adj(); adj.table_start(overrides: "width=7in"); end; adj.row_start(); adj.format_cell(data: "Member Name: ", style_attr: "color=red just=left", height: '1cm'); adj.format_cell(data: name, style_attr: "color=blue just=left ", height: '1cm'); adj.format_cell(data: "Sex: ", style_attr: "color=red just=left ", height: '1cm'); adj.format_cell(data: sex, style_attr: "color=blue just=left ", height: '1cm'); adj.row_end(); adj.row_start(); adj.format_cell(data: "Age: ", style_attr: "color=red just=left "); adj.format_cell(data: age, style_attr: "color=blue just=left "); adj.row_end(); adj.row_start(); adj.format_cell(data: "Height: ", style_attr: "color=red just=left "); adj.format_cell(data: height, style_attr: "color=blue just=left "); adj.row_end(); adj.row_start(); adj.format_cell(data: "Weight: ", style_attr: "color=red just=left "); adj.format_cell(data: weight, style_attr: "color=blue just=left "); adj.row_end(); if eof then do; adj.table_end(); end; run; ods pdf close; Thank you, ... View more

Is it possible to create a report that looks like the attached with some field names and data on the right side of the report? Thanks ... View more

Someone has asked me this question. I'm not sure that I see the point if it works like I think it does. If I create a SAS work table like this: proc sql;     create table work.worktable as     select myid from data.listofids; run; And then want to join it to some data that I get from say an Oracle server like this: proc sql; connect to oracle (user=&dbuser. pw=&dbpass. dsn="SERVICES" );             create table mbr_programs as             select * from connection to oracle (                         select m.myid, startdt, enddt, volume                         from work.worktable wt                         join (   select myid, startdt, enddt, volume from db.mb ) as m                         on m.mbr_id=wt.mbr_id ) ; disconnect from oracle; quit; I know if I put the worktable in the body of the query to the server it won't recognize it but is there any other way to do it? It seems like all the rows from the db.mb table are going to be returned first and then the join to the work table if it will work at all. Which seems pointless if the objective is normally to let the server do the work and reduce the rows coming back to SAS. But I have to ask. Thanks ... View more

I have two questions. Question one is if there is a better way to add a totals row to the data. I originally wanted to do it in a data step but couldn't figure out how to do it. Question two is about the last data step. When I put the totals1 and detail1 datasets together, originally I had detail1 listed first like "set detail1 totals1;" but when I did that it kept dropping the "a" in the sort column for the rows in the totals dataset. I thought it was because in the detail1 dataset that came first the sort column was only 1 character so it made the sort column 1 character which cut off the "a" when it started processing the totals1 dataset. So, I tried using the "length" statement but it didn't make any difference. I finally listed the totals1 dataset first and it worked. How could I have done it so that the "a" wasn't dropped? data have; input @1 h_id 1. @3 p_code $5. @9 a_u 1. @11 r_u 1. @14 start_date mmddyy10. @24  end_date mmddyy10. ; format start_date end_date mmddyy10.; cards; 1 J5563 2 4 03/17/2014 03/18/2014 2 J3363 4 2 03/18/2014 03/19/2014 1 J4789 2 6 03/19/2014 03/24/2014 3 J8434 2 2 03/20/2014 03/24/2014 3 J4444 5 5 03/21/2014 03/24/2014 1 J5563 3 1 03/24/2014 03/27/2014 ; run; proc sql; create table detail as select * from have ; run; proc sql; create table totals as select   h_id,   min(start_date) as start_date length=4 format=mmddyy10.,   max(end_date) as end_date length=4 format=mmddyy10.,   sum(a_u) as a_u,   sum(r_u) as r_u from detail group by h_id ; run; data totals1; set totals; /* length sort $2;*/ p_code='636'; sort=put(h_id,9.)||'a'; run; data detail1; set detail; /* length sort $2;*/ sort=put(h_id,9.); run; data combined; set totals1 detail1; /* length sort $2;*/ put _all_; run; proc sql; create table combined1 as select * from combined order by sort ; run; Thanks ... View more