topic Re: ODS CSVALL: character "+" eaten in ODS and Base Reporting

ODS CSVALL: character "+" eaten

Pobel1 — Mon, 10 Jul 2023 02:11:20 GMT

Hi,

Here is an example using ODS CSVALL to convert SAS to CSV file:

data test;

x="aaaa"; output;

x="+1"; output;

x="Okay"; output;

run;

ods csvall file="test.csv";

proc print data=test noobs;

run;

ods csvall close;

And in the CSV file, the "+" sign is gone:

aaaa

Okay

Question: Is there a way to keep the "+" in the CSV file?

Thanks in advance!

Re: ODS CSVALL: character "+" eaten

Kurt_Bremser — Mon, 10 Jul 2023 06:33:59 GMT

How did you inspect the csv file? Do NOT open it with Excel, use a text editor.

Re: ODS CSVALL: character "+" eaten

Pobel1 — Mon, 10 Jul 2023 06:38:32 GMT

It's the same when using NOTEPAD to open the file:

Re: ODS CSVALL: character "+" eaten

yabwon — Mon, 10 Jul 2023 07:04:32 GMT

According to Maxim 1:

data test;
    x="aaaa"; output;
    x="+1"; output;
    x="Okay"; output;
run;
 
ods csvall file="test.csv" options(DOC="HELP" Quoted_columns="1");

title "Test title!!";
proc print data=test noobs;
run;
ods csvall close;

Bart

Re: ODS CSVALL: character "+" eaten

Kurt_Bremser — Mon, 10 Jul 2023 07:06:54 GMT

If your goal is to have a simple csv file, don't use ODS. Both of these methods work:

data _null_;
set test;
file "~/test1.csv";
if _n_ = 1 then put "x";
put x;
run;

proc export
  data=test
  file="~/test2.csv"
  dbms=csv
  replace
;
run;

And will perform MUCH better with larger datasets.

Re: ODS CSVALL: character "+" eaten

Pobel1 — Mon, 10 Jul 2023 10:01:27 GMT

Cool!!
Thank you Bart!

Re: ODS CSVALL: character "+" eaten

Pobel1 — Mon, 10 Jul 2023 10:03:03 GMT

Thanks!
Yes, both of the methods work. Just I also need to add a title to the CSV file.

Re: ODS CSVALL: character "+" eaten

Tom — Mon, 10 Jul 2023 12:29:53 GMT

That is a BUG in the CSVALL ODS destination. You should report it to SAS support.

Not only does it not generate the proper CSV file, it also seems to have some lasting impact on the normal HTML output used in the RESULT window in Display Manager.

If I run this code once:

data test;
    x="aaaa"; output;
    x="+1.0"; output;
    x="Okay"; output;
run;
filename csv temp;
ods csvall file=csv;
proc print data=test noobs;
run;
ods csvall close;

data _null_;
  infile csv ;
  input;
  list;
run;

The PROC PRINT displayed in the Results Window looks normal:

If I then run the same code a second time the Results output has switched to using some monospaces font. And the output looks like the output previously sent to CSVALL, with the missing + and the extra unneeded quotes around the other value.