Hi all,   I have character dates as in below format , is there any way I can convert to numeric. I tried using date11. but didn't work. data test; test_date1 = "16 June 2023"; converted1 = input(test_date1, date11.); format converted1  date9.; put test_date1= converted1=; run;   Thanks ... View more

Hi I have an excel sheet like below , I want column headers in row2 as variable names of sas dataset from sheet1 .Is there anyway I can do in proc import step ?      +-------+-----------------+----------------+ | A | B | C | +-------+-----------------+----------------+ | SEX | NAME | AGEC | +-------+-----------------+----------------+ | M | Alfred | 14 | | F | Alice | 13 |     I have tried something like this  but didn't work    proc import datafile="C:\in.xlsx" out=want dbms=xlsx replace; range='$A2: '; sheet='sheet1'; run;   Appreciate your response! ... View more

I have a sas macro catalog named test. This catalog contains list of macros (stored as catalogs). I want to remove specific catalogs from test. Is there a way to do in SAS? For example  test contains A,B,C ,V_A,V_B,V_C.I want to keep only A,B,C. Appreciate your response. ... View more

Hi all,   I have the following data       term event count drug Anthralgia yes 1 A Anthralgia no 5 A Nausea yes 1 A Nausea no 5 A Anorexia yes 1 A Anorexia no 5 A Cough yes 1 B Cough no 1 B Malaise yes 1 B Malaise no 1 B   I tried the following code to get relative risk and confidence interval   ods output relativerisks=rel;   proc freq data=test order=data;         weight count;         tables drug*event / relrisk ;        by   term ;         run;   ods output close;   I am getting the following message in log and ods output is not being created   No statistics are computed for  DRUG* EVENT because  DRUG has fewer than 2 nonmissing levels. May I know how to get the code work or any other proc to derive relative risk & CL for above data.   Appreciate response!   Regards Sri ... View more