Hey all together,
I need to code 4 PROC EXPORT statements in one program.
All of them referencing the same excel workbook and sheet.
The code is like:
1.a.) reading the Excel sheet into a SAS dataset
1.b.) calculating/merging something
1.c.) update the Excel sheet by using PROC EXPORT statement
2.) doing something sensible like caching data from another remote host....
3.a.) reading the Excel sheet into a SAS dataset
3.b.) calculating/merging something
3.c.) update the Excel sheet by using PROC EXPORT statement
...and so on....iterating 4 times
The Problem:
Even if, according to the log all seems fine.....SAS only executes the first PROC EXPORT statement correctly.
For the 2nd, 3rd and 4th PROC EXPORT the new observations are not exported to the excel sheet.
Code snipped:
/* import existing user */
proc import datafile="&workspace.\All-Users-&assigned_year._mail.xlsx"
out=smf.old_user
DBMS=excel2007
replace;
run;
* merge new user and old user into new user dataset */
Data smf.cur_user;
set smf.old_user smf.abteicpu;
where user_id like 'XX_____';
keep user_id Vorname Name Abteilung Mail EXTERNALMAIL Phone;
run;
/* eliminate multiple entries */
proc sort data=smf.cur_user nodupkey;
by user_id;
run;
/* export user including contact data to excel */
PROC EXPORT data=smf.cur_user
DBMS=excel2007
OUTFILE="&workspace.\All-Users-&assigned_year._mail.xlsx" REPLACE;
run;
Again.....this code runs 4 times.....before each execution SAS connects to another remote host to collect data (closing endrsubmit before continuing pc processing).....
....the excel sheet "cur_user" is only updated the first time the code runs.
Do you guys have any hints and tipps reagarding this strange problem!?
Environment:
- Windows 7 64bit
- SAS 9.2
- Excel 2007
greetings
