The SAS Output Delivery System and reporting techniques

Point as thousand seperator in (NL) excel (and comma for decimals)?

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 89
Accepted Solution

Point as thousand seperator in (NL) excel (and comma for decimals)?

Dear all,

I am using  PROC PRINT with ODS TAGSETS.EXCELXP  on mainframe to create an XLS.

On SAS mainframe I always use format commax15. for printing amounts in European way.

However when I download the created XLS to PC, all my amounts have comma's as thousand seperator ??!!

How to resolve this?

I tried with STYLE  like I saw in some examples but without succes?

Regards,

Herman (BELGIUM)


Accepted Solutions
Solution
‎11-29-2011 11:11 AM
PROC Star
Posts: 7,360

Point as thousand seperator in (NL) excel (and comma for decimals)?

Herman,  Does the follow thread provide what you need? http://communities.sas.com/message/110231

It was regarding using the commax format with proc tabulate and ods tagsets excelxp, but might contain sufficient clues.

View solution in original post


All Replies
Solution
‎11-29-2011 11:11 AM
PROC Star
Posts: 7,360

Point as thousand seperator in (NL) excel (and comma for decimals)?

Herman,  Does the follow thread provide what you need? http://communities.sas.com/message/110231

It was regarding using the commax format with proc tabulate and ods tagsets excelxp, but might contain sufficient clues.

Frequent Contributor
Posts: 89

Point as thousand seperator in (NL) excel (and comma for decimals)?

Using  commax15.2 did the job!!

H.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 338 views
  • 0 likes
  • 2 in conversation