Dear all, I'm just wondering if there is a way which I can compare two SAS programs if they are exactly the same? Hope this is not a silly question to ask. Thanks in advance. ... View more

Dear all, I wish to read in my Excel data via libname but SAS doesn't read in all the columns when I open it. Here is my SAS syntax if you could please tell me what's wrong with it? libname chk EXCEL '\\IDMS\IDMS 2013.xlsx' mixed=yes stringdates=yes dbMax_text=32767; Thank you very much. ... View more

Dear all, Can I please ask how do I go about analyse a data with 3 variables as such -  a 2-block time variable with nth categories ie 12am-2am, 2.01am-4.00am and etc (time). -  2 count variables, one being the total number of calls made for the ith time category(n) and another one being the cases resolved for the ith time category(x). I wish to find out the adjusted proportion of cases resolved for each time categories taking into account the number of calls made at the same time. I would think the more calls made the more cases resolved and more weighting for that time slot. Is my proc genmod below correct? Or am i completely off the right track? Any input is greatly appreciated. proc genmod data=foo;    class time/ param=ref;    model x=time / offset=log_n dist=poisson link=log;    exact time / joint estimate; run; ... View more

Dear all, Can I please ask how to I group the time variable into 2-hour block category ie 12:00 AM - 2:00 AM, 2:01 AM - 4:00 AM,...., 10:01 PM - 11:59 PM. The time variable format is timeampm8. Thank you very much. ... View more

Dear all, I'd like to carry out a statistical significance test to see if there's a difference in proportions from 2 different samples. Let say I have 3 different ethnic groups namely Caucasian, Asian and Others in sample A and sample B. How do I test if proportion of Caucasian in sample A is statistically different from the proportion of Caucasian in sample B? Same to that of Asian and Others. Your help is greatly appreciated ... View more

Hi everyone. May I please ask how to I get from dataset A to B? Your help is greatly appreciated! A: id     string 1     8"A",1,2,8"C" 2     9"Q",3 3     4,5,9"P",9"Z",8"3/7" B: id     string                         comment8    comment9 1     8"A",1,2,8"C"              A. C             2     9"Q",3                                                  Q 3     4,5,9"P",9"Z",8"3/7"      3/7                  P. Z ... View more

Hi everyone. I'm wondering how can I generate the variable final given I have the dataset with variable id, flag and total more elegantly than what I've done(below)? Thank you very much and happy Easter!      id      flag     total    final        1         0         4       3        1         .         4        3        1         .         4        3        1         1         4       3        2         1         2        2        2         .         2         2        3         .         5         2        3         1         5        2        3         0         5        2        3         0         5        2        3         0         5        2        4         .         1         1        5         .         2         2        5         .         2         2 My code is: data b;   set a;   by id;   retain total2 0;   if first.id then total2=total;   if flag=0 then total2=total2-1; run; proc sql; select *, min(total2) as final from b group by id; quit; ... View more