SAS Support Communities

I have an issue.. I am using the ODBC with proc sql. This is my code proc sql noprint; connect to odbc as atest (noprompt="DRIVER=Microsoft Excel Driver (*.xls); DBQ=xxxxx.xls;"); create table day4 as select * from connection to atest ( select * from "abc tensile test 6-2-11.is$" ); disconnect from atest; quit; Now the excel file reads in, but in my original data file I have some values for id that have 201 202 203 R201 R202. So SAS gives me missing values for all the character variables but reads in only numeric. How do I define conversion of numeric to character variable inside my data step above in proc sql. Any help is appreciated Thanks ... View more

How do I import an excel file that has multiple variables in one cell? For instance 1 1001 1 M Day 2 3/16/2011 >276 1.3 >1655 0.17 The item in bold italic is in one cell. How do I separate it into multiple variables. The variables are id,day,sex,phase,date,a1,a2,a3,a4 It has to look like obs id day sex phase date a1 a2 a3 a4 1 1001 1 M Day 2 3/16/2011 >276 1.3 >1655 0.17 Also the observations in the excel start from 16th or 17th row. The first few rows has other info that are junk. How do I read in data from here and get rid of the junk above. Thanks a lot for your help. ... View more

How do I import an excel file that has multiple variables in one cell? For instance 1 1001 1 M Day 2 3/16/2011 >276 1.3 >1655 0.17 The item in bold italic is in one cell. How do I separate it into multiple variables. The variables are id,day,sex,phase,date,a1,a2,a3,a4 It has to look like obs id day sex phase date a1 a2 a3 a4 1 1001 1 M Day 2 3/16/2011 >276 1.3 >1655 0.17 Also the observations in the excel start from 16th or 17th row. The first few rows has other info that are junk. How do I read in data from here and get rid of the junk above. Thanks a lot for your help. ... View more

How is it possible to determine the number of estrous cycles in dogs when the occurrence of the cycle is given. For instance, when the determinants of the cycle is given by DI,PR,ES,ME,S,P where DI=diestrus,PR=Proestrus,ES=estrus,ME=metestrus,S=sperm,P=plug. The occurrence of estrus is only that matters and the cycle is given by EST DI DI DI MET EST -- here the length of the cycle is 5 until the occurrence of next estrus. A cycle is calculated from one estrus to another estrus. The length of the cycle is the period until next estrus occurs which is 5 in the above case. How do I write a code to calculate this in Statistics. The endpoint is to calculate the number of cycles and length of each cycle. The output has to look like this: animal_id cycle1 cycle2 cycle3 101 5 3 2 102 2 3 1 103 3 1 2 ... View more

How is it possible to determine the number of estrous cycles in dogs when the occurrence of the cycle is given. For instance, when the determinants of the cycle is given by DI,PR,ES,ME,S,P where DI=diestrus,PR=Proestrus,ES=estrus,ME=metestrus,S=sperm,P=plug. The occurrence of estrus is only that matters and the cycle is given by EST DI DI DI MET EST -- here the length of the cycle is 5 until the occurrence of next estrus. A cycle is calculated from one estrus to another estrus. The length of the cycle is the period until next estrus occurs which is 5 in the above case. How do I write a code to calculate this in Statistics. The endpoint is to calculate the number of cycles and length of each cycle. The output has to look like this: animal_id cycle1 cycle2 cycle3 101 5 3 2 102 2 3 1 103 3 1 2 ... View more