I changed my bank-file in a way I'm now able to spit the RV-file. Dataset  BankList: Bank Naam Rek1 Taal B1 AA1 GB44CITI26408067654932 EN B2 AA2 NL32FTSB1387056271 EN B3 BB1 007-2567914-12 FR B4 BB2 001-0077540-70 FR B5 CC 301-1234567-89 NL B6 DD NL65DEUT1234567890 EN Instead of using Rek2 I added a line with the second Rek. I had to change the Naam and added a number. After my program I get 6 datasets AA1 - AA2 - BB1 - BB2 - CC - DD ( in this example) Then I'm wrote a proc datasets to  append each datasets2 to the 1. Proc datasets;      append base=Lib.AA1 data =Lib.AA2 force; run; Can I write something to do this automatically? So I would like to add a program step in my project that appends the 2-datasets to the 1's. But AA1 append AA2 should become AA-dataset. I would like to do this in a program because sometimes a bank gets a second Rek and then I don't need to change my project. Can this be done in a program Who v ... View more

The worksheet showen in the pdf is created in Excel, and that's how the SAS-output should be. (fische excel.xls) I don't need to have colors in my output, it was only to indicate the different type of fields. Green fields are data taken from SAS, blue field are calculated and the white fields are tekst. The excel-file is based on a SAS-dataset like this table. The data is sorted based on Number (asc) and Start_date (desc). Number Start_date Date_Fin Code_1 Code2 12345 01-06-2012 30-06-2012 76 4 12345 01-05-2012 31-05-2012 85 5 12345 01-04-2012 30-04-2012 80 4 12345 01-03-2012 31-03-2012 83 5 12345 01-02-2012 29-02-2012 79 3 12345 01-01-2012 31-01-2012 81 4 45678 01-05-2012 30-06-2012 80 6 45678 01-03-2012 30-04-2012 79 5 45678 01-01-2012 29-02-2012 83 7 78912 01-06-2012 30-06-2012 80 5 Based on this table I should create 3 excel-files  IFI_12345, IFI_45678 and IFI_78912. Can I do this with Proc Report or should I keep using the call execute? temp.xml is an example created with the call execute methode. As you can see there is no layout. ... View more