JoannaNawalanySAS

Thank you for your answer. I've tried your tips, but still I'm struggling with the problem. As the action conn.builtins.history() shows importOptions I assume I have enough new version of...

I've copied the file you've mentioned to my server, but I'm note sure where exactly put those options. Is the code below correct? storm_damage = conn.read_excel("D:\Workshop\VIYAPY\storm.xlsx", sheet_name="Storm_Damage", casout=dict(name="STORM_DAMAGE", replace=True, caslib="Public"),...

How do I use the importoptions option in read_excel? It seems not working at all, even for string types, not only for dates. Do I have it set correctly here:...

I've tried this (including specyfing cost as varchar to see if it is a problem with date values or maby with other types too): storm_damage = conn.read_excel("D:\Workshop\VIYAPY\storm.xlsx", sheet_name="Storm_Damage", casout=dict(name="STORM_DAMAGE", replace=True,...

This is not working eather (I've inserted you sugestion and andded "date_format") :( ``` storm_damage = conn.read_excel("D:\Workshop\VIYAPY\storm.xlsx", sheet_name="Storm_Damage", casout=dict(name="STORM_DAMAGE", replace=True, caslib="Public"), importoptions={'vars':{'Date':{'informat': 'datetime', 'type':'datetime', 'date_format':'%m/%d/%Y.'}, 'Cost':{'type':'varchar'}}}) storm_damage.dtypes ``` This is...

Thank you, I didn't thought about it as almost equally resources consuming solution. Importing to DataFrame and then uploading to CAS works fine! Just one think: ERROR: Parameter 'date_format' is...