Hi Cynthia, I have started to look at some of your papers about proc template and data _null_ to create the ods pdf file. I'm hoping I can get the layout correct using those methods.  Do you think that this would work? Thank you ... View more

Thank you so much for the suggestion Cynthia I will be taking a look at it.  Here is an example of my test data ID    YEAR    CATAGORY    VNAMELABEL                QUESTION        LTR LTR_TEXT             CODE CODE_TEXT 1    1968      IndData       VAR1  "DUMMY VARIABLE"  "BIRTH MONTH?"     a   "definition for a"  1    January 1    1968      IndData       VAR1  "DUMMY VARIABLE"  "BIRTH MONTH?"     b    "definition for b"  1    January 1    1968      IndData       VAR1  "DUMMY VARIABLE"  "BIRTH MONTH?"     a    "definition for a"  2    February 1    1968      IndData       VAR1  "DUMMY VARIABLE"  "BIRTH MONTH?"     b    "definition for b"  2    February 1    1968      IndData       VAR1  "DUMMY VARIABLE"  "BIRTH MONTH?"     a    "definition for a"  3    March 1    1968      IndData       VAR1  "DUMMY VARIABLE"  "BIRTH MONTH?"     b    "definition for b"  3    March 1    1968      IndData       VAR1  "DUMMY VARIABLE"  "BIRTH MONTH?"     a    "definition for a"  4    April 1    1968      IndData       VAR1  "DUMMY VARIABLE"  "BIRTH MONTH?"     b    "definition for b"  4    April 1    1968      IndData       VAR1  "DUMMY VARIABLE"  "BIRTH MONTH?"     a    "definition for a"  5    May 1    1968      IndData       VAR1  "DUMMY VARIABLE"  "BIRTH MONTH?"     b    "definition for b"  5    May Thank you ... View more

Thank you Ksharp.  I appreciate the reply back. ... View more

kSharp, In your linking example is there a way to dynamically create the anchors within proc report? Thank you ... View more

Hi Cynthia, Thank you so much for your reply.  I apologize for my vagueness with the data but I'm not allowed to show can real data because of privacy concerns.  I did screen shot one of the pdf's i'm trying to duplicate and attached the images below show the text and the different links.  I do appreciate your suggestions and they have helped me get close.  The issue I have is that I don't have any authority to change the layout of this PDF.   That part is what is causing me the most frustration.  I know if I could do it however would work best that I would have it completed by now.  If this PDF can not be duplicated use ODS PDF then I will be forced to go to my lead and find an alternative solution.  Thank you again for all your help. ... View more

Hi Cynthia, Is what I'm trying to do possible in ODS PDF?  Can I post the pdf i'm trying to mimic to my post to show you what i'm trying to accomplish?  I've just been going in circles and I end up fixing one issue but causing a few more.  Is there a better way in SAS to create a PDF? Thank you again for all your help. Jerry ... View more

Hello, I've hit a small issue in terms of the layout.  I'm very close to getting the correct layout but when I add a new variable to my proc report it displays those values above the question instead of below the question.  My dataset is not a good as I think it should be.  I have to join another table that joins on the key and will expand my dataset by how many results match.  I took my original data and joined to my new table this is the results MyData Year Question AnsCode AnsText QType Letter 2010 "Is this the test 1?" 1 "Yes" "Intro"  A      2010 "Is this the test 1?" 2 "No"   "Intro"  A     2010 "Is this the test 1?" 3 "N/A"  "Intro" A     2010 "Is this the test 1?" 1 "Yes" "Intro"  B     2010 "Is this the test 1?" 2 "No"   "Intro"  B    2010 "Is this the test 1?" 3 "N/A"  "Intro" B    2010 "Is this the test 1?" 1 "Yes" "Intro"  C    2010 "Is this the test 1?" 2 "No"   "Intro"  C   2010 "Is this the test 1?" 3 "N/A"  "Intro" C   I need this data to display like this: Is this the test1?    NC Notes      A      B      C What i'm getting now is A B C Is this test1? Here is my code: ods listing ; title; footnote ; options orientation=portrait topmargin=.1in bottommargin=.1in rightmargin=.1in leftmargin=.1in; options nodate nonumber nocenter ; ods listing close ; ods escapechar='\' ; ods pdf file='c:\temp\other_report.pdf' style=JWTest ; ods pdf uniform ; proc report data=yz nowd      style(lines)=[TEXTALIGN=left]     style(header)={background=white}     style(report)={rules=none frame=void cellspacing=0 cellpadding=2px} ;     column vlabel vindex question vname letter ;        define vname / group noprint ;     define vlabel / group ' ' ;     define vindex / group ' ' ;     define question / group noprint ' ' ;                    define letter / group ' ' noprint ;      compute vlabel ;         call define(_col_,'style', 'style=[font_weight=bold cellwidth=7in marginleft=.50in just=l font_face=Courier ]') ;     endcomp ;           compute vindex ;                        urlstring='#'||strip(vname) ;         call define(_col_,'URL',urlstring) ;         call define(_col_,'style', 'style=[just=l font_face=Courier color=blue cellwidth=.80in]') ;                 call define(_row_,'style', 'style=[linkcolor=white]') ;                               endcomp ;        compute after question / style={cellwidth=7in marginleft=.50in just=l font_face=Courier}  ;                qlg = length(question);           line question $varying. qlg;     endcomp ;     compute after letter ;         qlg = length(letter);           line letter $varying. qlg;     endcomp ; run ; ods pdf close ; title; footnote ; Thank you again for everyones help. ... View more

