About MartinMincey

MartinMincey · ‎11-19-2020

To reinforce an answer from yesterday, SAS is able to use TEMP as a default/pre-defined LIBREF due to the fact that with most installs of Windows, TEMP is defined as a Windows environment variable. One way to view all of the environment variables that are defined in Windows is to bring up your Windows control panel and then choose System, then Advanced System Settings, and then click the Advanced tab. In this window, click the button titled "Environment Variables" and then take a look at the environment variables defined under "User Variables". For most users, TEMP points to the following Windows directory: C:\Users\userid\AppData\Local\Temp Even though this appears to be a temporary location, note that any files and data sets written to TEMP by SAS will not be deleted from disk upon SAS termination. This is different than using the default SAS WORK location (where files and data sets written to work are deleted from disk upon normal SAS termination).

MartinMincey · ‎10-18-2018

Hello, I did have a typo in my last reply. If the graphs are named GRAF1 and GRAF2, the code should actually look similar to the following... title1; footnote1; proc report data=sashelp.cars; where make="Honda"; run; proc report data=sashelp.cars; where make="Audi"; run; title1 '<img src=cid:graf1>'; footnote1 '<img src=cid:graf2>'; proc report data=sashelp.cars; where make="BMW"; run;

MartinMincey · ‎10-18-2018

Hello, If your two graphs are named GRAF1 and GRAF2 on the ATTACH option on the FILENAME statement, you should be able to accomplish this by structuring your code similar to the following... title1; footnote1; proc report data=sashelp.cars; where make="Honda"; run; proc report data=sashelp.cars; where make="Audi"; run; title1 '<img src=cid:sgplot>'; footnote1 '<img src=cid:sgplot1>'; proc report data=sashelp.cars; where make="BMW"; run; Where the TITLE1 and FOOTNOTE1 statements in this case appear only before the third PROC REPORT step. Regards, Martin

MartinMincey · ‎10-17-2018

Hello, At this point, your code looks pretty good. But I do have a few more suggestions for you. At the very top of your code, before you create your graphics output, reset any active/old titles and footnotes by adding the following two statements to the code: title1; footnote1; Then, move the following two statements: footnote1 '<img src=cid:graf1>'; footnote2 '<img src=cid:graf2>'; Down a bit so that they now appear right after the following statement: ods html3 file=sendmail style=sasweb; Let me know if this does not resolve the issue. Regards, Martin

MartinMincey · ‎10-17-2018

Hello, Since my last reply was not formatted correctly, let me try one more time... Since on the following statement you named your two graphs GRAF1 and GRAF2 using the INLINED option: filename sendmail email to=("first.last@company.com") from=("first.last@company.com") attach = ("&workdir.\graf1.png" inlined='graf1' "&workdir.\graf2.png" inlined='graf2') type='text/html' subject="Emailing graphics output"; To then reference the first graph later on in the code, modify the following statement: title1 '<img src=cid:sgplot>'; So that it now looks like this: title1 '<img src=cid:graf1>'; Additionally, if you want to place GRAF1 before the report and GRAF2 after the report, you can use: title1 '<img src=cid:graf1>'; footnote1 '<img src=cid:graf2>'; Regards, Martin

MartinMincey · ‎10-17-2018

Hello, Since on the following statement you named your two graphs GRAF1 and GRAF2 using the INLINED option: filename sendmail email to=("first.last@company.com") from=("first.last@company.com") attach = ("&workdir.\graf1.png" inlined='graf1' "&workdir.\graf2.png" inlined='graf2') type='text/html' subject="Emailing graphics output"; To then reference the first graph later on in the code, modify the following statement: title1 ' '; So that it references GRAF1, for example: title1 ' '; Additionally, if you want to place GRAF1 before the report and GRAF2 after the report, you can use: title1 ' '; footnote1 ' '; Regards, Martin

MartinMincey · ‎10-16-2018

To send multiple graphs via email, you can specify multiple graphs for the ATTACH option on the FILENAME statement and then add additional PUT statements to the DATA step code (one PUT statement per graph). Here is sample code which demonstrates this: filename sendmail email to = ("first.last@company.com" ) from = ("first.last@company.com") attach = ("&workdir.\email1.png" inlined='email1' "&workdir\email2.png" inlined='email2') type = 'text/html' subject = "Email test of GRAPH output"; data _null_; file sendmail; put '<html>'; put '<body>'; put '<img src=cid:email1>'; put '<img src=cid:email2>'; put '</body>'; put '</html>'; run; filename sendmail clear; Below is sample SAS code which emails a graph followed by PROC REPORT output. The graph is added to the email via the following TITLE statement in the code (right before the PROC REPORT step): title1 '<img src=cid:sgplot>'; Here is the sample code: filename sendmail email to = ("first.last@company.com" ) from = ("first.last@company.com") attach = ("&workdir.\sgplot.png" inlined='sgplot') type = 'text/html' subject = "Email test of GRAPH output"; ods _all_ close; ods html3 file=sendmail style=sasweb; title1 '<img src=cid:sgplot>'; proc report data=sashelp.class; run; ods html3 close; ods listing; filename sendmail clear;

