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;
Hi,
Have you tried removing the label option as per the solution in:
It also mentions renaming variables to what is desired.
Thanks & kind regards,
Amir.
Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.