Take a look at: http://www.listserv.uga.edu/cgi-bin/wa?A2=ind0312e&L=sas-l&D=1&O=A&m=167104&P=3830 or, in short form: http://tiny.cc/0w6mz In that post, Paul Choate said that he successfully tried the following method: FILENAME website HTTP 'http://www.iso-ne.com:80/settlement-resettlement/SMD_operating_reserves_sum mary/200311_OR_Summary.xls'; data file;   n=-1;   infile website recfm=s nbyte=n length=len;   input;.   file  "200311_OR_Summary.xls" recfm=n;   put _infile_ $varying32767. len;   run; PROC IMPORT OUT= WORK.D200311_OR_Summary_NEMA             DATAFILE= "200311_OR_Summary.xls"             DBMS=Excel REPLACE;       RANGE="A3:G80";       sheet="NEMA";       getnames=yes; RUN; HTH, Art ... View more

Doc, Yes, I both saw that post and emailed the paper's author the same day as I posted my response to the current thread. If she resonds, I'll post the answer here. Art ... View more

Caramel, According to the following SUGI 31 paper, a macro exists that does what you are looking to accomplish: http://www2.sas.com/proceedings/sugi31/198-31.pdf However, I've been unable to obtain a copy of that macro. If anyone has it, I'd appreciate knowing how to find it. Art ... View more

A description of SAS-L, and how to access it, can be found at: http://www.sascommunity.org/wiki/SAS-L Art ... View more

Lucas, I posted your question on the SAS-L board and one if its members, Joe Matise, provided precisely what I think you were looking for. Take a look at the following: DATA test; length col_EXP $50; col_EXP="intnx(day,%sysfunc(today()),2)";output; col_EXP="intnx(day,%sysfunc(today()),10)";output; RUN; data want; set test; format col_DT date9.; col_DT = resolve('%sysfunc('||col_exp||')'); run; Also, you had asked me about the formatting of the put statements I had used in my original offering. The +3 was simply indenting the line so that the file would be easier to read by humans. Art ... View more

I'm not sure if the following is showing the same thing as you are asking, but it might be worth a try: data thefiles; set sashelp.vextfl; run; Art ... View more

Lucas, There has GOT to be a less convoluted way than the one I'll propose but, if this is something that you HAVE to get done, the following might provide what you need: DATA test; length col_EXP $50; col_EXP="intnx('day',today(),2)";output; col_EXP="intnx('day',today(),10)";output; RUN; filename ft17f001 temp; data _null_; file ft17f001; set test end=lastone; if _n_ eq 1 then do; put 'data test2;'; put +3 'format col_DT date9.;'; end; put +3 'col_DT=' col_EXP ';'; put +3 'output;'; if lastone then put 'Run;'; run; %inc ft17f001 / source2; data test2; set test; set test2; run; HTH, Art ... View more

Cynthia already answered your question of how you can do it, but she didn't address your question of why your attempt counts cumulatively. When you use the construct num+1, SAS automatically retains the value across rows. If you simply added a statement: num=0; before your do loop, it wouldn't end up counting cumulatively. HTH, Art ... View more

Your messages are telling you that you are trying to use macro variables with the sum function (namely, &expos0, &expos1 and &expos2), but have never assigned values to those variables. You also should have received an error message regarding your statement texpos=, as that would only be valid within a data step. Art ... View more

Like Cynthia said, you didn't show a statement where you are calling your macro (i.e., a statement like: %loop ) The only other thing I can immediately think of is that your data may not be the same as when you have run the code in the past. Specifically, I was surprised to see a variable called month_date, but used in a function that requires a datetime variable. Your code appeared to run correctly on my computer. Art ... View more

Some similar methods for accomplishing the same thing can be found at: http://www.sascommunity.org/wiki/Look-Ahead_and_Look-Back>/url> HTH, Art ... View more

I received an answer from SAS-L. It was a bug that was addressed in a hot fix: http://support.sas.com/kb/15/924.html hotfix E9BB78 . ... View more

Mrom, Quite possibly I'm not following everything that you're doing, but WHY would you expect the variable TO work with a period after it? A period would only be relevant after a variable name if you were referring to a macro variable. Art ... View more

Sreenivas, I've never worked with SPDS, thus I'm not sure if that is what is causing the problem. As someone mentioned, with SPDS, the problem could be due to existing files/permissions. The following test of your code works for me .. but not using SPDS: %let spdssize=128; %let pid=1; %let fromdt=29SEP2010; libname medmart "k:\art"; libname t "k:\art"; data t.lab_d_&pid (drop=height age); set sashelp.class (rename=( name=CL_HE_SEQ_ID weight=SUBM_PATIENT_ID)); run; data lab_c (drop=weight age); set sashelp.class (rename=( name=CL_HE_SEQ_ID)); run; data t.lab_&pid; merge t.lab_d_&pid(in=a) lab_c(in=c); by CL_HE_SEQ_ID; if c; run; data lab_mbr_latest (drop=weight height); set sashelp.class (rename=( name=member_card_code)); run; proc datasets library=work; modify lab_mbr_latest; index create member_card_code; run; data t.lab1_&pid; set t.lab_&pid; set lab_mbr_latest key= member_card_code/unique; if _iorc_ ne 0 then state=''; run; proc sql; create table medmart.U_LAB_NW_&fromdt(type=DATA) as select SUBM_PATIENT_ID as PatientID from t.lab1_&pid;; quit; Some things you could try to clean up are: (1) your second line from the bottom has 2 semicolons where only one is needed (2) you could put periods after each time you use a macro variable (3) is your spdssize macro variable set to a large enough number> Other than that, I'd think that the problem is SPDS specific. Have you asked SAS Technical Support? HTH, Art ... View more