Hello everyone, I'm trying to download some customer number data from a company intranet site.  Attempting to adapt some code that Tom gave me (thanks again!) which downloads data from the internet using an input statement.  Code works fine when I specify the number of customer numbers.  Unfortunately, the number of customers is unknown.  There may be 10 or 100. The number varies based on company region and other characteristics.  Note I tried using the DIM(var) syntax to obtain the dimensions of the array, but I get the following error message: ERROR: The array CUST_NUM has been defined with zero elements. ERROR: Too many array subscripts specified for array CUST_NUM. Below is the code I'm using.  Does anyone have any suggestions on how to define the array such it'll be able to handle varying numbers of customers? Thanks so much for any help or advice. -Bill Again when I run this code I get the above error message. %MACRO CUSTOMER_NUMBER(HTML_TAG,SAS_NAME); data &SAS_NAME.; infile in flowover ; input @&HTML_TAG. @;  /*START*/ array &SAS_NAME. (*) $8.; do col=1 to dim(&SAS_NAME.);    input @ '/q?s='  &SAS_NAME.(col) $8. @; end; drop col; run; %MEND; %CUSTOMER_NUMBER('>Preferred Customers<',CUST_NUM); ... View more

Hello, I recently learned how to send emails/texts with SAS, and now I'm trying to put that knowledge to use in a data step.  Basically, I want to send myself a text mesaage with a list of CustomerIDs that have errors.  I have code that checks for errors and want to receive a text only when new CustomerIDs appear in the "error" data set.  Here's the code that I'm currently using: Top of program: options emailsys=smtp emailauthprotocol=login emailid="xxxxxx@aol.com" emailpw="xxxxxxxx" emailhost=smtp.aol.com  emailport=587; Code within macro: DATA NEW_ERRORS; MERGE OUT.KNOWN_ERRORS (IN=IN1) ERRORS (IN=IN2); BY CUST_ID; IF IN2 & NOT IN1 THEN DO;      OUTPUT NEW_ERRORS;      filename mymail email "xxxxxxxx@txt.att.net" subject="CustomerIDs with potential errors" lrecl=256;      file mymail;      put 'list of CustomerIDs with errors separated by commas or spaces.';  *Still need to figure out this part!; END; RUN; proc append base=OUT.KNOWN_ERRORS data=NEW_ERRORS FORCE; proc sort data = OUT.KNOWN_ERRORS; BY CUST_ID; RUN; *NEED TO SORT DATA FOR SUBSEQUENT MERGES; What I'm attempting to with the above is take the list of errors over all CustomerIDs (ERRORS) and compare them with the currently known list of CustomerIDs with errors (OUT.KNOWN_ERRORS).  If there's a new set of CustomerIDs with an errors I want to 1) receive a text message with only that list of CustomerIDs (new errors) and 2) add those CustomerIDs to the currently known list of errors (OUT.KNOWN_ERRORS).  This way when the code is run again, I won't receive another text with the same list of CustomerIDs.  Note code works fine in terms of identifying and adding only the new errors to the known list of errors.  The issue I'm having is debugging the text message part.  When I run the code with no new CustomerIDs added to the list, I get constantly bombarded with text messages.  Therefore my DO statement isn't firing the text message code appropriately.  Does anyone have any suggestion as to what I'm doing wrong?  Am I trying to do  too much in one data step?  Also, does anyone know how to include the list of new CustomerIDs in the body of my text?  I was hoping to do this in a list format with each CustomerID separated by commas or spaces.  How would I create such a list?  As output to my log?  Or do I need to create some sort of macro variable that'll be used in an ODS statement? Any help or advice would be greatly appreciated.  Thank you very much! -Bill ... View more

