SAS Support Communities

Hi everyone, I need some help; I need to write a code that will send an email and I need it to have some tables. Using PROC REPORT works well enought when it's a single one, but when I add the second, a page break is inserted that ends up messing the layout.   ODS _ALL_ CLOSE; OPTIONS EMAILSYS=smtp; OPTIONS EMAILAUTHPROTOCOL=none; OPTIONS EMAILHOST="smtp.mail.com"; OPTIONS EMAILPORT=25; FILENAME myemail EMAIL TO = ("recipient@mail.com") FROM = ("sender@mail.com") TYPE = 'text/html' SUBJECT = "Reports"; ODS HTML BODY=myemail STYLE=EGDefault; /* Email text */ ODS HTML TEXT = '<p>Greetings,</p>'; ODS HTML TEXT = '<p>Here are the results on this week.</p>'; ODS HTML TEXT = '<p style="font-size:16px; font-style: italic">Report 1</p>'; /* First Report */ PROC REPORT DATA=sashelp.class; RUN; /* Back to the email */ ODS HTML TEXT = '<span>Some more text.</span>'; ODS HTML TEXT = '<p style="font-size:16px; font-style: italic">Report 2</p>'; /* Second Report */ PROC REPORT DATA=sashelp.class; RUN; /* Finishing the email */ ODS HTML TEXT = 'That is all, best regards'; ODS _ALL_ CLOSE; Has anyone had this problem and found a solution?   Thanks in advance! ... View more

Hi, everyone.   I have a routine that separates data based on its semester. I need some help creating a custom date format that would output a date in the format YYYYSS (Y = Year, S = Semester), like this:   +-----------+---------+ | DATE | OUTPUT | +-----------+---------+ | 05FEB2018 | 201801 | | 05AUG2018 | 201802 | | 13JAN2019 | 201901 | +-----------+---------+ Can anyone help me? Thanks in advance.       ... View more

Greetings!   I need help connecting to a second remote server.   The way I usually work with the EG is I set up the Tools > Connections > Profiles and save the remote server, my username and password. However, this time I need to connect to a second server (with another address, username and password) while still connected to the main one. The username and password are the same between servers.   Is there any way for me to do this? I need to use files which are in both servers, and want to remove any manual intervention from the process (i.e. copying the table manually).   Thank you! ... View more

Hi.   I need some help getting the max value from a column in a table. I initially tried writing a function as such:     PROC FCMP OUTLIB=work.func.test; FUNCTION get_max(table $, column $); PROC SQL; SELECT MAX(column) INTO :ret FROM table; QUIT; RETURN ret; ENDSUB; RUN;     But it doesn't work. Any ideas?   Thanks in advance. ... View more

  Hi,   I'm trying to define a function with an optional parameter. My goal with the function is to return either the MAX or MIN value of a column, given the choice of the parameter. But it could be omitted, and it would default to returning the MAX value.   I'm trying to do something like this:     PROC FCMP OUTLIB=work.func.test; FUNCTION get_extreme(table $, column $, type); IF type = 1 /* or not informed */ PROC SQL; SELECT MAX(column) INTO :ret FROM table; QUIT; ELSE PROC SQL; SELECT MIN(column) INTO :ret FROM table; QUIT; RETURN ret; ENDSUB; RUN;   So, assuming I have a simple table, like this:   +---------------+ |  date | value | +---------------+ | 20820 | 1000 | | 20821 | 850 | | 20822 | 1100 | | 20823 | 900 | +---------------+   I could use the function and would get these results:   %put %sysfunc(get_extreme(table, date)); /* Output should be 20823 */ %put %sysfunc(get_extreme(table, value, 0)); /* Output should be 850 */ %put %sysfunc(get_extreme(table, date, 1)); /* Output should again be 20823 */ Can anyone help me?   Thanks in advance.   ... View more