banishurface 发表于 2015-11-27 23:43 
/*将一个数据集中的每一个观测单独生成一个txt文件*/
/*dataset:逻辑库名.数据集名,例如work.a ,outpa ...
Book1是我的原数据集,我在代码前边加了这些
libname lib "E:\";
PROC IMPORT out=lib.out1
datafile="E:\Book1.xlsx"
dbms=excelcs replace;
run;
data lib.out2;
set lib.out1;
format test $ 100.;
test=catx('","','"name',name,'id',id,'var1',var1,'var2',var2);
keep test;
run;
一起运行后每一条观测的确是生产了单独的文档,但格式还有点小问题,这是运行结果
test
"""name"",""王一"",""id"",""320100198706010945"",""var1"",""0"",""var2"",""1"
想要把变量名“test”去掉,且只有一个双引号,就是像下边这样,请问该怎么改啊?
"name","王一","id","320100198706010945","var1","0","var2","1"