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

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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