dear SAS experts,
using the following code:
proc sql;
create table docsref.Adresses_contacts as
select '' as Numero,
'FR' as LKZ,
PLZ,
ORT,
Clubs,
Anrede,
Vorname,
Nachname,
Funktion,
adresse_str_,
Tel_Fix,
Tel_Handy,
Email,
Website,
TYP,
KETTE,
Notiz,
R,
Stammart,
_2__email_adresse
from adresses_corr
order by PLZ;
quit;
run;
proc export data=docsref.Adresses_contacts
outfile=Adresses_contacts
DBMS=xlsx;
putnames=yes;
run;
I've got the error message:
1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
72
73 proc sql;
74 create table docsref.Adresses_contacts as
75 select '' as Numero,
76 'FR' as LKZ,
77 PLZ,
78 ORT,
79 Clubs,
80 Anrede,
81 Vorname,
82 Nachname,
83 Funktion,
84 adresse_str_,
85 Tel_Fix,
86 Tel_Handy,
87 Email,
88 Website,
89 TYP,
90 KETTE,
91 Notiz,
92 R,
93 Stammart,
94 _2__email_adresse
95 from adresses_corr
96 order by PLZ;
NOTE: Table DOCSREF.ADRESSES_CONTACTS created, with 1878 rows and 20 columns.
97 quit;
NOTE: PROCEDURE SQL a utilisé (Durée totale du traitement) :
real time 0.38 seconds
cpu time 0.43 seconds
98 run;
99
100 proc export data=docsref.Adresses_contacts
101 outfile=Adresses_contacts
102 DBMS=xlsx;
103 putnames=yes;
104 run;
Error creating temporary file for XLSX file -> /opt/sasinside/SASConfig/Lev1/SASApp//ADRESSES_CONTACTS.$$1 . It is either not an
Excel spreadsheet or it is damaged. Error code=8000101D
Requested Output File is Invalid
ERROR: Export unsuccessful. See SAS Log for details.
NOTE: The SAS System stopped processing this step because of errors.
How could I correct this?
... View more
