BookmarkSubscribeRSS Feed
Ronein
Meteorite | Level 14

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;
1 REPLY 1
Amir
PROC Star

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-ou... 

 

It also mentions renaming variables to what is desired.

 

 

Thanks & kind regards,

Amir.

sas-innovate-white.png

Special offer for SAS Communities members

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.

 

View the full agenda.

Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1273 views
  • 0 likes
  • 2 in conversation