topic CSV font control in SAS Health and Life Sciences

CSV font control

konchada — Wed, 13 Jul 2011 19:53:24 GMT

Hi, Friends,

How to control/change the default font when you export a SAS data set to a CSV file. I have the below code:

ods tagsets.CSV file = "..\pkdata\test.csv" style = Printer ;
proc print data=pkdata noobs label;

run;

ods tagsets.csv close;

Thanks in advance.

CSV font control

Doc_Duke — Thu, 14 Jul 2011 02:49:55 GMT

CSV files, by definition, do not have any associated font. There is nothing to change. The font used to display the information is totally up to the application used.

CSV font control

konchada — Thu, 14 Jul 2011 05:05:35 GMT

Hi Doc,

Thanks much for the reply. Just to make sure, right now I get a font size of 8 and I want to make it 10, but I can’t right? I tried doing it the way we do it with excel (redefining the style using Proc Template) which dint work!

Thanks again.

CSV font control

Doc_Duke — Thu, 14 Jul 2011 12:57:57 GMT

Right, the font is being controlled by the tool that you are using to display the information and is not something that is contained in the .CSV file itself.

CSV font control

DouglasMartin — Thu, 14 Jul 2011 14:39:07 GMT

If you want an illustration of what Doc@Duke is getting at, right-click on one of your .CSV files in Windows, choose Open With, and open it in Notepad instead of Excel. You will see that there is NO formatting information; it just contains comma-separated data.

CSV font control

konchada — Thu, 14 Jul 2011 16:04:03 GMT

Got it. Thanks a lot !

CSV font control

konchada — Thu, 14 Jul 2011 16:05:13 GMT

Thanks again Doc.