Hello,
I am currently trying to import a csv file into SAS Studio but am encountering formatting issues with the date field. Specifically I am trying to plot a time series but the program is not interpreting code as intended with the following error message:
WARNING: The bottom horizontal axis labeled "Time" could not be fit as specified. The axis values will overwrite.
Provided below is my code:
data wine;
infile '/ location /wine.csv' dlm=',' firstobs=2;
input Time $ Sales;
run;
proc print data= wine;
run;
proc gplot data=wine;
title "Time Series Plot of the Australian Wine Sales dataset";
plot Sales*time;
symbol1 i=join;
run;
Please note I substituted 'location' for my personal location information for purposes of this discussion. I have also attached the data set as well. Thank you!
finding the informats is what you want? SAS(R) 9.4 Formats and Informats: Reference (monyy)
The message tells you that the values for your x-axis are so many or so wide that adjacent values will overwrite each other, causing bad readability.
Reduce the number of values, or apply a format that renders less characters
By default, there are too many tickmarks on your x (horizontal) axis.
You could specify exactly which tickmarks you want in an axis statement 'order=',
or here's a quick hack to just get tickmark labels at the left & right (just 2 major tickmarks)...
axis1 major=(number=2) minor=none;
proc gplot data=wine;
title "Time Series Plot of the Australian Wine Sales dataset";
plot Sales*time / haxis=axis1;
symbol1 i=join;
run;
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!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.