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-white.png

Special offer for SAS Communities members

Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.

 

View the full agenda.

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