06-04-2016 09:44 AM
I'm trying to insert data a named range in an .xlsx file with the following code:
libname MyXLSX PCFILES path="&SrcPath.\Alt_Rptg_Tree.xlsx" SCAN_TEXTSIZE=NO;
PROC SQL ;
INSERT INTO MyXLSX.Acct_Chkr
FROM PERM.REF_CE_TREE t1;
But, despite having the column attributes set to number in Excel (with Format Cells…), I get the following error:
ERROR: Value 4 on the SELECT clause does not match the data type of the corresponding column listed after the INSERT table name.
When I view the properties of MyXLSX.Acct_Chkr they are all defined as char with $255 format.
Is there any way either in SAS or Excel to force the columns to match the type in my data?
(Using SAS9.4 through EG7.1 with a Windows server.)
07-06-2016 08:10 AM
did you try the PCFILES libname options: MIXED=YES or MIXED_DATA=YES or MIXED_DATATYPE ?
i found this SUGI PDF a good guide to start.
hope this help
let me know
have a nice day