Hi, we have a list in an Excel spreadsheet of email addresses that production reports go out to each day.  The spreadsheet is read each day and the resulting email addresses are used to distribute reports.  But...the problem is that we often have people that leave the company and we are not aware of them leaving and so the report gets sent to an orphaned email address.  Is there a simple way of having the program go out each morning and poll the corporate email server and give us a list of the email addresses that are no longer in our system?  Not sure if I am giving enough information but it's a start I guess.   Thanks much for any advice as to whether this is even possible.   Dave ... View more

Was hoping someone could help me.  Probably an easy answer to this, but I can't figure it out.   Let's say I have the following macro:   %macro first(dsn, bylist, outdat);      proc sql;          create table &outdat          select &bylist          from &dsn;      quit; %mend first; %first(dsn=mydata, bylist=x y z, outdat=outfile);   My problem is that I want to build a select statement based on the variables I feed the macro using the macro variable bylist.  The problem is, of course, that the list has to be separated by commas in the select statement in proc sql.  I need to feed the macro a list of items to use in that select statement because the variables will change with each call to the macro and the number of variables in that bylist will change as well.  In other words I need to tell the macro what variables I want to use in the select statement with each call to the macro.  Is there an easy way to do this?  I'm drawing a blank.   Thanks in advance so much for your help.           ... View more

Hi all. I am having a horrific issue with Proc Import. I was using it to read in a rather messy file in version 9.1.3. It took a bit of cleaning up but the data read in as the correct format and once it came into a sas dataset it could be cleaned a bit into a useful set of data for us. We recently upgraded to version 9.2 and we completely lost our ability to do what we have been doing in 9.1 for over a year. Now the data reads in as text when before it read in as numeric. Here is a brief sample of the data coming from excel. F1 F2 F3 F4 F5 F6 product region plan Jan-2010 Feb-2010 Mar-2010 external plans vs region First quarter 2010 COMM CHI ARKANSAS 23,485 12,347 17,263 COMM SF CALIFORNIA 825 734 812 COMM SF PORTLAND 1,235 2,345 14,235 COMM NY WESTCHESTER 127,345 112,712 105,399 All I really care about is capturing the last four lines. I don't care about the dates or the other extraneous data in the file including the dates. I just want a dataset with the data from the last four lines. When using the proc import statement in 9.1 it worked fine in terms of reading the actual numeric data. It converted that comma-formatted data in Excel to numeric variables. Then I could use a little programming logic to clean up the file and get rid of those extraneous rows of data so all that was left were the last four and the data themselves (variables F4-F6) were formatted as numeric varialbes. But in 9.2 the Proc Import is suddenly making all those variables character. And I can't seem to convert them back into numerics. Why did Proc Import change between versions. Any thoughts on what to do with this so I can once again have numeric variables? Thanks in advance. ... View more

Hi everyone... I have a SQL routine that pulls data from a large data warehouse. In it I have a where statement where one of the conditions is as follows: Where AdmitDT>INTNX('Day', Today(), -181) Basically, I want to count back and include those records where the AdmitDt is greater than 181 days prior to today. However, SAS does not like this statement at all. I have a feeling that I am doing something that completely demonstrates my lack of knowledge in handling dates and times in SAS. Any help would be appreciated. ... View more

Can someone help me with this one....tearing my hair out. I am trying to see the code that Proc Import uses to import my Excel spreadsheet. But the code is not being displayed in the log window and I think it is supposed to be there. Did I somehow turn an option off or something? Any help would be appreciated. Dave ... View more

Hi everyone... I am new here and have a simple formatting issue. I am using Proc Import to read in a worksheet in Excel. The first four columns are character and it correctly reads them in for me each and every time. The next "x" number of columns (never sure how many - anywhere from 1 column to 200 columns after column 4) are always numeric. But sometimes my data is messy and it reads it in differently than what I want. It will sometimes read it in as a numeric, sometimes as a "BEST" format and then sometimes as character. I want them to ALWAY be numeric. Is there a way to do this and make it flexible enough to take however many columns of "numeric" data and read it in correctly as the same numeric format for all the extra columns past column 4? Thanks so much for your help! Dave ... View more