Original Post: ________________________________________   Hi, I want to run a proc freq on all the fields (columns) and count the missing values. I have more than 100 fields - is there a way to use wildcard for all fields like * Data: Age   Race    Ethnicity   Gender 10      W              C              . .          W              C             M .          W              C              F   Data have:   The final table should look like this:                Missing        Not Missing           Total Age             2                      1                        3 Race           0                      3                        3 Ethnicity      0                      3                        3 Gender        1                      2                        3     Thank you   _Original question was solved - Thank you   _____________________________________________________________   ... View more

Hi, I successfully connected SAS with Sql server but am seeing  only a couple of tables in the schema, some are missing and are not in the list? Any insights??   libname study odbc datasrc= datasrcname prompt=yes schema = dbo user =  password =  multi_datasrc_opt = IN_CLAUSE;   Thank you ... View more

Hi, Have  data; var1 var2 var3 var4 -1     20    4      -1 60   -1     -1      -1; run;   want; var1 var2 var3 var4   want              (counts number of vars with -1) -1     20    4      -1         2 60   -1     -1      -1;        3   I have some vars with -1 value, I want to count how many vars have -1 values. Any ideas?  Thank you ... View more

Hi, I need some help with creating groups this is what i want:   IF value1 < 33 then score = 20 ; IF value1 < 33.5 then score = 12 ; IF value1 < 34 then score = 13 ; IF value1 < 35 then score = 3 ; IF value1 < 36 then score = 2 ; Else score = 4 ;   its not giving me the values I need . The cutoff eg. for the first row should be 33 and second should be 33.5?   Any ideas. ... View more

Hi, Is proc hpsplit same as (rpart) function in R?    Thanks     ... View more

I want to create a new variable called new var  conditions for recoding are: if var1 = 'A' and all other var2 - var5 are blank then newvar = A; if var1 = 'A' and any of the var2-var5 are B and nothing else in the vars (should be blank) then newvar = AB if var1='A' and var2= 'R' then newvar but all other vars should be null or blank = AR;     VAR1 VAR2 VAR3 VAR4 VAR5 VAR6 Newvar A           A A B         AB A   B       AB A     B     AB A       B   AB A R         AR A B R       ABR A R R       ARR A     R     AR   Basically I need help with how to tell if statement to make sure that the combination is correct provided all other variables are null.   Thanks ... View more

Create new variable based on if statement Options   2 seconds ago Hi, I want to create a new variable (newvar) based on conditional logic see below - i know this would be easy but I need help.   have: var1  var2   var3   var11  var12  var13   1           1      0          a       b                 1           1      1          b       b      c      0           1       1         d       b      c     1           0       0         a       b      c                             0       2                 a        c                  want: var1  var2   var3   var11  var12  var13  newvar 1           1      0          a       b              1      1     1            1      1         b       b      c      0       0 0           1       1         d       b      c      0       0 1           0       0         a       b      c      1       1                0       2                  a      c       1       2             (if var11 ='a" but if var11 is blank then look for the value of 'a' in the next var12, or var 13 and if matches 'a' then  newvar= var1 else if var13 matches 'a'  and var11 is blank then new var should have the value of var3)    I hope it makes sense 🙂 thanks ... View more