Hi, I have a question with dates. I have a character value for date of birth which is 36223 and I want to convert it to any date format either date9 or yymmdd or mmddyy. My excel shows that date as 3/5/1999 but when I imported the excel to SAS it shows as character with 36223, I tried to convert to sas date using date9 or any other formats it gives me 3/4/2059 which is very weird. This is my program that I wrote to convert it to sas date format data have; set new; birthdate=input(dob, yymmdd10.); format birthdate date9.; run; I'm getting many missing values for other DOBs but some date of births that I get are not correct. As I mentioned above the character value of 36223 comes as 3/4/2059 after applying the format. Any help is greatly appreciated. thanks M ... View more

Hi SAS gurus, I'm trying to check multicollinearity between independent variables (all categorical including dependent variable which is obesity with yes/no categories) using proc logistic regression command. How do I check for multicollinearity using this command, what options work in proc logistic? proc logistic data=test; model Obesity= age, sex, BMI, height, weight; run; I know how to use VIF and TOL or CoLLIN options in Proc Reg but I don't know what option can be used in proc logistic. Can you please help! Thank you, M ... View more

Hello, I need some help in converting time to numeric value, well not numeric value but convert 00:10:00 to 10 or 00:10:12 to 10.12 in SAS. I tried using substr first to get only 10:00 but it didn't work.   Data dummy; set test; time=substr(time1, 3,5); /* To get only 10:00, starting from 3rd digit and get five digits*/ run;   I don't want to convert 00:10:00 as 600 which is the numeric value for 10 minutes. I want to take out the colons and just get the number.   Any help!!   Thank you M ... View more

Hi, I'm having difficulty  in transposing a variable. I don't use proc transpose that much, so I'm having problem with that procedure. I have a dataset that looks like:   ID        age   race  weight  Medication Administer_time 1        40      White  70       Tylenol           04/12/181:20:21 1         40     white   70      Advil              04/12/182:20:10 1        40       white  70     Motrin             04/12/183:30:15 2         50    Black  100    Tylenol            04/12/181:25:15 2         50    Black  100    Advil                04/12/181:25:15 2          50    Black  100    Benadryl         04/12/181:25:15 3        70   Asia      100    Claritin            04/12/181:25:15 3        70   Asia      100    Claritin            04/12/181:20:15 3        70   Asia      100    Bengay           04/12/181:30:15 3        70   Asia      100    Advil              04/12/181:40:15   I want to transpose Medication column and keep one observation per ID. How can I get the results? I want the output something like this:   ID        age   race  weight   Administer_time          Tylenol      Advil  Motrin  Benadryl  Claritin  Bengay 1        40      White  70     04/12/181:20:21             1                 1           1            0           0            0 2         50    Black  100    04/12/181:25:15              1               1             0           1            0            0 3        70   Asia      100    04/12/181:25:15              0                1           0            0            2            1     Any Help???   thank you M ... View more