Import CSV file with SAS Studio

Reply
N/A
Posts: 1

Import CSV file with SAS Studio

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!

Attachment
Valued Guide
Posts: 3,206

Re: Import CSV file with SAS Studio

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

---->-- ja karman --<-----
Esteemed Advisor
Posts: 6,698

Re: Import CSV file with SAS Studio

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

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
SAS Employee
Posts: 967

Re: Import CSV file with SAS Studio

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;

Ask a Question
Discussion stats
  • 3 replies
  • 1092 views
  • 0 likes
  • 4 in conversation