SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

import from excel

Reply
N/A
Posts: 0

import from excel

hi all,
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.


stdt enddt CMWPNT treat_day subjid qtcb EGDT ecgtime qtcf
24NOV2008 PANTOPRAZOLE -104 1001001
05DEC2008 ANOVLAR -93 1001001
26JAN2009 02APR2009 LEVOFLOXACIN -41 1001001
02FEB2009 19FEB2009 SALVIA OFFICINALIS -34 1001001
09FEB2009 02APR2009 ITRACONAZOLE -27 1001001
18FEB2009 18FEB2009 DIPHENHYDRAMINE HYDROCHLORIDE -18 1001001
23FEB2009 28FEB2009 SALVIA OFFICINALIS -13 1001001
24FEB2009 PARACETAMOL -12 1001001 2/24/2009 11:08 410.23
24FEB2009 PARACETAMOL -12 1001001 2/24/2009 11:09 413.6
24FEB2009 PARACETAMOL -12 1001001 449 2/24/2009 11:11 412.6
1001001 3/2/2009 07:35 428.55
1001001 3/2/2009 07:37 423.86
Esteemed Advisor
Posts: 5,081

Re: import from excel

When pasting this into Excel, and do "Text to columns", there is no column with a uniform data type.
Do you want to import all this as text only?
You might want to look at the IMPORT option MIXED=YES and the TypeGuessRows Excel registry in Windows.

/Linus
Data never sleeps
Post a Question
Discussion Stats
  • 1 reply
  • 179 views
  • 0 likes
  • 2 in conversation