PROC EXPORT-Column Labels instead of Column Name

Ronein — Wed, 27 Sep 2023 10:18:55 GMT

Hello

I am using proc export to export sas data set into tXT file.

I want to have in the txt file Column Labels instead of Column Names.

I opened the txt file via notepad and I see that columns headers are:

"Client_Name"
"Gender"
"Age"
"Height"
"Weight"

My question- Why do I see double markers (") on col headers?

What is the way to remove the double marks (")?

data Have;
Set sashelp.class;
if sex='F' then age=.;
label
Name='Client_Name'
Sex='Gender'
Age='Age'
Height='Height'
Weight='Weight'
;
run;

proc export data=Have
outfile="/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/Ron4.txt"
dbms=tab
label
replace;
run;

Re: PROC EXPORT-Column Labels instead of Column Name

Amir — Wed, 27 Sep 2023 11:03:09 GMT

Hi,

Have you tried removing the label option as per the solution in:

https://communities.sas.com/t5/SAS-Programming/How-to-remove-double-quotes-from-a-proc-export-CSV-output/td-p/687325/page/2

It also mentions renaming variables to what is desired.

Thanks & kind regards,

Amir.

topic PROC EXPORT-Column Labels instead of Column Name in SAS Programming

PROC EXPORT-Column Labels instead of Column Name

Re: PROC EXPORT-Column Labels instead of Column Name