Not sure how complex macro code makes things readable, but you can certainly use %NRSTR() to protect & characters.  You just need to remember not to unquote them before you can protect them with actual quotes.   You can use the actual QUOTE() function to add single quotes around the string. 63 %let file1="%sysget(USERPROFILE)\Desktop\%nrstr(S&P) 500_%sysfunc(today(),yymmddn6).xlsx"; 64 %let file2="%nrstr(S&P) 500_%sysfunc(putn(%sysfunc(today())+1,yymmddn6.)).xlsx"; 65 66 data _null_; 67 infile %sysfunc(quote(ren &file1 &file2,%str(%'))) pipe; 68 input; 69 put _infile_; 70 run; NOTE: The infile 'ren "C:\Users\xxx\Desktop\S&P 500_230329.xlsx" "S&P 500_230330.xlsx"' is: Unnamed Pipe Access Device, PROCESS=ren "C:\Users\xxx\Desktop\S&P 500_230329.xlsx" "S&P 500_230330.xlsx", RECFM=V,LRECL=32767 Stderr output: The system cannot find the file specified. NOTE: 0 records were read from the infile 'ren "C:\Users\xxx\Desktop\S&P 500_230329.xlsx" "S&P 500_230330.xlsx"'. NOTE: DATA statement used (Total process time): real time 0.07 seconds cpu time 0.00 seconds Or if you know that the string does not contain any single quotes you can use %BQUOTE() to get the single quotes, but you will need to use %unquote() to remove the macro quoting so that SAS can see that you actually passed a quoted string to the INFILE statement. data _null_; infile %unquote(%bquote('ren &file1 &file2')) pipe; input; put _infile_; run;     ... View more

SG procs do not provide arrows on axes. But you could use SG annotation to achieve this:   data have; call streaminit(86585); do x=1 to 10; y+rannor(1); output; end; run; data annoset; function = "ARROW"; shape = "FILLED"; drawspace = "WALLPERCENT"; y1 = 0; y2 = 0; x1 = 0; x2 = 100; output; function = "ARROW"; shape = "FILLED"; drawspace = "WALLPERCENT"; y1 = 0; y2 = 100; x1 = 0; x2 = 0; output; run; proc sgplot data=have noautolegend sganno=annoset; series x=x y=y/ARROWHEADPOS=both ARROWHEADSHAPE=filled ; run;   ... View more

/* I like this picture. */ data have; call streaminit(123); do year=1926 to 2022; return=rand('normal'); output; end; run; proc sql; create table have2 as select year,(return-min(return))/(range(return)+0.5)-0.4 as return from have; quit; data have3; set have2; x=round(100*return,10)-5; run; proc sort data=have3 out=have4; by x year; run; data have5; set have4; by x; if first.x then y=0; y+1; run; proc sgplot data=have5; scatter x=x y=y/markerchar=year markercharattrs=(size=10 ) labelstrip; xaxis values=(-90 to 90 by 10) min=-90 max=90 valueshint; yaxis display=none offsetmin=0 offsetmax=0.1 min=1.6 valueshint; run;   ... View more

Hello @Junyong,   First of all, thank you very much for providing readily usable example data and code.   I think adding this XAXIS statement to your PROC SGPLOT step will help: xaxis values=(5 to 50 by 5) type=linear valueshint; The default axis type in your case would be DISCRETE, not LINEAR, so that the VALUES= specification alone would also restrict the set of bars drawn. Without the VALUESHINT option SAS would not leave enough space for the bars with X values less than the first tick mark value (5). ... View more