topic Re: about dates in SAS Visual Analytics

about dates

SilinBorro — Tue, 27 Jan 2015 17:22:10 GMT

Hi,

I 'm building a report in Visual Analytics ,

I´ve imported an excel sheet , mi date fields are in SAS format , numbers, hoy do I show them in a line graphic as DDMMYY?

thanks in advance

Silvia

Re: about dates

PeterWijers — Tue, 27 Jan 2015 19:01:16 GMT

Hi Silvia,

there are several grafics with time axis where you can use dates as x-axis.

the dates should be imported and accepted as a date format. You can set the display format yourselves.

if not, there is something wrong with the field that represents your dates.

i am not sure if you need a sample here.

greetings and success.

Peter.

Re: about dates

MichelleHomes — Wed, 28 Jan 2015 02:08:29 GMT

Hi Silvia,

When you import the data into SAS Visual Analytics, the data item will be regarded as a date if it is a date category classification. Does it have a calendar with a time icon in front of it? If so, you can select it and then change the format from the data property panel in the data pane in the left pane. As per the screen shot.

Then you can use them in a line chart as explains.

If you could provide a sample or screenshot of your data that would help the community to get a better understanding of your question.

Kind Regards,

Michelle

Re: about dates

SilinBorro — Wed, 28 Jan 2015 11:17:27 GMT

Hi,

When I import my excel sheet the date fields appear with an $ format not as dates. You´ll see it in the image ( e.g. " Fecha . 1ra respuesta) I tried to change them into date format but I couldn´t. I tried creating a calculated item as well but the expression was not correct. Any suggestion????

Thanks a lot!!!

Silvia

Re: about dates

MichelleHomes — Wed, 28 Jan 2015 12:45:22 GMT

Is it possible for you to share a sample of your excel data? Is the column formatted with an Excel date format? It seems that the column may be a character column in Excel and that is why it is treated as a Category classification with a $ format when you import it into SAS VA.

Re: about dates

SilinBorro — Wed, 28 Jan 2015 14:13:46 GMT

Thnaks!

Re: about dates

SilinBorro — Wed, 28 Jan 2015 14:35:26 GMT

I capture the definition in Excel for one of the columns of date

Re: about dates

RDHamm — Wed, 28 Jan 2015 15:54:07 GMT

Hi.

I have had this happen to me as well.

Check your empty cells in Excel (I saw one on one of your screenshots) Make sure there is nothing in those cells by the =len() function.

If there is any text at all in those columns, they will come in as non-Date fields.

You may need to check, or delete the rows at the bottom of the spreadhseet too.

Best of luck.

Re: about dates

SilinBorro — Wed, 28 Jan 2015 16:33:56 GMT

I´ll check it

thanks!!!!

Re: about dates

SilinBorro — Wed, 28 Jan 2015 16:54:48 GMT

HI,

I chequed it but there ´s no spaces in the field, just the date. SAS detects these fields as dates because converts them into SAS format. but then the properties show $.

but I think the same that you that its because of Excel, buy I don´t get it.

I´ll go on searching

thanks!

Re: about dates

SilinBorro — Wed, 28 Jan 2015 17:17:10 GMT

Investigating Excel I realized that the field has got the date format,

but Excel converts it into a serie number, and what I thought was the SAS format in Analytics is the number assigned by Excel. not the date in SAS format.

what a mess!

Re: about dates

RDHamm — Wed, 28 Jan 2015 17:46:42 GMT

Attached is an image of an Excel file that I have uploaded numerous times. This works for me. I use the Date format in Excel. I don't have any missing dates, and each date column is formatted as Date except for the first row where the field names are.

I have had issues in the past, and it has always been because of text formatted date fields or spaces (or dots) where there should be nothing.

Re: about dates

SilinBorro — Thu, 29 Jan 2015 17:38:25 GMT

Hi RDHamn,

I reviewed my excel sheet (generated by a sas program from an oracle table ) and I realized that whenever I hadn´t a date , there vas a dot (SAS symbol for missing) and that is why VA considered it alpha.

Thanks a lot to those who has helped me with this!!!!1

Re: about dates

MichelleHomes — Fri, 30 Jan 2015 03:00:13 GMT

Great to hear Silvia!

Please mark the question as answered so that future members who come across this know it has been resolved.

Kind Regards,

Michelle

Re: about dates

KarunaT — Thu, 25 May 2017 09:17:20 GMT

To convert a character date into Date format, you can use the following:

In the Report designer, create a 'New Calculated Item' and use the Parse operator(under simple text).

For example, Parse('Joining_date', 'DATE9.') returns a date value where 'Joining_date' is my Date column name and 'DATE9.' is the date format.