Hello, I would appreciate help regarding the following. I am using proc report with ods pdf output in SAS 9.3. As part of the output, I would like to include a table with a variable number of rows. I am having difficulty getting the page breaks to occur at the correct locations with the correct formatting. For example, sometimes the last row is missing the bottom border. Also, I am getting the following error: "Continuing contents of page NN, which would not fit on a single physical page." I have spent a lot of time researching this error and have not been able to find a solution that applies to my situation. Therefore, I would like to see if there is a way to compute the number of lines in a table and then create page breaks after a certain number of lines. For example, below the number of lines is 9. Is there a way to compute this number? Column 1  Column 2    Column 3 ABC          blah blah      test test                  blah blah      test test                  blah test DEF          blah blah      test test                  blah blah      test test GHI           blah blah      test test                  blah blah      test test                  blah blah      test test                  blah              test Thanks, KelseyB     ... View more

Hello, I am using a multi-value prompt and have the code below. The prompt is called "DRGFilterCommas". I am getting a message when I run this that "DRGFilterCommas_Count" is not initialized and this is causing the program to work as intended (see below) even though earlier in the log it displays that the value of DRGFilterCommas_Count is 1. Any ideas as to why this is? My code: data _null_; length DRGsCommas_List $10000; if symget('DRGFilterCommas_Count')>=1 then do; DRGsCommas_List=cats("'", tranwrd("&DRGFilterCommas", ",", "','"), "'"); put DRGsCommas_List; /* just for checking */ put DRGFilterCommas_COUNT; /* just for checking */ call symputx('DRGsCommas_WHERE_CLAUSE',cats('and dr.DRGCode in (',DRGsCommas_List,')')); call symputx('DRGsCommas_JOIN_CLAUSE','INNER JOIN SQL_STG.DRG dr ON dr.DRGKey = e.DRGKey'); call symputx('DRGs_List_Displayed',DRGFilterCommas); end; else do; call symputx('DRGs_List_Displayed',"ALL"); end; run; Log shows the following: %LET DRGFilterCommas_count = 1;  NOTE: Variable DRGFilterCommas_COUNT is uninitialized.   Thanks, KelseyB ... View more

Hello, I am hoping someone can help me with the following. I have created a prompt within Enterprise Guide that accepts user-entered text as a single value. The user will enter a list of numbers or text separated by commas. I want to capture the list of values and then replace the commas with single quote comma single quote. For example: User enters 1,2,3, and it is stored in macro variable DRGFilterCommas. DRGCommas_List is created and stores '1','2','3' I do not want to allow the user to enter multiple values (I have tried that already), but the user could enter 30 values and entering one at a time is cumbersome as well. Here is the code I have so far: data _null_; DRGCommas_temp=tranwrd(%str(&DRGFilterCommas),",","','"); DRGCommas_List=cat("'",trim(DRGCommas_temp),"'"); run; Here is the error I am getting: ERROR 72-185: The TRANWRD function call has too many arguments. Any ideas on how to do this are greatly appreciated. Thank you, KelseyB ... View more

Hello, I am hoping someone can help me. I am using a multi-select prompt within Enterprise Guide called "Display_Options" and have created the following proc report procedure (which is within a macro) that correctly outputs a table with the columns that are chosen in the prompt. However, the unformatted values of the prompt are displayed, and I would like to display the formatted values. I think I need to assign a format to the label which is in double quotes on the define statement, but I can't figure out how to do that. Here's the proc report code: proc report data=WORK.TEMP4 nowd; column OrgName Provider_Name ProviderID ConsistentItem1, (%do j=1 %to &Display_Options_count; &&Display_Options&j %end;) ; define OrgName / group 'Organization Name' format=$100. missing order=formatted; define Provider_Name / group 'Provider Name' format=$101. missing order=formatted; define ProviderID / group 'Provider ID' format=$50. missing order=formatted; define ConsistentItem1 / across '' order=data missing; %do j=1 %to %eval(&Display_Options_count); define &&Display_Options&j / analysis SUM format=5.2 "???" missing; %end; run; quit; Here's the format for the column labels for the possible values for the prompt: proc format; value $Display MeanScore = 'Mean' ItemN= 'Item n' NumSIDs = 'Number of Respondents' TopBox = 'Top Box'; run; I would greatly appreciate any help on this. Thanks, KelseyB ... View more