Simply import csv file with date format into sas visual analytics

[VictorM]

Dear all,

I'm connected to SAS VA 7.3 on the web interface, have opened the "data preparation" section and used the "File->Import" functionality with CSV.

Selecting my CSV file, I'm just setting the separator character and cliking on import.

It goes fine except I have 2 date fields which are not taken as date field but characters only in the report designer. this is painful.

I tried to save the csv as .xlsx file and import it, as one of the two date fields is correctly managed as a date column in excel ( the Date column), but it does not make a difference.

Any idea ?

thanks

Sample of the fields in CSV :

Start;Date

28 octobre 2015;20151028

29 octobre 2015;20151029

30 octobre 2015;20151030

etc...

[Kurt_Bremser]

Doesn't the "advanced" option allow you to set column atttributes? The Date field can be read with the yymmdd8. informat.

[VictorM]

Unfortunately not, it's only the location / directory of LASR tables & compression option.

[ballardw]

That's not a date, it is a datetime.

[VictorM]

ok but how can I change this field to a datetime then ?

I tried in data preparation to force it using a query but does not work either.

[VictorM · Accepted solution]

OK for those who are interested.... I solved the problem because on the thousands lines of data, only a few did not have a correct date in the column, but a N/A text instead.

I think this lead to SAS not understand the column as a date value...

PRoblem solved, thanks anyway.