About Aiman

IT · ‎08-31-2020

I have received support from SAS and to resolve the issue You have to increase the XMX microrservice sas-dmtransformservices and SAS-DataStudio. Alvaro

PriyaSharma · ‎06-16-2020

Hi Aimen, The source window expects schema of input table. You can click on the edit icon >> 'New field' to add the name and type of data fields. Or you can also import it as XML or schema string. See link this link for repository of ESP tutorials and code snippets. More details are available in the documentation. Thanks, Priya

Aiman · ‎05-07-2020

Thank you Tom!! It was Month Date Year format , (Jan16 2020). By the way, I managed to convert it to datetime and date format by running your code. I'm new in SAS Programming to be honest, I didn't know that I cannot convert the existing character variable with the same name, but I learnt it from you. Thank you for that. Do you mind to explain a bit your line code "scan(date_string,1,' ')", what "1" representing for? the rest of the code I could understand it. Thank you!!

AhmedAl_Attar · ‎05-04-2020

Try using the xlsx libname engine instead /* because Excel field names often have spaces */ options validvarname=any; libname xl XLSX "/folders/myfolders/raw input data.xlsx"; *<--- Change the path; /* discover member (DATA) names */ proc datasets lib=xl; quit; /* read in one of the tables */ data work.import; set xl.<Sheet Name>; *<--- Change the SHEET Name; run; libname xl CLEAR; Hope this helps, Ahmed

Aiman · ‎04-24-2020

Hi I encounter the same issues as yours, have you solve it? Mind to share on how you tackle the issue. Thank you

Kurt_Bremser · ‎04-24-2020

Please post a few lines of the file, using the </> button. Do NOT open the file with Excel, use a text editor and copy/paste the text.

Online Status	Offline
Date Last Visited	‎07-20-2020 02:56 AM

Error in converting Column in Data Studio

SAS ESP

Re: Import CSV to CAS via the web interface does not detect dates

Re: Import CSV to CAS via the web interface does not detect dates

DBMS TYPE XLSX not valid for import

Re: Import CSV to CAS via the web interface does not detect dates

Import CSV to CAS via the web interface does not detect dates

Re: Import CSV to CAS via the web interface does not detect dates

Re: The data specification could not be created

The data specification could not be created

Re: Import CSV to CAS via the web interface does not detect dates

Re: Import CSV to CAS via the web interface does not detect dates

Import CSV to CAS via the web interface does not detect dates

SAS Virtual Lab

Re: Error in converting Column in Data Studio

Re: SAS ESP

Re: Import CSV to CAS via the web interface does not detect dates

Re: DBMS TYPE XLSX not valid for import

Re: Import CSV to CAS via the web interface does not detect dates

Re: The data specification could not be created