Hello everybody,   I tried to copy files from SAS to a WebDAV server via filename webdav. The WebDAV server is not registered in SAS Management Console. I cannot get a connection to the server and do not know why. I get the ERROR: ERROR: No logical assign for filename OUTPATH. Please find here the code I used to try:   options msglevel=i; /*authdomain="Defaultauth"*/ filename inpath '/usr/local/....test.txt'; filename outpath webdav "https://webdav.xxxx.de:8443/webdav/" debug user="xxxx" pass="xxxx"; data _null_; length msg $ 384; rc=fcopy('inpath', 'outpath'); if rc=0 then put 'Copied SRC to DEST.'; else do; msg=sysmsg(); put rc= msg=; end; run; /* messages in log */ Collection handle creation failed. ERROR: No logical assign for filename OUTPATH. ERROR: Error in the FILENAME statement. rc=10005 msg=ERROR: Open failed for file OUTPATH . - is it at least possible, what I am trying to do on this way? - or is there another possibility to reach the aim under this circumstances (proc http ...)? Any help is appreciated, regards Catrin ... View more

Hello to everybody,   We need to send .csv data with national character data via email to our customer  in encoding  utf-8. We are working with SAS  9.4M4 on Linux. The default encoding of the session is latin9. I am using Enterprise Guide 7.1 via terminal server. My tests fail up to now. What I did is, to transcode the data from latin9 to utf-8. This works fine. But when using the .csv - file as attachment, the incoming email-attachment in Lotus Notes has lost the encoding  and also has lost data. I control the resulting data in Ultraedit. Please find my code attached  here. Any idea to solve the problem is very welcome. The testdat.csv just after creating is attached and also the data after sending via email as testdat_send.csv /* creating data for test */ data testdat; input name :$10. ort :$10.; datalines; Böger Hamm Müller Münster Änder Steinfurt Münig Holdorf Bäger Hamm Mäller Münster Ünder Steinfurt Mänig Holdorf Büger Hamm Möller Münster Önder Steinfurt Mönig Holdorf ; run; /*transcoding data to utf-8 encoding*/ filename output '/u/m500381/testdat.csv' encoding="utf-8"; proc export data=testdat outfile=output dbms=csv; delimiter=';'; run; /*Opening the data in Ultraedit shows correct encoding and complete data */ /* Now sending data as attachment */ filename mailaus email to=('c.skamira@lvm.de') subject='CSV Attachment' from='Catrin' type='text/plain' attach=('/u/m500381/testdat.csv' encoding='utf-8' outencoding='utf-8' ); data _null_; file mailaus; put 'Testdat UTF-8'; run; /* the log seems to be ok */ NOTE: The file MAILAUS is: E-Mail Access Device Message sent To: 'x.sssssssss@xx.de' Cc: Bcc: Subject: CSV Attachment Attachments: ( '/u/m500381/testdat.csv' ENCODING = 'utf-8' OUTENCODING = 'utf-8' ) NOTE: 1 record was written to the file MAILAUS. The minimum record length was 13. The maximum record length was 13. NOTE: DATA statement used (Total process time): real time 0.16 seconds cpu time 0.00 seconds After sending the email,only this data are included in  .csv file: name;ort Böger;Hamm Müller;Münster Änder;Steinfurt and Ultraedit shows encoding ISO-8859-1. The file has 50 bytes. Before sending the file has 195 bytes and Ultraedit shows utf-8 as encoding. Kind regards Catrin ... View more

Hallo, we use MSOffice2k tagset to create files using in Excel 2000. After migration to SAS 9.2 file sizes are much bigger. There are examples that the files get so big now, that Excel cannot read it. Looking into the generated HTML files we can find the reason for the file size differences. Is there an option to tell msoffice2k tagset to create the files like in Version SAS 9.1.3 ? Please find here an SAS-Code Example: ods listing close; ods markup file="/u/m500843/sassrc/msoffice2k_9-2.html" tagset=msoffice2k; proc freq data=sashelp.prdsale; tables COUNTRY*REGION*DIVISION*QUARTER*PRODUCT*PRODTYPE; run; ods markup close; ods listing; In SAS 9.1.3 the size is about 233 kb, in SAS 9.2. 633 kb Kind regards Catrin ... View more