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: 
MichelleBL
‎12-13-2016
  • 5 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Proc Import DBMS=XLSX Issue importing value from cell with formula

by Calcite | Level 5 in SAS Procedures
‎03-26-2015 12:14 PM
‎03-26-2015 12:14 PM
Thank you, I submitted a problem.  Hopefully they can figure it out. ... View more

Re: Proc Import DBMS=XLSX Issue importing value from cell with formula

by Calcite | Level 5 in SAS Procedures
‎03-26-2015 11:53 AM
‎03-26-2015 11:53 AM
If I put in the value and get rid of the formula it imports fine.  But I can't do this on every doc/every sheet I am bringing in. ... View more

Re: Proc Import DBMS=XLSX Issue importing value from cell with formula

by Calcite | Level 5 in SAS Procedures
‎03-26-2015 11:52 AM
‎03-26-2015 11:52 AM
No the value isn't, the formula is. ... View more

Re: Proc Import DBMS=XLSX Issue importing value from cell with formula

by Calcite | Level 5 in SAS Procedures
‎03-26-2015 11:50 AM
‎03-26-2015 11:50 AM
It is a character column.  It reads in the column headers and everything that does not have a formula.  It just seems to have an issue when there is a formula present in the cell. ... View more

Proc Import DBMS=XLSX Issue importing value from cell with formula

by Calcite | Level 5 in SAS Procedures
‎03-26-2015 11:38 AM
‎03-26-2015 11:38 AM
I am using the Proc Import to bring in an XLSX.  I have ran into a problem where if the cell has a formula in it, it will not import the cell value and instead only impor the value of "A" for that cell.  Does someone know how to fix this issue? Proc Import Datafile="&xlsx./L5 &filename..xlsx" Out=&s_name._&s_tab. REPLACE DBMS=xlsx; Sheet= "&tab."; Run; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎12-13-2016 05:38 PM
Quick links