@xd9813 wrote:
Quotes work, I tested. Excel does not truncate data if surrounded by quotes. Thanks
If you are careful HOW you open the file then you can prevent Excel from interpreting strings as numbers or dates, whether the quotes are there are not has never made any difference in my experience. I have never heard of Excel truncating any values, but it did use to have a problem with writing long strings in a single cell, but that was decades ago. Does you data have long strings?
Here is simple SAS program to dump a dataset to a CSV file with every value in quotes, like the %ds2csv() macro does.
First let's set up an example dataset and target filename.
data test1;
set sashelp.class(obs=3);
run;
filename csv3 temp;
Now here is the code. One PROC and two data steps. The PROC is to get the names. If you don't need the header row then just use the last data step without the MOD option on the FILE statement (unless you want to append to an existing file). The tilde modifier on the PUT statement is what is adding the quotes. If you remove that then the DSD option will only add the quotes where they are NEEDED.
proc transpose data=test1(obs=0) out=names ;
var _all_;
run;
data _null_;
file csv3 dsd ;
set names end=eof;
put _name_ ~ @ ;
if eof then put;
run;
data _null_;
file csv3 dsd mod;
set test1;
put (_all_) (~);
run;
Let's take a look at the results:
157 data _null_;
158 infile csv3;
159 input;
160 put _infile_;
161 run;
NOTE: The infile CSV3 is:
Filename=.../#LN00050,
Owner Name=...,Group Name=...,
Access Permission=-rw-rw-r--,
Last Modified=27Apr2020:19:06:53,
File Size (bytes)=128
"Name","Sex","Age","Height","Weight"
"Alfred","M","14","69","112.5"
"Alice","F","13","56.5","84"
"Barbara","F","13","65.3","98"
NOTE: 4 records were read from the infile CSV3.
The minimum record length was 28.
The maximum record length was 36.
