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.
