topic Re: Why are my dates showing up as asterisks? in SAS Programming

Why are my dates showing up as asterisks?

confused_saser — Tue, 24 Jan 2017 23:32:40 GMT

I have had to import a number of csv files an di have successful appended all of them. Before being able to append them I had to convert all my date variables into SAS date variables (format DATE9.).

I thought all was good until I exported my appended dataset and discovered that all my date variables are showing up as asterisks. However, when I open up the viewtable in SAS I can still see values there (e.g., 20160131)

Why are all my values showing up as asterisks when I export as an excel or csv? And why are they showing up semi-normally in the SAS viewtable?

What do I need to do to have the dates work properly so that I can run analyses on them?

thanks!

Re: Why are my dates showing up as asterisks?

Reeza — Tue, 24 Jan 2017 23:38:21 GMT

Make sure that you're viewing the CSV in a text editor to verify if the issue is with the SAS Export or Excel interpretation of the file

You don't say how you exported the file, but they usually show up as asterisks when the width isn't wide enough to hold the value. If you're looking at the data in excel they'll show up as hashtags if the column isn't wide enough as well.

Re: Why are my dates showing up as asterisks?

ballardw — Thu, 26 Jan 2017 15:52:02 GMT

I will be a large number of $$ that your value is a numeric with the value of 20160131 which is not a DATE value.

Please see this code snippet on how to make such a number into a date.

data _null_;
   x=20160131;
   x = input(put(x,f8.0),yymmdd8.);

   put x mmddyy10.;
run;

Re: Why are my dates showing up as asterisks?

confused_saser — Wed, 25 Jan 2017 16:06:11 GMT

I have a way easier way of solving this problem!

Before I imported all my csv files I converted all my date variables into EXCEL DATES FIRST using the text to column function in excel.

This solved EVERYTHING!

Re: Why are my dates showing up as asterisks?

ballardw — Thu, 26 Jan 2017 15:56:49 GMT

If the file was orginally CSV and you edit it with Excel you want to go over the results with a fine tooth comb to make sure the correct date conversion was applied.

Also Excel is known to change some types of character values to numerics under some circumstances. So account or product "numbers" that look like 45-123 end up with "values" of -78 or 1-5 comes a "date" of May 1 in the current year.

Re: Why are my dates showing up as asterisks?

Peter_C — Thu, 26 Jan 2017 22:41:39 GMT

A date column presenting with asterisks is not missing - it is outside the valid numeric range for a SAS date (something like 1Jan1582 to 31Dec20000)
One way this happens: a datetime value is formatted as a date - some SAS ACCESS routines can cause this.

Re: Why are my dates showing up as asterisks?

NeerajS1104 — Mon, 26 Feb 2018 18:09:11 GMT

Superb code .

I was stuck since two days due to this issue.

Should have come to this answer earlier .

Thanks a lot .

Made my day.

Good day wishes.