Hello, I have a dataset with approximately 7,000 observations. There is one binary outcome variable (true/false) where about 2,000 observations have the outcome (=true). I suspect there may be combinations of the outcome positive observations which may be significant for certain variables but I have no way to know which variables in order to categorize them. I'd like to have SAS test combinations of the observations with the outcome to see which observations might be similar to each other based on the variables. Is there a way to have SAS categorize the "true" observations into smaller groups to test? I suspect this would be some sort of factorial (ex. observations 1+2, 1+3, 1+4, ... , n! where it only uses observations with the outcome of interest). ... View more

Hi, I have a dataset that has multiple variables which can have the same values within different values. For example:   Obs Var1 Var2  Var3 1 n1 n2 n3 2 n3 n4 . 3 n5 n1 .   In order to determine the frequency of each particular value I'm creating a new variable for each value using the following code: data want; set have; if whichc('n3',of var_1-var_20) then n3=1; else n3=0; run; The problem I'm encountering is that when I check the frequency of the values I create against the QC table I'm off by a small percent. For example, the QC table might say total observations with value n3 is 10,000 and when I do a proc freq on the new variable I get 10,020.   I'm wondering if the code might be double counting? If so I'm not sure how to fix this. Are there other reasons the counts could be off?   Thanks! ... View more

Hi folks, I'm trying to work with some of the US Mortality Multiple Cause files that are available for public use on the web but I'm unfamiliar with the file format. When I extract the files the dataset is in a DUSMCPUB file format. I can open it with Notepad++ and it looks like a text file, but I'm not sure. The codebooks say the variables are defined by tape positions.   Do you know how I can import these files? I'm unsure what the DBMS format should be using proc import and I don't see the file type in the wizard.   Thanks is advace. ... View more