BookmarkSubscribeRSS Feed
Bronwen
Calcite | Level 5

I'm working on a large dataset using SAS Viya. I'm trying to calculate the percentiles with a couple decimal points but it does not appear to be working correctly.  Does anyone have suggestions?

 

 

proc print data=stats1.finaldata1;
	format plc_cnt_no z3.2;
run;

proc univariate data=stats1.finaldata1;
	VAR plc_cnt_no;
	output out=pctls
		pctlpre=P
		pctlpts=33,80,90;
	informat plc_cnt_no z3.2;
run;

Capture.PNG

1 REPLY 1
PaigeMiller
Diamond | Level 26

If the data in variable plc_cnt_no is all integers, you may not get decimal places in your percentiles.

--
Paige Miller

Catch up on SAS Innovate 2026

Nearly 200 sessions are now available on demand with the SAS Innovate Digital Pass.

Explore Now →
Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 1493 views
  • 0 likes
  • 2 in conversation