Hello everyone, I'm trying to automatically change the delimiter of a csv file that is in a certain path (in J:, the local server of my company) and leave it in the SAS server.   It turns out that when I run this code it works for me: data _null_; infile "/opt/sas/data/xxx/xx/xx/Folder1/xxxx.csv" dlm='|' dsd length=ll column=cc truncover ENCODING='utf-8'; file "/opt/sas/data/xxx/xxx/xxx/Folder1/Source/xxxx.csv" dlm='|' ; do until(cc>ll); input value ~ :$char32767. @; if missing(value) then value ='""'; put value :$char32767. @; end; put; run;   Since I take the csv file from a folder in J and put it in another folder in J like that, doesnt works: data _null_; infile "J:\xxxx\xxx\xxxxx\xxxxx.csv" dlm='|' dsd length=ll column=cc truncover ENCODING='utf-8'; file "/opt/sas/data/xxxx/xx/xxx/Folder1/Source/xxxx.csv" dlm='|' ; do until(cc>ll); input value ~ :$char32767. @; if missing(value) then value ='""'; put value :$char32767. @; end; put; run; The problem comes when I put a route in the infile that is in "J:", I get this error: "ERROR: Invalid open mode."   and this too: ERROR: Some code points were not transcoded. SAS ERROR: Some code points were not transcoded. SAS ERROR: Some code points were not transcoded. SAS But these I think is because of the encoding, even though I am saying that the encoding has to be utf-8. But I think the problem lies in the path and the invalid open error   Can someone shed some light on this for me? If you know another way to try to do what I'm doing with another method in SAS let me know, but I'm trying to automate the transformation of certain csvs in a flow and I need this step. Thank you very much in advance, greetings! ... View more

Hello everyone, I am trying to create a program to automatically download the attached files that are sent to us from a certain email and then transform the delimiter with SAS, of those csv that are attached to us and pass those csv through a flow that I have already created.   I have managed to create a program that treats the csv as I want and the delimiter that I want, the problem is that when it comes to automating the download of files from Outlook it does not work.   What I have done is create a rule with the following VB code that I found on the internet:   Public Sub SaveAttachmentsToDisk(MItem As Outlook.MailItem) Dim oAttachment As Outlook.Attachment Dim sSaveFolder As String sSaveFolder = "C:\Users\DT168\Documents\outlook-attachments\" For Each oAttachment In MItem.Attachments oAttachment.SaveAsFile sSaveFolder & oAttachment.DisplayName Next End Sub   website: https://es.extendoffice.com/documents/outlook/3747-outlook   The problem is that this code does not work for me, it does absolutely nothing for me and no matter how much I search the internet, only this code appears.   Is there any other way to do with SAS what I want? What is it to automatically download 8 csv files sent to me by Outlook, or has someone experienced the same thing as me with VBA? I have followed all the steps about 7 times so I think the error is not in copying the code or selecting certain options wrong, in fact I had copied and pasted the code and later I modified the path where I wanted those to be saved. files but it doesn't work, does anyone know why? I will be tremendously grateful, thank you very much for everything! ... View more