MartinMincey · ‎09-28-2018

Hello, It turns out that by default, the ODS TEXT statement does not force a new page break and does not force SAS to automatically go to a new "page" like a procedure step does. One work around is to replace the ODS TEXT statement with a regular TITLE1 statement (and make your current TITLE1 statement a TITLE2 statement). The following section of code illustrates this work around: TITLE1 J=L "^S={font_face='Calibri' font_size=5 just=L fontweight=Medium foreground=black}SUMMARY CATEGORY 4"; TITLE2 "Title Blah Blah Blah"; Footnote1 "I love texting here..."; /*CATEGORY 4*/ proc print data=sashelp.class; where sex="F"; run; I also noticed that in your code, you are missing a few ending quotes from around some of your FOOTNOTE statements (but this might have just happened when you copied and pasted the code). When you have time, see if the work around above is an option for you. Regards, Martin Mincey SAS Technical Support

MartinMincey · ‎02-06-2018

From what I can tell at this point, I think you are running into a known issue where a particular Windows 10 update breaks the connection between SAS and Java. This issue is documented in the following SAS usage note: http://support.sas.com/kb/60/323.html Even though this is strictly a Windows issue, SAS R&D did manage to put a SAS fix into place beginning with SAS 9.4 TS1M5. But a SAS hot fix for this issue is also available for SAS 9.4 TS1M3 and SAS 9.4 TS1M4. You can download the appropriate hot fix via the SAS note mentioned above. Regards, Martin Mincey SAS Technical Support

MartinMincey · ‎11-21-2014

You can also try removing the BODYTITLE option from the ODS RTF statement, such as: ods rtf file="~/test.rtf" nogtitle nogfootnote;

MartinMincey · ‎08-22-2014

With SAS 9.4, if you do want ODS Graphics to create the older style EMF output instead of the newer EMF Plus output, you can do so by modifying the SAS registry. Submitting the following code to SAS 9.4 will do this for you: %let workdir=%trim(%sysfunc(pathname(work))); data _null_; file "&workdir.\emf94.sasxreg"; put '[CORE\PRINTING\PRINTERS\EMF\ADVANCED]'; put '"Description"="Enhanced Metafile Format"'; put '"Metafile Type"="EMF"'; put '"Vector Alpha"=int:0'; put '"Image 32"=int:1'; run; /* Import the file */ proc registry import="&workdir.\emf94.sasxreg"; run; Note that this changes the SAS registry in SASUSER, so the change is fairly easy to reverse if needed. Regards, Martin Mincey SAS Technical Support

MartinMincey · ‎10-02-2013

Hello, The problem you are running into is due to a change that was made starting with SAS 9.3 where SAS 9.3 now creates HTML output by default and disables the default listing destination. To circumvent this problem with SAS 9.3, add the following two statements to the beginning of your SAS code: ods _ALL_ close; ods listing; Here are links to a couple of SAS usage notes which document this change: 49388 - Graphics output might not be sent to the desired location with SAS® 9.3 42874 - Default behavior for the SAS windowing environment on Microsoft Windows, UNIX, and Linux operating systems has changed beginning with SAS® 9.3 Regards, Martin Mincey SAS Technical Support

Online Status	Offline
Date Last Visited	‎01-26-2022 06:36 PM

Re: SAS Libref

Re: Cant Send multiple chart embedded by mail

Re: Cant Send multiple chart embedded by mail

Re: Cant Send multiple chart embedded by mail

Re: Cant Send multiple chart embedded by mail

Re: Cant Send multiple chart embedded by mail

Re: Cant Send multiple chart embedded by mail

Re: Formatting Email Spacing Between Text and proc print output

Re: Unable to get graphs due to ERROR in loading Java Virtual Machine

Re: SG: ODS RTF BODYTITLE #BYVAL in FOOTNOTE statement.

Re: SAS Libref

Re: Cant Send multiple chart embedded by mail

Re: Formatting Email Spacing Between Text and proc print output

Re: Unable to get graphs due to ERROR in loading Java Virtual Machine

Re: SAS Libref

Re: Cant Send multiple chart embedded by mail

Re: Cant Send multiple chart embedded by mail

Re: Cant Send multiple chart embedded by mail

Re: Cant Send multiple chart embedded by mail

Re: Cant Send multiple chart embedded by mail

Re: Cant Send multiple chart embedded by mail

Re: Formatting Email Spacing Between Text and proc print output

Re: Unable to get graphs due to ERROR in loading Java Virtual Machine

Re: SG: ODS RTF BODYTITLE #BYVAL in FOOTNOTE statement.

Re: Problems PDFing EMF graphics

Re: FILENAME statement for PROC GMAP PNG files not working in 9.3