DATA Step, Macro, Functions and more

Comma Delimited to Tab Delimited

Reply
Occasional Contributor
Posts: 5

Comma Delimited to Tab Delimited

I need to change the below code from comma separated to tab separated. I am writing this code to a specific location and the name of the file needs to remain dynamic.

 

 

PROC FORMAT;
PICTURE mmddyyyy other ='%0m%0d%Y' (DATATYPE = date);
RUN;

 

DATA _NULL_;
CALL SYMPUT("TODAY_MDY",LEFT(PUT(today(),mmddyyyy.)));
RUN;

 

DATA _NULL_;
SET FINAL;
FILE "//DropBox/Ad Hoc/Location/Policies_&TODAY_MDY..txt" DLM=',' TERMSTR=crlf;
IF _N_ = 1 THEN DO;
PUT 'Date'
',' 'Name'
',' 'Email'
',' 'Description'
',' 'ProductSearchCode'
',' 'Policy'
',' 'MerchantIdentifier'
',' 'FeedbackDate'
',' 'Tags';
END;
PUT Date Name Email Description ProductSearchCode Policy MerchantIdentifier FeedbackDate Tags;
RUN;

 

 

Super Contributor
Posts: 490

Re: Comma Delimited to Tab Delimited

[ Edited ]

Define macro variable by the ASCII code

%LET TAB='09'X

Then use it in the put statment 

&TAB

 Or use it directly in the put statment 

Put ..... '09'X ..... ;

 

Super User
Posts: 17,831

Re: Comma Delimited to Tab Delimited

Also change the DLM option in your file statement.

Super User
Posts: 9,681

Re: Comma Delimited to Tab Delimited

Why not use proc export. It is simple.

 

proc export data=sashelp.class outfile='/folders/myfolders/x.txt' dbms=tab replace;run;
Ask a Question
Discussion stats
  • 3 replies
  • 192 views
  • 1 like
  • 4 in conversation