Yes, it's one of the macro vars EG makes.  I tend not to use them.  I would use  "%sysfunc(pathname(work))" for portability.  But students might find &sasworklocation easier. ... View more

Thanks @PaigeMiller, you are correct.  Works on linux too.  I was blindly following the log, which doesn't write a note about creating the .png file.  But when I looked in the directory, there were about 50 png files waiting form me from all my "failed" attempts.   You can do stuff like: ods HTML path=&sasworklocation gpath='~'; proc sgplot data=sashelp.class; scatter x=height y=weight; run; proc sgplot data=sashelp.class; vbar age/response=height; run; ods html close;   ... View more

I found this blog post by @ChrisHemedinger : https://blogs.sas.com/content/sasdummy/2015/11/23/ods-statement-options-to-change/   For a minute I thought again that I could do it with: ODS HTML5 (ID=EGHTML) gpath="~"; ods graphics on / imagefmt=png imagename="MyGraph" ; proc sgplot data=sashelp.class; scatter x=height y=weight; run; But it looks like you are not able to change the value for gpath after opening a destination, as he notes in the blog for the path option.  Maybe Chris will have another idea.   I also tried forcing the issue by closing and reopening just the HTML5 destination, but still couldn't make it work: ODS _ALL_ CLOSE; ODS HTML5 FILE="%sysfunc(pathname(work))/foo.htm" GPATH="~" ; ods graphics on / imagefmt=png imagename="MyGraph" ; proc sgplot data=sashelp.class; scatter x=height y=weight; run; ods _all_ close ; which I find confusing.   ... View more

How odd.  I tried over-riding GPATH for the ODS HTML5 statement generated by EG, but had no luck.  Maybe I'm doing something dumb?  Seems like it should be easy.     7 FILENAME EGHTML TEMP; 18 ODS HTML5(ID=EGHTML) FILE=EGHTML 19 OPTIONS(BITMAP_MODE='INLINE') 20 %HTML5AccessibleGraphSupported 21 ENCODING='utf-8' 22 STYLE=HTMLBlue 23 NOGTITLE 24 NOGFOOTNOTE 25 GPATH=&sasworklocation 26 ; NOTE: Writing HTML5(EGHTML) Body file: EGHTML 27 28 *add gpath ; 29 ods HTML5(ID=EGHTML) gpath="~"; 30 31 ods graphics on / imagefmt=png imagename="MyGraph" ; 32 33 proc sgplot data=sashelp.class; 34 scatter x=height y=weight; 35 run; NOTE: PROCEDURE SGPLOT used (Total process time): real time 0.09 seconds cpu time 0.04 seconds NOTE: There were 19 observations read from the data set SASHELP.CLASS. Code runs without errors, but no .png file created.     Like you said, if I add ODS listing statement, it works fine:  29 ods listing gpath="~"; 30 31 ods graphics on / imagefmt=png imagename="MyGraph" ; 32 33 proc sgplot data=sashelp.class; 34 scatter x=height y=weight; 35 run; NOTE: PROCEDURE SGPLOT used (Total process time): real time 0.13 seconds cpu time 0.06 seconds NOTE: Listing image output written to /home/Quentin/MyGraph9.png. NOTE: There were 19 observations read from the data set SASHELP.CLASS. ... View more

That's interesting.  I think most of the modern SAS IDEs (e.g. EG, studio, etc) pretty much assume that you have one destination turned on (typically HTML).  So I don't think a user would have to turn on the listing destination just to get a png file or whatever.  Wouldn't they just code something like:   ods html gpath="Q:\junk"; ods graphics on / imagefmt=png imagename="MyGraph" ; proc sgplot data=sashelp.class; scatter x=height y=weight; run; ?   But I can see how to a student, having ODS graphics destination (with options for PNG/JPG/SVG etc) might be a more obvious implementation.   With the current code, I think the easier change might be to add an imagepath option to the ODS GRAPHICS statement.   The good thing is with AI code assistants, students should be much faster at figuring how to do something in SAS. Much faster than reading through paper manuals or posting on SAS-L, back in my day, walking up a hill in the snow both ways to get to school...   ... View more

