Hi,   I am tring to insert more than 1300k records in an Oracle table using PROC SQL.   Few of the fields are of type XMLTYPE i.e. the value of these fields is in XML string format with all headers in place and some values for each label w.r.t each field. It is taking nearly 1 hour for every 100k records to be loaded, which is reaaaally slooowww.   I believe that has to do with XML validation, before the records are inserted into the table, as the INSERt statement is making sure the value for XMLTYPE variables being loaded are in line with the XML tagging rules.   Is there a workaround?   Please advise. ... View more

Hi All,   I was able to place a png & htm file after running following code,   %let name=bar1; FILENAME odsout "&_SASWS_/charts";   /* This allows me to output bar1.png being created in my home directory under charts */ goptions xpixels=480 ypixels=300 device=png noborder cback=white; ods listing close; ods HTML path=odsout body="&name..htm" style=minimal; title; footnote; proc gchart data=running; vbar Date / sumvar=Mile_3 clipref frame type=sum  coutline=black raxis=axis1 maxis=axis2  des="" name="&name."; run; quit;   Now how do I pull/read/access/fetch the file BAR1.png or BAR1.htm back in my proc report if I intend to email this image alongwith proc report output?   proc report data = running STYLE = [PREHTML = %UNQUOTE(%STR(%')  <table width="100%" border="0" cellspacing="0" cellpadding="0"><tr>  <td align="center"><strong>3 Mile Race Times</strong></td></tr>  <tr><td align="center">  <img src="what-do-I-mention-here" width="480" height="300" align="middle" />  </td></tr></table>  %STR(%'))]; column Date Mile_1 Mile_2 Mile_3 Mile_4; define Date / display; define Mile_1 / display; define Mile_2 / display; define Mile_3 / display; define Mile_4 / display; run; quit;   Anybody who could help please?   Regards, Arpit ... View more

I created an account for Online SAS Studio using https://odamid.oda.sas.com/SASStudio/  for practicing my SAS skills.   Following Chris Hemedinger blog (http://blogs.sas.com/content/sasdummy/2013/07/31/gmail-from-sas-program/), I tried to implement the learning.   I intend to send email TO gmail, for which if I use following lines and it works like a charm (read on to get to know the problem)   filename myemail EMAIL   to="myuserid@gmail.com"   subject="Hi";  data _null_;   file myemail;   put "Hello Friend"; run; filename myemail clear;   However, when I use below lines of code on top of that, it errors out,   options emailhost=  (    "smtp.gmail.com" port=587    STARTTLS auth=plain     id="<my-gmail-userid>"    /*pw="my-gmail-password" */  ) ;   So basically it's erroring out when I am trying to use GMAIL as a SENDER.   I have already done the following :- a) Enabled "Less secure apps" on my Gmail account in order to send e-mail from a non-Google application (including SAS). b) Tried port 587, and STARTTLS instead of SSL.   Here is what the log looks like,   NOTE: The file MYEMAIL is: E-Mail Access Device   ERROR: Email: 535-5.7.8 Username and Password not accepted. Learn more at ERROR: Email: 535 5.7.8 https://support.google.com/mail/?p=BadCredentials y3sm19145222pfy.36 - gsmtp NOTE: The SAS System stopped processing this step because of errors. NOTE: DATA statement used (Total process time): real time 1.60 seconds user cpu time 0.04 seconds system cpu time 0.00 seconds memory 2265.09k OS Memory 29088.00k Timestamp 09/11/2016 07:32:21 PM Step Count 14 Switch Count 65 Page Faults 0 Page Reclaims 1277 Page Swaps 0 Voluntary Context Switches 236 Involuntary Context Switches 1 Block Input Operations 0 Block Output Operations 0   Do the experts here have any help to offer? Please advise.   Regards, Arpit ... View more