Kevin D Smith

For something like this, you'll have to use the append_computed_columns method of CASTable. It allows you to specify whatever code you want and the variables that get exported. In your...

SWAT probably should have made character columns like this be varchars instead of fixed with character columns.

That might not be in the doc, now that you mention it. It was used as an internal-only method for a while, but then was made public later. As far...

There are some differences between the REST interface and the binary interface in CAS that prevented all of the extended data types from working, so some were normalized to strings....

I remembered working on a related issue recently (7eeac93332c5ed50c12004f1cc1f8fcb06f7b898). I forgot that you need to specify `date_format` on `read_excel` to match the informat specified in `importoptions`. However, that change hasn't...

The `date_format` is passed to the `to_csv` method of the underlying pandas `DataFrame`, so it uses Python's date formats (see https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.to_csv.html). If you are going for MMDDYY, then the Python...

You are missing the `vars=` level: `importoptions={'vars': {'Date': 'datetime'}}`.

I believe this is what you want. ``` importoptions={'vars':{'Date':{'informat': 'datetime', 'type':'datetime'}, 'Cost':{'type':'varchar'}}} ```

@JoannaNawalanySAS It doesn't appear to be working the way that I remember. However, there is a workaround for now. You can do this in two steps. First, read the excel...

Can you elaborate on what the exact issue is with an example?