topic Re: import from excel in Microsoft Integration with SAS https://communities.sas.com/t5/Microsoft-Integration-with-SAS/import-from-excel/m-p/66990#M903 When pasting this into Excel, and do "Text to columns", there is no column with a uniform data type.<BR /> Do you want to import all this as text only?<BR /> You might want to look at the IMPORT option MIXED=YES and the TypeGuessRows Excel registry in Windows.<BR /> <BR /> /Linus Mon, 31 Jan 2011 17:10:23 GMT LinusH 2011-01-31T17:10:23Z import from excel https://communities.sas.com/t5/Microsoft-Integration-with-SAS/import-from-excel/m-p/66989#M902 hi all,<BR /> How can I import this data from excel to SAS. But problem here is that qtcb variable is coming as blank data. plz copy the data in excel and import.<BR /> <BR /> <BR /> stdt enddt CMWPNT treat_day subjid qtcb EGDT ecgtime qtcf<BR /> 24NOV2008 PANTOPRAZOLE -104 1001001 <BR /> 05DEC2008 ANOVLAR -93 1001001 <BR /> 26JAN2009 02APR2009 LEVOFLOXACIN -41 1001001 <BR /> 02FEB2009 19FEB2009 SALVIA OFFICINALIS -34 1001001 <BR /> 09FEB2009 02APR2009 ITRACONAZOLE -27 1001001 <BR /> 18FEB2009 18FEB2009 DIPHENHYDRAMINE HYDROCHLORIDE -18 1001001 <BR /> 23FEB2009 28FEB2009 SALVIA OFFICINALIS -13 1001001 <BR /> 24FEB2009 PARACETAMOL -12 1001001 2/24/2009 11:08 410.23<BR /> 24FEB2009 PARACETAMOL -12 1001001 2/24/2009 11:09 413.6<BR /> 24FEB2009 PARACETAMOL -12 1001001 449 2/24/2009 11:11 412.6<BR /> 1001001 3/2/2009 07:35 428.55<BR /> 1001001 3/2/2009 07:37 423.86 Sat, 29 Jan 2011 06:38:59 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/import-from-excel/m-p/66989#M902 deleted_user 2011-01-29T06:38:59Z Re: import from excel https://communities.sas.com/t5/Microsoft-Integration-with-SAS/import-from-excel/m-p/66990#M903 When pasting this into Excel, and do "Text to columns", there is no column with a uniform data type.<BR /> Do you want to import all this as text only?<BR /> You might want to look at the IMPORT option MIXED=YES and the TypeGuessRows Excel registry in Windows.<BR /> <BR /> /Linus Mon, 31 Jan 2011 17:10:23 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/import-from-excel/m-p/66990#M903 LinusH 2011-01-31T17:10:23Z