BookmarkSubscribeRSS Feed
deleted_user
Not applicable
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
1 REPLY 1
LinusH
Tourmaline | Level 20
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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Discussion stats
  • 1 reply
  • 883 views
  • 0 likes
  • 2 in conversation