I sent out the last message accidentally. That was what I ran. Were the outputs expected? I thought I would expect 'Hello' with the nobomfile option but I'm not. Is that correct? Thanks again Tom!
... View more
Thanks again, Tom. Below is what I ran and the output from the put statement. I sent to the vendor the file I produced using 'options nobomfile' to verify. Will let you know how it went. Code: options nobomfile ; data _null_; file "mypath\myfile.csv" encoding=utf8; put 'Hello.'; run; data _null_; infile "mypath\myfile.csv" recfm=n ; input x :$char8. ; put x $hex8. ; stop; run; Output: 48656C6C Code: options bomfile ; data _null_; file "mypath\myfile.csv" encoding=utf8; put 'Hello.'; run; data _null_; infile "mypath\myfile.csv" recfm=n ; input x :$char8. ; put x $hex8. ; stop; run; Output: EFBBBF48
... View more
Thanks, Tom. I tried your code and it worked. My problem is, I'm outputting a file to a vendor. They said there is BOM in my file. I was able to see the values (which I was unable to see from csv) using your code; however, how do I ensure the output file does not contain the BOM so the vendor could load in my output file correctly? Many thanks again!
... View more
Many thanks, Tom. I have tried the code, which works. My problem is that I'm outputting a file for a vendor. They said that my file has a BMO. In your code, I think I was able to see the values but how should I output the file without producing BMO so the vendor could load the file correctly? Thanks again!
... View more
Hi, I used a file statement to output a file in csv format and the client claims that they see BOM in front of the first variable. They need the file in uft-8 format as well. The first variable is a char of name. Below is the query I used. Could someone please help me figure out how to remove the BOM from the output? data _null_; set xx; file "mypath\myfile.csv" dlm=',' encoding='utf-8' ; if _n_=1 then put list of variables... ; run; Thanks!
... View more