topic Re: question with PCTLPTS in SAS Programming

question with PCTLPTS

Geo- — Thu, 15 Nov 2018 06:09:34 GMT

Anyone knows what's wrong with "PCTLPTS" here?I want to print 10%,20%...to max.

How to fix?

%macro get(type);
proc univariate data=comp_acct_change;
	var dif_&type._amt;
	output out=p_dif_&type._amt PCTLPTS=0 to 100 by 10;
run;
%mend;

%get(purc);

Re: question with PCTLPTS

SASKiwi — Thu, 15 Nov 2018 06:30:15 GMT

When posting a problem provide as much evidence as you can. In this case you haven't provided a SAS log of your program including any notes and errors. Also run your program with this statement: options mprint; It will make it easier to find where it is going wrong.

Re: question with PCTLPTS

Geo- — Thu, 15 Nov 2018 07:06:35 GMT

sorry.I was running on a Korean version and log was not in English...I am wondering this problem is more about SAS syntax？

Re: question with PCTLPTS

SASKiwi — Thu, 15 Nov 2018 07:13:12 GMT

I think you might have to add the PCTLPRE = option to your OUTPUT statement as well:

https://documentation.sas.com/?docsetId=procstat&docsetTarget=procstat_univariate_syntax21.htm&docsetVersion=9.4&locale=en