I have moved my question to a more appropriate forum (SAS Macro Facility, Data Step and SAS Language Elements) http://support.sas.com/forums/thread.jspa?messageID=39197餝 ... View more

HI Darryl I'm not using EG and I can easily solve the problem using the X command, CALL SYSTEM or simlilar. (sorry, should have stated that more clearly in my first post) My curiosity was regarding the opportunity to use the DATA STEP statements infile/input and file/put to 'copy' an Excel file. ... View more

Hi Patrick I'm not using EG and I can easily solve the problem using x command, call system or simlilar. (sorry, should have stated that in my question) I was just wondering how I could read a binary file and write it back using only datastep statements. I'm curious and would like to try it 😉 but failed ;-( I have somewhat similar problem (batch job) where I want to write a file (Excel) to the webdav (overwrite). If you have a solution for this, I'm also interessted 😉 ... View more

Have a look at http://support.sas.com/kb/38/690.html ... View more

Have a look at the getoption function -> http://support.sas.com/onlinedoc/913/getDoc/en/lrdict.hlp/a000149068.htm ... View more

Try this simple sample data input; input id year age ; datalines; 100 2005 . 100 2006 . 100 2007 25 101 2005 . 101 2006 28 101 2007 29 102 2005 35 102 2006 36 102 2007 37 ; run; proc sort data=input; by id descending year age; run; data output; retain Rage; set input; by id; if age ne . then Rage=age; run; You will need to implement some testing - i.e. what to do if the latest obs for an id is also missing age etc. etc. But I hope the above code will get you started in writing the code that will solve your problem. ... View more

Hi Curtis Tx for posting your code - It's always nice to see the final solution. I think I will use some of your code in the future. ... View more

In SAS you have several ways to solve this - i.e. have a look at RETAIN or LAG(). This little mock-up code will show you one path you could walk down. data input; format valid_from valid_to ddmmyy10.; input Obs Product_no price valid_from :ddmmyy10. valid_to :ddmmyy10.; datalines; 1 4711 100 01-01-2000 31-01-2002 2 4711 150 15-02-2002 03-06-2008 3 4711 125 04-06-2008 31-12-9999 4 5000 1500 01-01-2007 31-12-2007 5 5000 1575 01-02-2008 31-12-2008 6 5000 2000 01-01-2009 31-12-9999 ; run; proc sort data=input; by Product_no descending valid_from valid_to; run; data output; format prev new_valid_to ddmmyy10.; set input; by Product_no; if not first.product_no then prev = lag1(valid_from-1); if prev ne . then new_valid_to = prev; else new_valid_to = valid_to; run; proc sort data=output; by Product_no valid_from valid_to; run; ... View more

Have you tried Proc OLAPOPERATE http://support.sas.com/documentation/cdl/en/olapug/59574/HTML/default/a003229699.htm or issue a command line like net stop servicename http://windowsitpro.com/article/articleid/14872/how-can-i-stop-a-service-from-the-command-line.html ... View more

I dont understand why this will work, when I try data test; keep age name ; set sashelp.class; run; I get name before age? The only way I can get this to work is either by using proc SQL or by using the attrib (or format/lenght) in the datastep. ... View more

or do you want to create a new file name from the content of your data ? data _null_; set sashelp.class; filename= cats('d:\',name,'.htm'); file dummy filevar=filename dsd; put age; run; ... View more

do you want to write the names of the variables to a file ? %let file = variables; data _null_; set sashelp.vcolumn(where=(libname='SASHELP' and memname='CLASS')); file "d:\&file..html" dsd; put name @; run; ... View more