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;
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 ..... ;
Also change the DLM option in your file statement.
Why not use proc export. It is simple.
proc export data=sashelp.class outfile='/folders/myfolders/x.txt' dbms=tab replace;run;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.