Have year name sales 2001 john 1000          jack 2000 2002 john 3000          jack 4000   Want year name sales year name sales 2001 john 1000 2002 john 3000  2001 jack 2000 2002 jack 4000   How can I get the above output in excel ? please check have and want tables. ... View more

We have a requirement to enclose a variable values in double quotes and output a txt file. To do that we have used quote function and also quote format. They look fine in the SAS but when we output using proc export its giving the 3 double quotes instead of single double quote before and after the variable value. We are using the below code as example: data fr; set sashelp.cars; /*format model quote.;*/ model=quote(model); run;   filename test 'path\T1.txt' ; proc export data = fr outfile = test DBMS=tab REPLACE; run;   Expected variable value- "value" Quote function result -"""value" Quote format result-"""value""" ... View more