topic Proc export with labels removing quotes in SAS Programming

Proc export with labels removing quotes

Tiri6 — Thu, 02 Apr 2020 09:24:53 GMT

Hi,

i have a problem with proc export, labels and quotes.

I need to export a file with a ":" inside the header field.

Now i'm using the classic proc export:

PROC EXPORT DATA= example
OUTFILE= "path\example.csv"
DBMS=DLM LABEL REPLACE;
DELIMITER='2C'x;
PUTNAMES=YES;
RUN;

And this is what i have:

"example:1" , "example:2"

I just need: example:1 , example:2 without quotes but with the " : " inside the name of the field.

How can i do in order to export properly?

Thank you very much.

Marco

Re: Proc export with labels removing quotes

Kurt_Bremser — Thu, 02 Apr 2020 09:54:26 GMT

If you don't want quotes in the header row, write the data step yourself, or adapt the one that proc export created for you (take it from the log).

data have;
input example_1 example_2;
label
  example_1 = "example:1"
  example_2 = "example:2"
;
datalines;
1 2
3 4
;

data _null_;
set have;
file "/folders/myfolders/example.csv" dlm="," dsd;
if _n_ = 1 then put "example:1,example:2";
put example_1 example_2;
run;

Re: Proc export with labels removing quotes

Tiri6 — Thu, 02 Apr 2020 10:12:18 GMT

thank you very much. It was exactly what i needed. Have a nice day.