Hi jwillis, Thank you so much for you suggestions.  I'm working on it now and will let you know what my results are.  With the help of everyone on this discussion I have a good portion generating and looking like the way I need it.  Thank you. ... View more

Thanks for the reply Cynthia, Sorry I didn't explain I will have freq data later in my pdf and I want to link the listed variable to it's freq data at a different point in my pdf.  I'm trying to create a table of contents with some description of my variables.  I will keep working and testing out a way to get the text to be a link. Thank you again. ... View more

Hi Cynthia, thank you for your reply.  Here is my code so far using the first approach: ods listing ; title ; footnote ; options orientation=portrait topmargin=.5in bottommargin=.5in rightmargin=.5in leftmargin=.5in ; options nodate nonumber nocenter ; ods listing close ; ods pdf file='H:\shared\jwarra\SAS_ODS_PDF\other_report.pdf' style=Temp ; ods pdf uniform ; proc report data=x nowd       style(lines)=[TEXTALIGN=left]      style(header)={background=white}      style(report)={rules=none frame=void cellspacing=0 cellpadding=2px} ;      column  year cname vname ;    define year / order order=internal noprint ;       define cname / order order=internal noprint ;    define vname / order order=internal noprint ;      compute before year / style={font_weight=bold font_face=Courier} ;       line year 4. ;    endcomp ;         compute before cname / style={font_weight=bold font_face=Courier marginleft=.50in} ;       qlg = length(cname) ;       line cname $varying. qlg ;    endcomp ;    compute before vname / style={font_face=Courier marginleft=.90in} ;       qlg = length(vname) ;       urlstring="#"||strip(vname) ;          call define('vname',"URL",urlstring) ;               line vname $varying. qlg ;    endcomp ;   run; ods pdf close ; title; footnote ; I have the layout working like I needed it. 2010   Intro     V1234 - Variable 1     V5678 - Variable 2   Sec1     V0009 - Variable 3 2014   Into     V4562 - Variable 4 My issue now is that when I try and do a compute with vname and add a url it doesn't generate a url on the pdf file. Should I remove the line option and make vname display instead of noprint?  Is there a way I can make the text the link not the cell? Thank you everyone for your help.  ... View more

Thank you Ksharp for all your help.  I'm slowly piecing everything together with everyone help. I will post all my code when I have it generating correctly. Thank you ... View more

Hi Cynthia, Thank you so much for your reply. On the alt_report is there a way to have the long question merge into the second column so the text is on top of the codes? Thanks again for all the help.  ... View more

KSharp & data_null_; thank you both so much for you replies.  It's been so frustrating trying to replicate this other pdf file using SAS.  I thought it would be more straight forward then it is.  Of course it's escapechar i've used it before but i'm so flustered. Thanks again and I will reply with any new or helpful information. ... View more

Hi RW9, I know I have to use an anchor but going off of KSharps example I could I implement the anchor on the question and the qtype? How come carriage returns in my data don't work within ODS? Thank you again for your help ... View more