cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
TYT88
‎02-14-2020
  • 10 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Width is not followed accordingly in ODS HTML

by Calcite | Level 5 in ODS and Base Reporting
‎02-13-2020 10:29 PM
‎02-13-2020 10:29 PM
Thanks for reply The huge width is set on purpose to show that it didn't work Anyway, I tested with a few width and found out that it works for small table but not big table Unfortunately, my data is big table, so I did a workaround to use blank spaces to control the width and it works   ... View more

Width is not followed accordingly in ODS HTML

by Calcite | Level 5 in ODS and Base Reporting
‎01-20-2020 04:58 AM
‎01-20-2020 04:58 AM
I have the following script that sends an email out with a table I need the columns to be in specific size and hence I used the width style The output is fine in SAS whereby the width is as per setting but not in ODS HTML It seems like the table is adjusted to fit content of the table instead FILENAME output EMAIL FROM = ("xxx") SENDER = ("xxx") TO = ("xxx") SUBJECT = ("testing") CONTENT_TYPE="text/html"; ODS HTML BODY=output options(pagebreak='no') style =MYSTYLE; PROC TABULATE DATA=sashelp.shoes; CLASS product region; classlev product / s=[width=10.75in]; classlev region / s=[width=10.75in]; VAR sales inventory returns / s=[width=5in]; TABLE product ='', region =''*(sales*SUM='' inventory*SUM='' returns*SUM='') /BOX={S=[width=10.75in]}; RUN; ODS _ALL_ CLOSE; FILENAME output CLEAR;     ... View more

Re: Sending email from SAS

by Calcite | Level 5 in SAS Programming
‎01-09-2020 10:10 PM
‎01-09-2020 10:10 PM
I found out is because the MS outlook was not open  Once MS outlook is opened, all the emails sent out    However they are a bunch of HTML tags - what did I do wrong?    <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta name="Generator" content="SAS Software Version 9.4, see www.sas.com"> <meta http-equiv="Content-type" content="text/html; charset=windows-1252"> <title>SAS Output</title> <style type="text/css"> <!-- .activelink { color: #800080; } .aftercaption { ... View more

Re: Sending email from SAS

by Calcite | Level 5 in SAS Programming
‎01-09-2020 08:57 PM
‎01-09-2020 08:57 PM
Here is the program with modified email address to hide anonymity FILENAME output EMAIL FROM = ("test@mail.com") SENDER = ("test@mail.com") TO = (&TOEMAILS) CC = (&CCEMAILS) BCC = (&SIM_MEMBERS) SUBJECT = ("test mail") CONTENT_TYPE="text/html"; ODS HTML BODY=output options(pagebreak='no') style =MYSTYLE; PROC ODSTEXT; P "test mail"; P ' '; P "xxxx"; P "(For Internal Use only)"; RUN; PROC TABULATE DATA=table1 FORMAT=COMMA15.; CLASS location sales; classlev location/ S={foreground=BLACK BorderWidth=1 background=powderblue FONT_FACE='ARIAL' font_size=8pt VJUST=C width=1.75in}; classlev sales / S={foreground=BLACK BorderWidth=1 BorderrightWidth=7 background= LIGY FONT_FACE='ARIAL' font_size=8pt borderwidth=1 width=1.75in}; VAR &LMMM._Actual &MMM._RunRate Month_Target/ s=[foreground=BLACK BACKGROUND=WHITE BorderWidth=1 background=PAGY FONT_FACE='ARIAL' font_size=8pt FONT_WEIGHT=BOLD width=1in]; VAR Achievement / s=[foreground=BLACK BACKGROUND=WHITE BorderWidth= 1 BorderrightWidth=7 background=PAGY FONT_FACE='ARIAL' font_size=8pt FONT_WEIGHT=BOLD width=1in]; FORMAT location Hcode. sales Vcode.; TABLE location ='', sales=''*(&LMMM._Actual*{S=[FONT_FACE='ARIAL' BorderWidth= 1 FOREGROUND=BLACK font_size=8pt]}*SUM='' &MMM._RunRate*{S=[FONT_FACE='ARIAL' BorderWidth= 1 FOREGROUND=BLACK font_size=8pt]}*SUM='' Month_Target*{S=[FONT_FACE='ARIAL' BorderWidth= 1 FOREGROUND=BLACK font_size=8pt]}*SUM='' Achievement*f=pctfmt9.*{S=[FONT_FACE='ARIAL' BorderWidth= 1 fontweight=bold BorderrightWidth=7 BACKGROUND= PCT. FOREGROUND=FONT. font_size=8pt]}*SUM='') / BOX={LABEL='XXX' S=[foreground=BLACK background= powderblue FONT_FACE='ARIAL' font_size=10pt font_style=italic borderwidth=1]}; RUN; PROC ODSTEXT; P ""; P "Kindly contact XXXX for any enquiries."; RUN; ODS _ALL_ CLOSE; FILENAME output CLEAR; ... View more

Re: Postimage not displaying

by Calcite | Level 5 in ODS and Base Reporting
‎01-09-2020 08:44 PM
‎01-09-2020 08:44 PM
Yes, ran on local SAS ... View more

Postimage not displaying

by Calcite | Level 5 in ODS and Base Reporting
‎01-09-2020 04:54 AM
‎01-09-2020 04:54 AM
Sorry, this might sound stupid but I am not able to figure out what is wrong I use the sample code from http://support.sas.com/kb/57/098.html Also created 2 .png files with the names, F.png and M.png at C: drive However my results do not have the image What did I do wrong?     ... View more

Re: Sending email from SAS

by Calcite | Level 5 in SAS Programming
‎01-09-2020 04:30 AM
‎01-09-2020 04:30 AM
Not able to see the email in unsent messages in Outbox or Sent Email folder in Outlook ... View more

Re: Sending email from SAS

by Calcite | Level 5 in SAS Programming
‎01-09-2020 03:42 AM
‎01-09-2020 03:42 AM
Outlook is installed and configured And yes, we both click on Allow   ... View more

Re: Sending email from SAS

by Calcite | Level 5 in SAS Programming
‎01-09-2020 03:35 AM
‎01-09-2020 03:35 AM
All the setup is in the SAS program and we didn't change anything   ... View more

Sending email from SAS

by Calcite | Level 5 in SAS Programming
‎01-09-2020 03:18 AM
‎01-09-2020 03:18 AM
I have written a program to send out email from SAS and it works fine. My question is why does it only work on my PC? My colleague tried to run SAS program and it finished successfully with no error or warnings but the email was not received by intended recipient.     ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎02-14-2020 01:50 AM
Quick links