Hello! I encountered a weird error while trying to use PROC SGPANEL, error message pasted at the bottom since it's long. The one thread I found on this suggested it might be caused by some strange character, but I don't have any weird characters in my data, there aren't any macros, and I haven't copied/pasted it to a word processor. Here is my code:   proc sgpanel data=example; panelby disease; series x=year y=proportion / group=sortvar; keylegend / title="Legend Title"; rowaxis label="Year"; colaxis label="Proportion"; format sortvar sortvarf. disease diseasef.; title "Graph Title"; run; Example data below. I created the table via some SQL queries, the table looks fine to me but I can share those queries if that would be helpful.   data example; input year disease sortvar count1 count2 proportion; datalines; 2010 1 0 64 240 0.267 2010 1 1 6 8 0.750 2010 2 0 171 572 0.299 2010 2 1 89 233 0.382 ; run; Thank you for the help!     ERROR: An exception has been encountered. Please contact technical support and provide them with the following traceback information: The SAS task name is [SGPANEL] ERROR: Read Access Violation SGPANEL Exception occurred at (06882F72) Task Traceback Address Frame (DBGHELP API Version 4.0 rev 5) 0000000006882F72 000000003504F560 sasods:tkvercn1+0x181F32 000000000D329C3A 000000003504F568 sasxml:tkvercn1+0x48BFA 000000000D30EF48 000000003504FB80 sasxml:tkvercn1+0x2DF08 0000000006921D0A 000000003504FBC0 sasods:tkvercn1+0x220CCA 0000000006884769 0000000035050080 sasods:tkvercn1+0x183729 000000000E1D831A 0000000035050088 sasmrk:tkvercn1+0x1172DA 000000000E14251E 0000000035050830 sasmrk:tkvercn1+0x814DE 000000002D6A1BDA 0000000035050838 sasstgr:tkvercn1+0x90B9A 000000002D61C289 0000000035050A00 sasstgr:tkvercn1+0xB249 000000002D66A100 0000000035051070 sasstgr:tkvercn1+0x590C0 0000000008A9C09A 0000000035051078 saswobc:tkvercn1+0x1B05A 0000000008A8BE65 0000000035051180 saswobc:tkvercn1+0xAE25 000000002D6A1BDA 00000000350511C0 sasstgr:tkvercn1+0x90B9A 000000002D627B84 0000000035051240 sasstgr:tkvercn1+0x16B44 000000002D6A1BDA 0000000035051280 sasstgr:tkvercn1+0x90B9A 000000002D66A4DF 00000000350518F0 sasstgr:tkvercn1+0x5949F 0000000008A9C09A 0000000035051930 saswobc:tkvercn1+0x1B05A 0000000008A8BE65 0000000035051A00 saswobc:tkvercn1+0xAE25 000000002D6A1BDA 0000000035051A40 sasstgr:tkvercn1+0x90B9A 000000002D627B84 0000000035051AC0 sasstgr:tkvercn1+0x16B44 000000002D6A1BDA 0000000035051B00 sasstgr:tkvercn1+0x90B9A 000000002D62CB86 0000000035052770 sasstgr:tkvercn1+0x1BB46 000000002D6A1BDA 00000000350527B0 sasstgr:tkvercn1+0x90B9A 000000002D67C388 0000000035052830 sasstgr:tkvercn1+0x6B348 000000002D6A1BDA 0000000035052870 sasstgr:tkvercn1+0x90B9A 000000002D689D20 0000000035052D50 sasstgr:tkvercn1+0x78CE0 000000002D6A1BDA 0000000035052D90 sasstgr:tkvercn1+0x90B9A 000000002D687F74 0000000035053980 sasstgr:tkvercn1+0x76F34 000000002D6A1BDA 00000000350539C0 sasstgr:tkvercn1+0x90B9A 000000002D68CAB5 0000000035053A30 sasstgr:tkvercn1+0x7BA75 0000000006921D0A 0000000035053A70 sasods:tkvercn1+0x220CCA 0000000006755CFD 0000000035053D10 sasods:tkvercn1+0x54CBD 0000000006754F4D 0000000035053FE0 sasods:tkvercn1+0x53F0D 0000000006921D0A 0000000035054020 sasods:tkvercn1+0x220CCA 000000000677B902 0000000035059330 sasods:tkvercn1+0x7A8C2 0000000033FB42AA 0000000035059338 sassgpan:tkvercn1+0xC326A 0000000033F2EE29 000000003505FBB0 sassgpan:tkvercn1+0x3DDE9 00000000034AA346 000000003505FBB8 sashost:Main+0x11E86 00000000034B040D 000000003505FF20 sashost:Main+0x17F4D 00007FF9194A7034 000000003505FF28 KERNEL32:BaseThreadInitThunk+0x14 00007FF91A3E2651 000000003505FF58 ntdll:RtlUserThreadStart+0x21 NEWLINE FUNCTION NOT DEFINED IN THIS TAGSET NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SGPANEL used (Total process time): real time 0.09 seconds cpu time 0.04 seconds ERROR: Event Stack Underflow. This is probably caused by mis-matched begin and end event calls. NOTE: There were 54 observations read from the data set WORK.EXAMPLE ... View more

I'm trying to create a PDF report containing a lot of small tables and accompanying text. I can fit more than one table per page, so I am using "startpage=no" so multiple tables appear on a page, otherwise the report would be really long. However, tables are being split across two pages when they can't fit on the current page. I would like to start a new page if the table cannot fit on the current page, and ideally start a new page for different sections of the report. How do you add page breaks when using startpage=no?   Not sure if my code is necessary here, but here is my code to open the file: ods escapechar="^"; ods pdf file="title.pdf" startpage=no; options nodate; Thank you for the help! ... View more

Hello! I am working with a set of survey data. Each question is saved as a variable, and the answers are coded as 1/0 for yes/no or 1/2/3 for always/sometimes/never. There are around 50 questions. Example data below:  data have; input name $ q1 q2 q3 q4 q5; datalines; FacA 1 0 1 2 2 FacB 0 0 3 2 3 FacC 1 1 2 1 3 ; run; I'm trying to generate a list of the most common issues identified on the survey, i.e. the most common questions with an answer other than 1. How can I create a table with the question number (variable) and the number of survey responses that identified that as an issue? I am using 9.4.   Thank you for the help! ... View more

Hello!   I'm trying to generate a report to briefly show how a facility responded to a survey. I currently have my data in this format, where there are variables listing all questions that they provided that answer to.  data have; input fac_name $ ans_yes $ ans_no $ ans_always $ ans_sometimes $ ans_never $; datalines; "Facility A" "yes answers" "no answers" "always answers" "sometimes answers" "never answers" "Facility B" "yes answers" "no answers" "always answers" "sometimes answers" "never answers" ; I would like to generate a PDF report with a page that basically looks like this for each facility:   Facility Name: fac_name Answered "yes": ans_yes Answered "no": ans_no  Answered "always": ans_always Answered "sometimes": ans_sometimes Answered "never": ans_never   Basically, on each line I would like a string of text (ex. 'Answered "yes"') followed by the value of the variable for that facility. I can only figure out how to provide output in a table format, is there a way to just print values of a variable to a PDF document like this?    Thank you! ... View more