Hello, I'm trying to send email from a data step using SAS 9.3.  I believe that I can configure my email client in an options statement.  However, when I do so and attempt to send myself a test email, I get the following error message: "ERROR: Email: The connection was reset by a peer."  Note I'm running Windows 7 (64 bit) and want to send the email using the smtp protocol.  Here's my code: options emailsys=smtp emailid="xxxxxxx@sbcglobal.net" emailpw="xxxxxxx" emailhost=outbound.att.net  emailport=465; filename mymail email "xxxxxxx@sbcglobal.net" subject="test message" lrecl=256;    data _null_;       file mymail;       put 'hello there';    run; Are there any errors in the above?  Also, here's the link to the ATT smtp settings.  At the top of the page they state that if you setup your email account after June 2011 you can't use an email client.  I setup my account several years ago, so I don't think that's the issue. Email server settings (POP and SMTP) - AT&T  DSL High Speed Support  Any help or advice would be greatly appreciated!  Thank you! -Bill ... View more

Hello, What's the most efficient way to stop executing a fairly involved program at a specified time?  For example if I have a program with several macros and data steps would I use a batch command to stop the code at 7am PST?  Or is there an easy way to use a time parameter within SAS that would apply to the entire program (E.g. DO UNTIL loop)?  Any help or advice would be greatly appreciated.  Thank you! Regards, Bill ... View more

Hello, I'm trying to use SAS to acquire data from the internet.  More specifically, I'm interested in financial data on publicly traded companies.  I have code which downloads the financial information.  This part works fine.  The issue is that the data may span across several observations.  My plan to is tag all the observations with relevant data and then use proc transpose to combine the multiple observations into one observation where I can use nested if statements and substrate/index functions to extract the information.  I'm attempting to use a DO UNTIL loop to mark the records with relevant information, but can't get it to work properly.  My program crashes whenever the data spans across more than one observation.  Please see my code below.  Does anyone have an idea of what I'm doing wrong?  Any help or advice would be greatly appreciated.  Thanks so much! Regards, Bill *DOWNLOAD FINANCIAL DATA; filename in url 'http://finance.yahoo.com/q/bs?s=AAPL' debug lrecl=8192; DATA OUT.YAHOO_HTML; infile in length=len; input record $varying8192. len; RUN; *PARSE HTML; %MACRO BAL_SHEET_ITEM(YAHOO_NAME,SAS_NAME); DATA OUT.&SAS_NAME.1; SET OUT.YAHOO_HTML; SYMBOL='AAPL'; *LIMIT DATA SET TO RECORDS WITH RELEVANT INFO; KEEPDATA = 0; %LET BEG_DATA=INDEX(record,&YAHOO_NAME.); /* BEGINNING OF DATA*/ %LET END_DATA=index(record,' </td></tr><tr>');/*END OF DATA*/ IF &BEG_DATA. > 0 THEN DO UNTIL (&END_DATA.>0); KEEPDATA=1; END; IF KEEPDATA=1; RUN; %MEND; %BAL_SHEET_ITEM('Cash And Cash Equivalents',CASH_AND_EQUIV); %BAL_SHEET_ITEM('Inventory',INVENTORY); %BAL_SHEET_ITEM('Short Term Investments',SHORT_TERM_ASSETS); %BAL_SHEET_ITEM('Net Receivables',NET_REC); %BAL_SHEET_ITEM('Inventory',INVENTORY); %BAL_SHEET_ITEM('Other Current Assets',OTH_CURR_ASSETS); %BAL_SHEET_ITEM('Accounts Payable',ACCTS_PAYABLE); %BAL_SHEET_ITEM('Short/Current Long Term Debt',SHORT_CURR_LT_DEBT); %BAL_SHEET_ITEM('Other Current Liabilities',OTH_CURR_LIAB); %BAL_SHEET_ITEM('Long Term Debt',LT_DEBT); %BAL_SHEET_ITEM('Other Liabilities',OTH_LIAB); %BAL_SHEET_ITEM('Deferred Long Term Liability Charges',DEF_LT_LIAB); %BAL_SHEET_ITEM('Minority Interest',MIN_INT); %BAL_SHEET_ITEM('Negative Goodwill',NEG_GOODWILL); ... View more