About HabAM

HabAM · ‎05-12-2018

Thank you Cynthia, the Path/body format worked. Is this a new change with the new release? We just updated our SAS license and that is when I started having this error message.

HabAM · ‎05-11-2018

I am having errors with html formats. Here is the error message I see on my log: "ERROR: A component of C:\Users\mehretu\AppData\Local\Temp\4\SAS Temporary Files\_TD6816_SPAZIO_\H:\output\test.html is not a directory. ERROR: No body file. HTML output will not be created. " What's confusing is I have zero problem with any other format...PDF,CSV,xlsx. Any insight is appreciated.

HabAM · ‎04-01-2018

Thanks.

HabAM · ‎03-30-2018

I am trying to join tables in two different servers. my question is: 1) is it possible? 2) if so, How do I point to both connection ? proc sql; Connect to odbc as a(noprompt = "server=server1;DRIVER=SQL Server;Trusted Connection=yes;"); Connect to odbc as b(noprompt = "server=server2;DRIVER=Postgre SQL Server;Trusted Connection=yes;"); Create table ml as Select * from connection to odbc (????a and b????) (SELECT m.* from a.labs.dbo.vw_message_logging m left join (SELECT DISTINCT e.loinc FROM elr.elr.vocab_master e ) c on c.loinc=m.loinc where c.loinc is not null and m.date between 'xxxxx' and 'xxxxxx'); disconnect from odbc ; quit; run; Thank you

HabAM · ‎02-16-2018

Thank you Cynthia

HabAM · ‎02-16-2018

I did a screenshot. Please see the actual output.

HabAM · ‎02-15-2018

Here is part of the code I use. Its not that the image is large or small, it places the same image on the next page and still outputs my SGPLOT graph on top of the image. see image attached .. ods listing close; option nodate nonumber; ODS PDF file="H:\* &dt..pdf" style=color STARTPAGE=NEVER; ODS escapechar="^"; title j=l '^S={preimage="H:\*.png"}' j=c 'xxxxxxxxxxxx' j=c " &StartDate. to &EndDate."; ods layout start height=2.2in width=8in ; options orientation=portrait papersize = letter topmargin=.5in bottommargin=.25in leftmargin=.25in rightmargin=.25in; ODS noproctitle; ODS REGION ; ODS PDF text="^S={just=l font_size=12pt font_weight=bold font_face=Arial}Summary:"; ODS PDF text="^S={width=100% just=J font_size=12pt font_face=Arial }&summary."; ods layout end; ods layout gridded columns=2 column_widths=(50% 50%) column_gutter=.25in ; ODS REGION x=0in ; ods graphics on / reset noborder height=3.5in; PROC REPORT DATA = age nowd style(header)=[foreground=white background=steel font_weight=bold]; ....... title1 "^S={just=l font_size=10pt font_face=Arial font_weight=bold}Table 1: xxxxxx ( &WeekFrom., &YearFrom to Week &WeekTo., &YearTo)"; run; ..... Multiple proc statements ..... ODS Layout end; ods pdf close;

HabAM · ‎02-15-2018

I have an image in my title statement but can't contain it to the first page. I have tried to clear it with title; but didn't work. Any comments/advice is much appreciated: title j=l '^S={preimage="H:\*.png"}' j=c 'xxxxxxxxxxxxxxxxxxxx' j=c " &StartDate. to &EndDate.";

HabAM · ‎11-30-2017

Thank you

HabAM · ‎11-30-2017

Thank you, I'll use this until I find a stable source.

HabAM · ‎11-30-2017

Hello Community, I need to know what I am doing wrong with this code: interested in this page: https://wwwn.cdc.gov/nndss/conditions/search/ Two columns of interest: Name and Notifiable To current code: filename CDC url "https://wwwn.cdc.gov/nndss/conditions/search/"; data rep; infile CDC length=len lrecl=32767; input line $varying32767. len dt $varying32767. len; if find(line,"nndss/conditions/") then do; list=scan(line,4,'/'); output; end; run; filename CDC clear; Thank you

HabAM · ‎11-29-2017

It was the initial email that delayed for 24 hrs. It's working now. Thank you

HabAM · ‎11-25-2017

I have received all of my attempts over night. I don’t know what caused it to act this way, but it worked. If anyone knows what could have caused the delayed response ...I like to hear about it. Thank you Reeza.

HabAM · ‎11-24-2017

If your question is- if I have sent an email to this number ....yes. I have tested it prior and it works.

HabAM · ‎11-24-2017

I am trying to set up SMS notification, the problem is am not receiving text. Here is my log (replaced my actual number, and emailhost ID). Any help is greatly appreciated- 167 168 169 options emailsys =smtp; 170 options emailauthprotocol = NONE; 171 options emailhost = smtp.xxx.org; 172 filename myemail1 EMAIL to="7777777777@tmomail.net"; 173 data _null_; 174 file myemail1; 175 put "Test run "; 176 run; NOTE: The file MYEMAIL1 is: E-Mail Access Device Message sent To: "7777777777@tmomail.net" Cc: Bcc: Subject: Attachments: NOTE: 2 records were written to the file MYEMAIL1. The minimum record length was 9. The maximum record length was 35. NOTE: DATA statement used (Total process time): real time 0.13 seconds cpu time 0.00 seconds 177 filename myemail1 clear; NOTE: Fileref MYEMAIL1 has been deassigned. Thank you

Online Status	Offline
Date Last Visited	‎09-03-2019 05:55 PM

Re: Skipping dates on Proc Sgplot

Skipping dates on Proc Sgplot

Re: Proc Freq not displaying variable name

Proc Freq not displaying variable name

Re: Creating a FASTA file from dataset

Creating a FASTA file from dataset

Re: How to remove white space and format legend in proc gmap output?

Re: How to remove white space and format legend in proc gmap output?

How to remove white space and format legend in proc gmap output?

Re: How do you change your community UserName

Re: How to remove white space and format legend in proc gmap output?

Re: Using macro stored numbers in report- symput

Re: ODS HTML error

Re: using macro in do loop

Re: ODS HTML error

Re: ODS HTML error

ODS HTML error

Re: Proc Sql pass through on multiple server

Proc Sql pass through on multiple server

Re: ODS PDF Title statement

Re: ODS PDF Title statement

Re: ODS PDF Title statement

ODS PDF Title statement

Re: Web scraping a CDC.gov site using SAS

Re: Web scrapping using SAS

Web scraping a CDC.gov site using SAS

Re: Not receiving SMS messages

Re: Not receiving SMS messages

Re: Not receiving SMS messages

Not receiving SMS messages