I want to make hyperlinks in Excel -- so that the user would open the spreadsheet and see some cells with (familiar) blue, underlined text which are hyperlinks to a URL HREF  (http://...).  One click on the <text> to the link, and the web browser opens up.   I created a column in a dataset where the char content is '=HYPERLINK("<link>","<text>")'.   If Excel sees '=HYPERLINK(...)' then it should create the link, right?     I started with proc export dbms=xlsx, but when I opened the xlsx file in Excel app, it would show the "=HYPERLINK(...)" text and not the (blue) hyperlink <text> with the link "hidden".   That is, the cell is not a hyperlink.   However, if they "edit" that cell, change nothing, and resubmit the exact text, then Excel will "recognize" the =HYPERLINK() function and convert the cell to the (blue) hyperlink <text> (as desired) .     Then I read up on ods excel with the options(flow='tables').  So I tried that.  Now it gets interesting.  For "long" <links> (as in string length # chars), the Excel app shows the '=HYPERTEXT(...)' text, i.e. the cell is not a hyperlink.    But if the links are all "short" (as in < 50 chars in length) then the cell IS a hyperlink and a nice short "click here" text shows up blue and clickable (what I want).    There seems to be going on with the string length of the <link> -- but options(flow='tables') didn't 100% solve it.    Example code attached.    Excel:  Office 2019 SAS Current version: 9.04.01M6   ... View more

I've recently moved to the SAS/EG environment to submit my SAS jobs.   I'd like save my proc gplots (SAS/Graph) to a named GIF (or JPEG) filename in a specific local directory so I can use them later in a custom web app.   I cannot figure out how to do this.  proc gplot in SAS/EG seems to ignore gsfname=.   I think it's because it's wrapped in ODS.   Should I switch to proc sgplot and use ODS (I'm not familiar with this method)? Or is there a way in SAS/EG to use SAS/Graph and redirect the output to a named gif filename? Thanks, Steve       * this doesn not make gif chart at the named filename; filename graphout "&dir0\brs_m29.gif"; goptions gsfname=graphout gsfmode=replace device=gif; proc gplot data=freq03;   plot percent * yq = finalrating / grid ;   run;   quit;   ... View more

I have a string col that I want to use as a key to join with an integer col in another table.  The join is actually on a substring of the string.  Can I do that in 1 query, or do I have to split it up some and “re-cast” the string? In the sql join below, a.int_id is an integer which needs to match with the substring in b.string_id.  (Yes, that appears to be my only option for joining!  These are 2 different systems and they are not modeled well, apparently.) I'm trying to re-cast that sub-string into an integer and can't figure it out.  I'm connecting to an Oracle v11 database.       create table myjoin as select * from schema1.table1 a inner join schema2.table2 b on a.int_id = substr(b.string_id,5) ; quit; I think I want to re-cast right in the join.  But maybe not.  Maybe it's better to do some sort of nested query where I re-cast the substring in the select and then join to the integer. ... View more