topic Re: Import CSV file with SAS Studio in SAS Programming

Import CSV file with SAS Studio

msmyth — Sun, 16 Nov 2014 14:14:17 GMT

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!

Re: Import CSV file with SAS Studio

jakarman — Sun, 16 Nov 2014 17:02:24 GMT

finding the informats is what you want? SAS(R) 9.4 Formats and Informats: Reference (monyy)

Re: Import CSV file with SAS Studio

Kurt_Bremser — Mon, 17 Nov 2014 07:30:41 GMT

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

Re: Import CSV file with SAS Studio

GraphGuy — Tue, 20 Jan 2015 19:05:00 GMT

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;