Hi there,  I have several categorical variables with multiple categories. For example: has disease x, doesn't have disease x, unknown I want to get the percentage (prevalence) of each with 95% CIs around the estimates. How do I go about doing this? Thanks!   ... View more

Hi all,  I have a database that contains the names of antibiotics. Multiple people were entering data and for each antibiotic I have at least 5 different spellings.  How can I make them consistent? I tried the following in a data step, but sadly SAS did not like it   if abx_name contains("31", "IPROFLOXACIN","CIPROFLOX","J01MA02") then Ciprofloxacin="Yes";   I hope you can follow the logic of this and can figure out what I was trying to do.  Thanks,  K_S ... View more

Hi all,  I am hoping to get your help with the following: I have a database that looks like this  year  sex are a status  incidence  prevalence  2000 F ON 0 5 200 2001 F ON 0 6 300 2002 F ON 0 5 350 2003 F ON 0 5 201 2004 F ON 0 4 222 2005 F ON 0 2 333             and I want to 'mush' together rows to get this :   year  sex are a status  incidence  prevalence  2000/2002 F ON 0 16 850 2003/2005 F ON 0 11 756     Note that I am simply adding the years. I have several thousands of these so doing it by hand in excel is not very practical.  Any idea of how to do this in SAS?  Thank you in advance! ... View more

Hi all,  In the dataset i'm using, missing observations are coded as -1. I am running a format step and not sure how to recode the -1... I currently have low-<1='missig', but I am not sure if this is the right/best way to do this. Any other tips?  Also, what exactly does the low-<1 do? Thank you all in advance. KS ... View more

The database that I am working with records lab values as character variables beacuse lab techs sometimes write notes/comments instead of enter a numeric lab results. I have been converting this variable to numeric by adding a 0 to it (i.e. character_var+0) ...this seems to do the trick, but am wondering if there are any downsides to doing this. I am only interested in the numeric measurements so other than ending up with missing fields where there were notes/comments are there any downsides to doing this? ... View more