Sorry for the delay - going to be a busy week... You are correct - i run this code from a CALL EXECUTE.  Unfortunately, I can't change thsi because the code runs against each member of a directory  In cases when I do use the %INCLUDE, I don't have this problem. I usually turn off SOURCE2 as well, but I need to see what is happening during development. ... View more

I'll do the best I can with the code samples.... Here is my code (just a small part of the program): 545    if substr("&imember",11,1) = 'A' and length(account_number) ge 10 then do; 546        if substr(account_number,10,1) = '-' then substr(text,14,12) = account_number; 547        else do; 548            substr(text,14,9) = substr(account_number,1,9); 549            substr(text,23,1) = '-'; 550            substr(text,24,2) = substr(account_number,10,2); 551            end; 552        end; 553 554    if substr("&imember",11,1) = 'C' then do; 555        substr(text,14,12) = account_number; 556        substr(text,26,1) = ' '; 557        substr(text,35,1) = ' '; 558        end; 559 560    substr(text,27,8) = trade_date; 561 And this is how my log looks (sort of): if substr("46TR092911A.xls",11,1) = 'A' and 46  + length(account_number) ge 10 then do;       if substr(account_number,10,1) = '-' then substr(text,14,12) = account_number;       else do;           substr(text,14,9) = substr(account_number,1,9);           substr(text,23,1) = '-';           substr 47  +(text,24,2) = substr(account_number,10,2);           end;       end;    if substr("46TR092911A.xls",11,1) = 'C' then do;       substr(text,14,12) = account_number;       substr(text,26,1) = ' ';       substr(text,35,1) = ' ';       end;    substr(text,27,8 48  +) = trade_date;    transaction_type = upcase(transaction_type);        if transaction_type =: 'B' then  trans_type = '100';   else if transaction_type =: 'S' then  trans_type = '690';   else if transaction_type =: 'E' then  trans_type = '400';   else if Which makes it rather hard to read.  The text seems to loose all syntax.  It actually goes beyond the right side of my screen in the SAS log window.  (Here it seems to wrap within this window). It's not a big problem, but it is a pain in the backside. ... View more

Try: proc summary data = sasuser.marchflights maxdec=2 sum mean;   class date;   var distance mail freight boarded transferred nonrevenue passengercapacity; output out = mtsudat.marchflights (drop=_TYPE_ _FREQ_) SUM=; run; ... View more

Throwing in my 2 cents worth.... It looks like you need to delete the entire dataset rather than a single SAS table.  My first course of action would be to identify who has the lock on the file, otherwise we have had success just running a DOS command to delete the file at the appropriate time.  Here is a sample where we clean out a dataset of all html files before rewriting them.  This could be easily change to delete the entire file.  Just run the macro with the name of the file: %macro deletefile(filen);   %let delcmd1 = DEL "&prefix.\*.html ";   %put deleting &filen data;   data _null_;   X &delcmd1;   run; %mend; ... View more

There seems to be some conflicting data on this....  The INFILE documentation says that the LRECL is dependent on the operating system, while the SYSTEM OPTION documentation says the maximum is 32,767.  ... View more

Actually, I think can be an issue with the large LRECL on some platforms.  I would suggest that you reduce the LRECL to 32767 at the maximum (this is 2**15 -1).  My only justification for this is that this is the system limit for z/OS mainframe systems and I have always been told that this is the maximum LRECL that can be used.  ... View more

Without seeing all the data, I can only guess: it looks like there are values of X that are less than 0 (zero).  I think you need to adjust the range of the axis to begin with the lowset value of X.  You may need another macro variable for the min(x) value. If you want the line to start with X=0, then you will need to insure that there is a data point with X=0, otherwise the line will start with the lowest value of X > 0 (which looks like obs 98 where x=0.02099 something - which is where the line seems to start on your graph). ... View more

Hi: Firstly, i would suggest that you increase the value of &DmaxValue for the Y axis by 1 (or 2) because it looks like the axis only goes to 36 and the data values are greater than that.  This would cause the line on the graph to start at the first X value that is < 36. If that doesn't work, then include sample data and the rest of the code so we can see what is going on. ... View more