I want to remove borders from an sgplot (vbar with group=) both on the bars and in the legend.       in GraphColors template styles, I tried 'gcdata1'=white   but it's not applying to the legend ! (the border of the legend marker is black   I tried applying the same color as 'gdata1' but that doesn't work either.   I also tried to use a transparent color Affffff00 but that's not working either (btw that produces a weird bug that makes all the rest of 'gcdata2', 'gcdata3', 4... unused and 'gcdata' is then used instead for all)   My current solution is to use   'gcdata1' = CXfefefe   which is ~ok for my needs    But that's such a strange behavior that I would like to understand.   ______________________________   The plot looks like this   proc sort data=sashelp.class; by sex; run;quit; proc sgplot data=sashelp.class;   vbar Age / group=Sex groupdisplay=cluster;   run;   and I'm viewing it in STP output (default ods, it creates PNG's inside an html page) ... View more

Hello,   I have a (huge) Stored process that can make lots of graphs depending on the parameters. These graphs are outputted in ods html PNG format + non-embedded titles & footers, + a few other proc prints in general.   Now  I need to make a version that outputs only 1 image, (the main png that is written in an img tag in the html output)   e.g. <img alt="The SGPlot Procedure" src="/SASStoredProcess/guest?_sessionid=3C3AC7BA-A50D-4BB7-8443-9DDB59150B04&_program=replay&_entry=APSWORK.TCAT0021.SGPlot.png" style=" height: 480px; width: 640px;" border="0" class="c"> /SASStoredProcess/guest?_sessionid=8E7E4609-4B45-4A95-8614-E6B4764FEC2E&_program=replay&_entry=APSWORK.TCAT0005.SGPlot.png /SASStoredProcess/guest?_sessionid=E21CFA30-10DC-4335-9540-601574329008&_program=replay&_entry=APSWORK.TCAT001A.SGPlot.png   What do you think would allow me to do that easily ?   I'm thinking adding a flag paramter to the STP and then add a rule at the end of the STP that replaces the output  I don't see anything else than an _webout  with just the img tag maybe ? , or just the png and changing the Content-type header ?     The idea would then to use it in an iframe  or retrieve the src url and inject in a proper img tag with ajax maybe (but then I would probably face Cross-Origin Read Blocking (CORB) errors)    Can I retrieve the _sessionid and the _entry that change every time the STP is called?     ... View more

  Hello, I'm getting this strange error when trying to scrape a website. I don't have any results when searching for this error on the web. It was working fine few weeks ago, my setup hasn't changed so that rules that out.   I guess they changed something in their page, but I can't pinpoint what exactly.   Since I don't have the hand on the source website, I'm searching an alternative solution to make it work.   I'm just collecting the list of XLS filenames in the list   %let fileListURL = https://www.inami.fgov.be/fr/professionnels/etablissements-services/laboratoires/Pages/historique-labos-agrees-prestations.aspx; filename listURL url "&fileListURL"; data INAMI_FILES; infile listURL length=len lrecl=32767; input line $varying32767. len; * filter all the lines with .xls; if find(line,".xls") then do; * this is a big line so we will split it into several lines with '<'; count = countw(line,'<'); do i=1 to count; tag = scan(line, i, '<'); * now filter again only those containing ".xls"; if find(tag,".xls") then do; * extract the url; file_url = scan(tag,2,'"'); * extract the id; file_id = scan( scan( file_url, -1, '_'), 1, '.' ); * extract the extension; file_ext = cats('.xl', scan( tranwrd( file_url, '.xl', '*' ), 2, '*' ) ); output; end; end; end; drop line count i tag ; run; filename listURL clear; ERROR: SSL error is "The message received was unexpected or badly formatted. (0x80090326).". NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.INAMI_FILES may be incomplete. When this step was stopped there were 0 observations and 3 variables. WARNING: Data set WORK.INAMI_FILES was not replaced because this step was stopped.     Any ideas? ... View more

Hello,   I'm trying to define my template styles and I cannot increase the table cells padding when output is "ODS tagsets.sasreport13". style Table / cellpadding = 50pt /* ONLY EFFECT HTML, PDF, RTF */ ;   This code can change the table cells padding but only when output is HTML, PDF and RTF. I have been trying with these too but they don't change anything paddingright = 50pt paddingtop = 50pt paddingright = 50pt paddingleft = 50pt padding = 50pt     HTML:         tagsets.sasreport13:   Using SAS 9.3 and Enterprise Guide 7.1 ... View more