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

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register 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
  • 896 views
  • 0 likes
  • 2 in conversation