I have an issue that I think might work best with a do until loop. I have patient data for multiple hospital admissions and I want to keep all the records up until and including their first positive test, but delete the records after the first positive record. Here's the data I have: repid date postive 125 1/12/2014 0 125 1/15/2014 1 1447 4/12/2013 0 1447 11/12/2013 0 1447 5/6/2014 0 1447 6/7/2014 0 1447 11/20/2014 1 1447 1/10/2015 0 1447 3/15/2015 0 88459 1/6/2014 0 454878 12/8/2014 0 316 2/9/2014 0 316 3/18/2014 0 316 6/2/2014 0 316 9/28/2014 1 316 12/1/2014 0 Want: repid date tive 125 1/12/2014 0 125 1/15/2014 1 1447 4/12/2013 0 1447 11/12/2013 0 1447 5/6/2014 0 1447 6/7/2014 0 1447 11/20/2014 1 88459 1/6/2014 0 454878 12/8/2014 0 316 2/9/2014 0 316 3/18/2014 0 316 6/2/2014 0 316 9/28/2014 1 Thanks, Sarah ... View more

Hi All, I want to calculate the relative risk and 95%CI using the FM Score in proc freq. I'm interested in comparing the the WAld CI and the FM CI. However, when I add it to my code I get this error: 130  proc freq data=Data.xxx; 131     132      table any_dia*status/ EXACT RELRISK (METHOD=FMscore) ;                                             ERROR 22-322: Syntax error, expecting one of the following: PDIFF, RDIFF, RISKDIFF, RISKDIFFC. ERROR 76-322: Syntax error, statement will be ignored. 133  run; It looks like I should use the riskdiff to use this option. However, I do not want the risk difference and  this documentation says I can get the FMScore from relrisk. Base SAS(R) 9.3 Procedures Guide: Statistical Procedures I'm using version 9.3. Any ideas?     ... View more

Hi All, I am working on some graphs and getting a funky result with sgplot. I'm plotting fecal results by day. Most subjects have 0 fecal culture at day 1, but when I add in the subject with >0 fecal culture, sgplot creates a diagonal line. Graph 1 shows that one subject has a fecal culture of 3 and instead of dropping to 0 on the rest of the days as is in the dataset, sgplot draws a diagonal line. Graph 2 shows how this subject's results should be shown. How do I force sgplot to represent the true values for this subject? I have tried to set 0 values to 0.1 for this subject and get the same results. I also do not want to take out this subject from the graph. Thanks, Sarah ... View more

I have a plot where a lot of the data is clustered around the 0 to 250 values on xaxis. It's difficult to see how many datapoints there are and so I'd like to expand the x-axis. However, the max value for the x-axis is over 2000 and there are not many datapoints in between 1000 and 2000. Therefore making the plot wider also increases the dead space. Is there any way to zoom in on the lower end of the x-axis and then truncate the the middle of the plot? Ideally, I'd like to show 0 to 500 by 50 and then 500 to 2000 by 500.  Thanks! Sarah ... View more

Hi All, I've searched the internet and the forum, but I can't find a simple way to add the greater than or equal to symbol to a title in sgplot. Thanks! Sarah ... View more

Can I have multiple formats on a variable in proc report? I have some data that I want to show as a percentage so I use format=PERCENT6.2. I also want to missing values to show up as "ND" and created a format so that .='ND.' However, the following code does not work to turn missing values in 'ND.' How do I do this? define numvar/display 'Number Variable' format=nodata. FORMAT=PERCENT6.2; ... View more