topic Re: Simply import csv file with date format into sas visual analytics in SAS Visual Analytics

Simply import csv file with date format into sas visual analytics

VictorM — Wed, 13 Sep 2017 12:53:13 GMT

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...

Re: Simply import csv file with date format into sas visual analytics

Kurt_Bremser — Wed, 13 Sep 2017 13:17:54 GMT

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

Re: Simply import csv file with date format into sas visual analytics

VictorM — Wed, 13 Sep 2017 13:19:59 GMT

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

Re: Simply import csv file with date format into sas visual analytics

ballardw — Wed, 13 Sep 2017 14:54:22 GMT

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

Re: Simply import csv file with date format into sas visual analytics

VictorM — Wed, 13 Sep 2017 15:07:29 GMT

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.

Re: Simply import csv file with date format into sas visual analytics

VictorM — Thu, 14 Sep 2017 16:05:21 GMT

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.