cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
chi0202
‎09-01-2015
  • 3 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Importing excel files with line breaks

by Calcite | Level 5 in SAS Programming
‎11-28-2013 10:28 AM
‎11-28-2013 10:28 AM
Hi Arthur, I'm running SAS 9.3 on Windows Server 2008. PS. using dbms=excel ... View more

Re: Importing excel files with line breaks

by Calcite | Level 5 in SAS Programming
‎11-22-2013 01:31 PM
‎11-22-2013 01:31 PM
Hi Arthur, Tried running your code, but the content in one cell still gets split into different variables in SAS. Thanks! ... View more

Importing excel files with line breaks

by Calcite | Level 5 in SAS Programming
‎11-21-2013 09:52 AM
‎11-21-2013 09:52 AM
Hi, I am trying to import an excel file into SAS using the proc import command. However, some texts in the excel file are truncated when imported into SAS (because some cells contain text that are very long). I tried to convert the excel file into .csv before importing into SAS, but because there are line breaks in the cells, each separate line is imported as a different variable in SAS. ex. the excel file looks like this: Case Comments 23 Positive IgG test. Negative IgM test. Patient hospitalized on Nov.12. Any solution to this? Thanks! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Quick links