Hello SAS community,   Currently I'm leaning towards some variations of Chi-Squares test. Particularly MH-Chisq but I would like to confirm before proceeding.    My data structure is as the following:   data have; input StudyID location$ X1 X2; datalines; 1 N 0 0 1 E 0 1 1 S 1 1 2 N 1 1 2 W 1 1 2 E 1 0 2 S 1 1 ; run; StudyID - the subject ID ranges from 0-200 location - Categorical variable with possible values N,W,S,E. Each subject has measurements at taken at different locations, with a maximum of 4 different locations and minimum of 1 location.  X1 and X2 - binary variables Yes/No type. I would like to test and see if there is any associations between X1 and X2.  I believe the ordinary Chi-Square test runs under the assumption that observations are independent. But in my case I believe the observations are correlated within subjects. Is there a variation of the chi-square test where it takes the correlated data into consideration?    Thank you in advance! ... View more

Hi all,    For simple 1-way frequencies I know Proc Freq can do all variables in a data set if I just don't specify anything in the table option.   But I would like to create 2-by-2 tables with say variable Z.  So if my data set have columns W X Y Z, I would do: Proc freq data = have; table W*Z X*Z Y*Z; run; But my data set has like 70 variables. I was wondering if there is a way to this with all variables, or all but certain variables.    Thanks,   Jacky ... View more

Hello all,   I'm pulling table from SQL, say I have a column named "illness": ID | illness ----|--------- 1 | fever,headache 2 | headache 3 | cough,fever 4 | cough,fever,headache In total there are, 4 possible categories (fever, headache, cough, other), how can I go about separating it into 4 columns with 0 or 1 values ID | fever | headache | cough | other ----|------|----------|-------|--------- 1 | 1 | 1 | 0 | 0 2 | 0 | 1 | 0 | 0 3 | 1 | 0 | 1 | 0 4 | 1 | 1 | 1 | 0   Thank you   ... View more

Hello everyone,    First time posting, I don't know if this is the right place to ask. But I'm using ODBC to access a database. I'm trying to read a table with a name longer than 32 characters. Are there anyway to work around this problem?  Asking the database management to change the table name is not an option...   An example of my code: data t; set mylib.xxx; run; where 'xxx' is actually 51 characters long.    Currently I have two solutions in mind:    1) Uninstalling current SAS and download the 64 bit version    2) Export the data by hand   But I would like to know if there are other simpler approaches before I try these two options.  Thanks ... View more