My problem is that I want to access data from MS-Access and from XLS files using the Acceess to ODBC module.(I don’t have the tool SAS/ACCESS to PC File Formats) We have SAS installed on Itanium 64 bit. The data is saved on other servers (in Office 2003 ). Is there an ODBC driver for the 64bit machine that will allow us to connect to those sources? Someone suggested we can use a system-dsn on a "WOW" 32bit odbc driver and we managed to do so But how can we tell SAS to go there as DATASRC in the ODBC Libname definition And not to the ODBC 64 bit Thanks! ... View more

o.k, thanks ... View more

Yes Patrick ,my bad Soo the query dictionary.macros will do job...... ... View more

You can try this example: but notice: in filteer (where expresion) you can choose any libarary you wants!!! proc sql; create view temp as select * ,datepart(crdate) as date from dictionary.tables where libname='WORK' and calculated date>intnx('day',today(),-3); quit; ... View more

If you have only 3 macro parameters you can do : options symbolgen; %let a=23; %let b=45; %let C=89; data a; x=&a; output; x=&b; output; x=&c; output; run; ... View more

If i get what you want this example may help you: /*for example: this is your data*/ data test; LENGTH date $10.; input Number_of_Sightings date $; date_new=input(date,ddmmyy10.); week=week(date_new); /*return the number of week according to this year*/ format date_new ddmmyy10.; cards; 10 01112008 12 05112008 1 06112008 3 09112008 4 14112008 ; run; /*count sightings per week*/ proc sql; select count(Number_of_Sightings) as Sightings ,week from test group by week; quit; ... View more

Hi Linus , Thanks for help !! ... View more

Hi, I think this example might be usefull for you: %let num=0; data _null_; input x; call symput('num',_n_);/*counting the numbers of rows in your dataset cards; 1 2 3 4 5 6 7 8 ; run; %put # %macro check_num; %if &num>0 %then %do; filename mymail email "yonib@bbb.com" from="yonib@bbb.com " subject="the data set has &num obs"; data _null_; file mymail; put 'free text'; run; %end; %else %do ; filename mymail email "yonib@bbb.com" from="yonib@bbb.com " subject="the data set has no obs"; data _null_; file mymail; put 'free text'; run; %end; %mend; %check_num; ... View more

Hey, Here is an example of using lag function to get what you looking for base on your example: data temp (drop=ind num2 num3); length num3 $10.; input num1 $ num2 $10. num3 $; num22=input(num2,mmddyy10.); num33=input(num3,mmddyy10.); format num22 mmddyy10. num33 mmddyy10.; ind=lag(num33); if ind=num22 or ind=num22-1 then new=1; else if ind=. then new=1; else new=2; put _all_; cards; x 01/11/2008 01/15/2008 x 01/15/2008 01/30/2008 x 01/31/2008 02/10/2008 x 02/15/2008 02/26/2008 ; run; ... View more

Thank you Linus , I appreciate the time you spend on it ! In sas code its realy not a problem but I was curious if it can be done with sql. I tried to think about a way to solve it and nothing cross my mind. Thanks again for your help!!! ... View more