Dear SAS EG users,
I met a trouble last week and cannot figure it out. The problem is that the output of SAS program looks good, but the visizulation (bar graph, the frequency of a column named READ_DT) of result obveriously wrong. I had two tables, both of them had a column named READ_DT. Both cloumn shared the same format and informat, ie date9.. To my surprise, the frequency distribution of one table looks correct (Bar chart 2), but not the another one (Bar Chart 5). I don't know why and how to solve it. For deails please see attachments.
Thanks,
Harry
Run something like this:
Proc freq data=barchart5dataset;
freq read_dt;
format read_dt best12.;
run;
I will bet that your data source has an issue, either it is including some time values or simple data entry errors.
And where did you read the data from?
Thanks ChrisHemedinger a lot for your quick message. I selected two files and unfortunately, only one of them attached. Here is Bar Chart #2.
Sorry for my careless.
Best,
Harry
Hi ,
can you please explain what portion is wrong ? the date format in the pdf (which is not very clear). Or the Graph itself the Bounds?
Run something like this:
Proc freq data=barchart5dataset;
freq read_dt;
format read_dt best12.;
run;
I will bet that your data source has an issue, either it is including some time values or simple data entry errors.
And where did you read the data from?
Hi Ballardw,
I think you are right that my data source has an issue. The data source is from Teradata warehouse, which showed some wired data when I extracted raw data directly from database.
Thanks you and others for helpful information and suggestion.
Best regards,
Harry
You might still be able to work with this data using a DT format instead of DATE9.
See this blog post for ideas:
http://blogs.sas.com/content/sasdummy/2011/11/15/do-you-mind-if-we-dance-with-your-dates/
Chris
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.