BookmarkSubscribeRSS Feed
Ravikumarkummari
Quartz | Level 8

Good day all,

i have the dataset of emp data.

its having different formats for salary variable. comma and percent format.

so i  apply proc format for that.

PROC FORMAT;

VALUE FMT

  LOW-0,1-HIGH=[COMMA32.]

  OTHER=[PERCENT8.1]

  ;

RUN;

empno     salary

aaa          1,52,133

bbb          2,50,111

aaa          25%

bbb          50%.

in proc report its showing as it is. but while exporting it into excel only percentages format is applying. the comma format is missing.

after export into excel the output like this.

empno      salary

aaa     152133

bbb     250111

aaa     25%

bbb     50%

how to get the required output with applying comma and percentage format.

your valid comments are helps me a lot.

Thanks.

7 REPLIES 7
Ravikumarkummari
Quartz | Level 8

Instead of writing in excel while exporting only the format is there.

is it possible any sufficient method is there.

Ravikumarkummari
Quartz | Level 8

if there is two records then it is possible to manual entry. but when its contain thousands of records manual is not possible.

while exporting only the format is apply.

Ravikumarkummari
Quartz | Level 8

Can any One know the answer for this please comment.

Thanks in Advance.

Ksharp
Super User

You need special style for excel .

Post it at ODS and Base Reporting  Cynthia will give you answer.

sas-innovate-2024.png

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.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 7 replies
  • 851 views
  • 0 likes
  • 3 in conversation