Thanks Allan, love it.     This shows how much younger you are than me.  You think of Super Mario Brothers, I would think of doing Donkey Kong or Lode Runner.   Maybe you should post an index to all the SAS games available.  I know you've made a few.  I remember @ChrisHemedinger created a SAS version of Wordle, and in the comments of his blog post https://blogs.sas.com/content/sasdummy/2022/03/17/wordle-sas/ mentioned that someone had created a SAS version of Castle Wolfenstein!  I wonder if anyone ever tried to build a SAS chess engine...     ... View more

TBH, this is probably unrealistic but I'm not sure I want police using AI for criminal investigations at all.  I'm a data person, and love AI/ML, but the more I learn about Flock cameras etc the idea of predictive policing is pretty scary to me.   I won't put my tinfoil hat all the way on, but for anyone interested, Flock cameras are automated license plate recognition (ALPR) cameras, leased by cities and states from a private company.  Some home owners' associations and private companies lease them as well.  The cameras take an image of every car that passes by, use AI to read the license plate as well as bumper stickers and other identifying characteristics, and store the license plate, image, and other metadata in a national database searchable by local, state, and federal law enforcement, including ICE.  No warrant required for a search.  It's literal big brother government surveillance, storing data on the movements of every car in America.    If you want to learn more, see deflock.org.   Sorry for speaking too close to politics for a SAS forum, but I think it's on-topic for this sort of ethical AI question.  I'm not sure any police use of AI is ethical.  Certainly using AI for mass surveillance is not ethical. ... View more

Thanks for this!  I was just on LinkedIn this week, asking a SAS friend basically "what's a skill, how do I use it?"  This is very timely introduction for me. ... View more

Thanks @Chevell_sas I knew you'd come through for me.  : )   But still, it feels somewhat bug-ish to me.  Without adding the tagattr (which is of course always a good thing to do when writing to Excel), PROC REPORT or ODS EXCEL destination is writing a numeric value to the xml file with lots of trailing blanks.  Excel has no problem reading the file and showing the data.   Then the same file that works for Excel, is mis-read by the XLSX engine, because the XLSX engine is confused somehow by the Excel / XML file that has a bunch of trailing blanks in the numeric field.   So in my mind, likely it's a bug in the XLSX engine which can't properly read data from a numeric field which 200 trailing blanks, even though it is allowed by Excel.   Or could be a bug in PROC REPORT or ODS EXCEL, if it is not allowed by the XLSX/openXML spec to create this kind of kind of numeric field with 200 trailing blanks. ... View more

I'm sure it will be a terrific meeting.  Wonderful to see PhilaSUG is back, and NJSUG has grown so quickly!  I'm sure this will also help spread the word that SEASUG will be just outside Philadelphia this year!  https://sesug.org/SEASUG2026/index.php  Great things happening in the SAS Philly world! ... View more

That's interesting, I didn't realize SO had come around after being so anti-AI.  I'm surprised they even decided to make an MCP server to provide an AI interface.  I would have assumed OpenAI, Anthropic et al had already hoovered up everything from stackoverflow and used it in their training. I guess an MCP server does make it easy for a company to make a chatbot that looks only at SO, or only at approved tags from SO, or whatever. ... View more

Just for fun, I looked at the Stack Overflow SAS volume over time:   https://data.stackexchange.com/stackoverflow/query/1956163   Quentin_0-1786971460260.png   ... View more

I've worked on a handful of linux servers, and I don't think I've ever seen ACLs implemented.  Does that mean I've had bad admins?  Or as a user should I be adding ACLs myself? ... View more

Glad you got a workaround working.  Suggest you mark your workaround answer as the accepted solution.  Then if tech support comes back with more details, you can always update it later. ... View more

AI suggests CDE is typically running in a container, so you may need to set the umask when you start the container.  You might want to have a chat with your favorite AI and describe your CDE / Viya setup, and/or call tech support and ask how to set the umask. ... View more