BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Gieorgie
Quartz | Level 8

I would like my data that is created in SAS to be imported into Excel rounded to two decimal places, I tried with proc export, now by ods excel, but still the numbers have many decimal places. these are my codes

 

proc sql;
    create table COREP_CR_&gv_tbl_date as
	select distinct
	a.DATA_DANYCH as REPORTING_DATE,
	"" as ID,
	sum(a.EXP_PIERWOTNA_NETTO) as  EAD_PRE_CCF format=9.2,
    sum(a.KOREKTA) as  PROVISION format=9.2,
	group by 
	a.EXP_PIERWOTNA_NETTO
	a.KOREKTA
	;
	quit;
ods excel file="&glb_path2./reports/mth_ak/COREP_CR_&gv_tbl_date..xlsx" 
;
 
proc print data=COREP_CR_&gv_tbl_date; 
run;
 
ods excel close;
1 ACCEPTED SOLUTION

Accepted Solutions
yabwon
Onyx | Level 15

Formats do not round, thy just "display rounded".

Use Round() function, e.g.

round(sum(a.EXP_PIERWOTNA_NETTO), 0.01)

Bart

 

_______________
Polish SAS Users Group: www.polsug.com and communities.sas.com/polsug

"SAS Packages: the way to share" at SGF2020 Proceedings (the latest version), GitHub Repository, and YouTube Video.
Hands-on-Workshop: "Share your code with SAS Packages"
"My First SAS Package: A How-To" at SGF2021 Proceedings

SAS Ballot Ideas: one: SPF in SAS, two, and three
SAS Documentation



View solution in original post

2 REPLIES 2
yabwon
Onyx | Level 15

Formats do not round, thy just "display rounded".

Use Round() function, e.g.

round(sum(a.EXP_PIERWOTNA_NETTO), 0.01)

Bart

 

_______________
Polish SAS Users Group: www.polsug.com and communities.sas.com/polsug

"SAS Packages: the way to share" at SGF2020 Proceedings (the latest version), GitHub Repository, and YouTube Video.
Hands-on-Workshop: "Share your code with SAS Packages"
"My First SAS Package: A How-To" at SGF2021 Proceedings

SAS Ballot Ideas: one: SPF in SAS, two, and three
SAS Documentation



Gieorgie
Quartz | Level 8
Thanks ! its working ! I have last quesiton, can i use proc export and use dbms like xlsx or keep ods excel ?

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to Concatenate Values

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.

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
  • 2 replies
  • 412 views
  • 1 like
  • 2 in conversation