%web_drop_table(WORK.IMPORT1); FILENAME REFFILE '/folders/myfolders/sasuser.v94/PROBLEM SET 2_DATA.xls'; ods listing ; ods html close ; ods graphics off ; PROC IMPORT DATAFILE=REFFILE DBMS=XLS OUT=WORK.IMPORT1; GETNAMES=YES; RUN; ods listing ; ods html close ; ods graphics off ; PROC CONTENTS DATA=WORK.IMPORT1; RUN; %web_open_table(WORK.IMPORT1); data import1; set work.import1 ; T = _n_ ; run ; ods listing ; ods html close ; ods graphics off; %macro PLOT(var1,data,time,title); goptions reset=global border cback=white htitle=1.5; symbol1 interpol=join value=dot height=0.5 color=red; *symbol2 interpol=join value=none height=0.5 color=blue; axis1 label=none; proc gplot data=&data; plot &var1*&time / haxis=axis1 vaxis=axis2 legend=legend1; title1 "&title" /*height=0.001 in*/; run; quit; %mend; %PLOT(Series_A,import1,T,"Plotting Series A") ; run ; ... View more