topic Re: Comma Delimited to Tab Delimited in SAS Programming

Comma Delimited to Tab Delimited

Roddy — Thu, 31 Dec 2015 18:24:05 GMT

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;

Re: Comma Delimited to Tab Delimited

mohamed_zaki — Thu, 31 Dec 2015 18:55:30 GMT

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

Re: Comma Delimited to Tab Delimited

Reeza — Thu, 31 Dec 2015 18:54:28 GMT

Also change the DLM option in your file statement.

Re: Comma Delimited to Tab Delimited

Ksharp — Mon, 04 Jan 2016 02:46:00 GMT

Why not use proc export. It is simple.

proc export data=sashelp.class outfile='/folders/myfolders/x.txt' dbms=tab replace;run;