I am quite new to Sgplot... and wondering why I get "vertical lines" instead of 8 series lines.
/* Import NYC Taxi and Limosine Trip Data */
PROC IMPORT OUT= SASUSER.NYCTaxis
DATAFILE= "C:\Users\Michael King\Desktop\GMU Presentation\Taxi Data from NYC Taxi Commission.xlsx"
DBMS=EXCEL REPLACE;
RANGE="Data1$";
GETNAMES=YES;
MIXED=NO;
SCANTEXT=YES;
USEDATE=YES;
SCANTIME=YES;
RUN;
/* View the data */
Proc Print Data=SASUser.NYCTaxis;
Run;
/* Display scatter plots */
ODS Graphics / ANTIALIASMAX=60000;
Title 'Plot of Trips by Car Type';
PROC Sgplot Data=SASUser.Nyctaxis;
Series x=Date y=Trips / Group = CarType grouplc=CarType name='grouping';
Xaxis Label = 'Date';
yaxis label = 'Trips';
Run;
... View more