Thanks, Chris! This is the clearest direction I've received thus far, even with looking on my own. One more question for you, then, if that's ok: not only do I need to give authentication, I also need to specify some criteria upon which to pull the data. Would I go through all these steps then copy and paste the URL that's in the browser into the "url" bit in PROC HTTP? I apologize if these questions seem a bit elementary! ... View more

I thought I had done my due diligence prior to posting this but apparently, I hadn't been thorough enough. I discovered that the option "g100" exists within gchart, but only if a group is specified (which makes perfect sense). My code now looks like the following & I can write a simpler macro for it now that I cut out proc freq as the middleman: proc gchart data=a.yc_final_2;   vbar q4 / discrete noframe   type=PCT inside=FREQ outside=PCT   width=&width gspace=&gspace   raxis=axis1 maxis=axis2 gaxis=axis3   patternID=group group=gender g100   legend; run; quit; (As a side note, I used a macro that tailors the bar widths and spaces in between them.) ... View more

The following will work with the given changes: PROC SQL; CONNECT TO EXCEL (PATH='c:\sasdemo\sasdemo.xlsx'); SELECT * FROM CONNECTION TO EXCEL   (SELECT * FROM [A_Sheet_Name_Longer_Than_Thirty_Two_Chars$]); DISCONNECT FROM EXCEL; QUIT; Also, for Names on third row, namerow and datarow options can be used in the same sql procedure in connect statement. For multiple sheets, macro can help. ... View more