Hi all,   I have had a theoretical question in mind for long time. Does the order matter while resetting values in RETAIN statement?   Ex -   proc sort data=have; by subjid parameter visit; run;   data want; retain total 0; set have; by subjid parameter visit; if first.parameter then total=0; if variable1='NOT DONE' then total=total+1; run;   Does it produce the same result if I change the order of the statement marked in red?  That is 1. if variable1='NOT DONE' then total=total+1; 2. if first.parameter then total=0;   In some complex cases I think I have seen the resetting statement (if first.parameter then total=0;) at #1 does not actually reset the value of total. But I could not found any theoretical basis for the ordering of the statements.    Any help will be appreciated.   ... View more

Hello,  I have a tricky programming question. How do I add new records based on the value of a variable in the subsequent record?   As an example, I have this input data   Subj         Test         Status                          Frq 1001        Test 1       Done                           1 1001        Test 2       Done                           1 1001        Test 3       Done                           1 1002        Test 1       Done                           1 1002        Test 3       Missed previous          1 1003        Test 3       Missed previous         2   I want the following output data   Subj         Test         Status                          Frq 1001        Test 1       Done                           1 1001        Test 2       Done                           1 1001        Test 3       Done                           1 1002        Test 1       Done                           1 1002         Test 2      Missed 1002        Test 3       Done                           1 1003         Test 1      Missed                       1003        Test 2       Missed 1003        Test 3       Done                           1   So the records in red are added based on the value in Status column. Can anyone help me create a dynamic SAS code to get the output dataset?   Many thanks! ... View more

Hi folks,   I have an issue with the GROUP= options in SGPLOT.   So basically I'm doing line plot for some lab tests - plotting median, minimum, maximum - using 3 plot (series) statement. I have 2 treatment group (A, B). Some tests have been done for both treatment, some are done only for either of them. Now for those tests which are done for both treatments, the graph looks fine (first graph in the attachment). But for those which are done for either treatment the data colors are not getting assigned correctly. In 2nd graph in attachment, treatment A should get black as in the x-axis table beneath the plot. Instead the median line is getting blue but the minimum and maximum are getting black. Attached is my code.  %do i=1 %to &tests.; proc sgplot data= lb4(where=(param="&&par&i")) noautolegend noborder; styleattrs datacolors=(black blue) datacontrastcolors=(black blue); series x=avisit1 y=max1 / group=trt grouporder=reversedata lineattrs=(thickness=2 pattern=shortdash) nomissinggroup; series x=avisit1 y=median1 / group=trt grouporder=reversedata lineattrs=(thickness=2 pattern=solid) name='c' nomissinggroup; series x=avisit1 y=min1 / group=trt grouporder=reversedata lineattrs=(thickness=2 pattern=shortdash) nomissinggroup; yaxis type=log logbase=10 /*logstyle=logexponent*/ logvtype=expanded max=1000 label="&&unit&i"; xaxis type=linear values=(0 to 6 by 1) label='Months since infusion'; xaxistable count / class=trt labelattrs=(size=8) colorgroup=trt pad=(top=1cm) location=outside valueattrs=(size=8) label="Number of(*ESC*){unicode '000a'x}patients:"; keylegend 'c' / location=inside position=bottomright ; run; ods startpage=yes; %end; Does anyone know why this is happening? Is there anything wrong in the GROUP= option or STYLEATTRS statement? Any help is appreciated.   I'm using SAS9.4 (M5) in Windows 64 bit.     Thanks ... View more

Hi,   I am using PROC SGPLOT with a custom style (by GTL) to create a graph. I'm getting the following errors.   ERROR: An exception has been encountered. Please contact technical support and provide them with the following traceback information: The SAS task name is [Submit] ERROR: Read Access Violation Submit Exception occurred at (0F9306C0) Task Traceback   ERROR: Generic critical error.   After doing some google I got this page from SAS.   http://support.sas.com/kb/58/128.html   So I went on to add FROM option to all my style elements in PROC TEMPLATE. But I'm still getting the same error. Any help will be highly appreciated.   Thanks   P.S Using version 9.4   proc template ; define style DANPDF ; /*template name*/ parent=styles.printer ; style fonts from fonts / 'TitleFont' = ("Courier new",9pt) 'TitleFont2' = ("Courier new",9pt) 'headingFont' = ("Courier new",9pt) 'docFont' = ("Courier new",9pt) 'footFont' = ("Courier new",9pt) ; style GraphFonts from GraphFonts / 'GraphAnnoFont' = ("Courier new",9pt) 'GraphTitle1Font' = ("Courier new",9pt,bold) 'GraphTitleFont' = ("Courier new",9pt,bold) 'GraphFootnoteFont' = ("Courier new",9pt) 'GraphLabelFont' = ("Courier new",9pt) ; style GraphDataDefault from GraphDataDefault / endcolor = CX000000 neutralcolor = CX000000 startcolor = CX000000 markersymbol = "circle" linethickness = 1 linestyle = 1 contrastcolor = CornflowerBlue color = CornflowerBlue; style GraphData1 from GraphData1 / markersymbol = "circle" linestyle = 1 contrastcolor = CornflowerBlue color = CornflowerBlue; style GraphData2 from GraphData2 / markersymbol = "circle" linestyle = 1 contrastcolor = DarkOrange color = DarkOrange; style GraphData3 from GraphData3 / markersymbol = "circle" linestyle = 1 contrastcolor = DarkGray color = DarkGray; style GraphData4 from GraphData4 / markersymbol = "circle" linestyle = 1 contrastcolor = Gold color = Gold; style GraphData5 from GraphData5 / markersymbol = "circle" linestyle = 1 contrastcolor = Crimson color = Crimson; style GraphData6 from GraphData6 / markersymbol = "circle" linestyle = 1 contrastcolor = LimeGreen color = LimeGreen; style GraphData7 from GraphData7 / markersymbol = "circle" linestyle = 1 contrastcolor = Blue color = Blue; Style table from output / background=_UNDEF_ rules=groups frame=hsides cellspacing=0.01mm cellpadding=1mm borderwidth=0.01mm; Style HeadersAndFooters from Cell / background = _undef_ font = Fonts('TitleFont') ; Style SystemFooter from TitlesAndFooters / font = Fonts('footFont') just = LEFT ; Style Body from Document / bottommargin = 1.40cm topmargin = 2.1cm rightmargin = 1.7cm leftmargin = 1.7cm; end ; run ;   ... View more