topic Re: Proc sql error in New SAS User

Proc sql error

ranikeka — Tue, 16 Mar 2021 09:27:47 GMT

Hi

I am using proc sql method for percentage calculation to generate table. First column group A and second column with group B and third column with total of A and B. The following error comes up could you please help how to solve this issue.

Proc sql;
Create table bytra as select
100*round(pt1/ys,0.01) as bytrapct,
100*round(pt2/ys,0.01) as bytrapct,
100*round(pt1/123, 0.01) as bytrapct,

From file1;
Quit;

Invalid or missing arguments to the round function have caused the function to return a missing value.

Many thanks for all the help.

Re: Proc sql error

yabwon — Tue, 16 Mar 2021 09:42:06 GMT

Please share some exemplary data so we can test your code.

Btw. the message says you have missing values in your data.

All the best

Bart

Re: Proc sql error

Kurt_Bremser — Tue, 16 Mar 2021 09:45:33 GMT

@ranikeka wrote:
Hi

I am using proc sql method for percentage calculation to generate table. First column group A and second column with group B and third column with total of A and B. The following error comes up could you please help how to solve this issue.

Proc sql;
Create table bytra as select
100*round(pt1/ys,0.01) as bytrapct,
100*round(pt2/ys,0.01) as bytrapct,
100*round(pt1/123, 0.01) as bytrapct,

From file1;
Quit;

Invalid or missing arguments to the round function have caused the function to return a missing value.

Many thanks for all the help.

Your code as posted will cause a syntax ERROR because of a surplus comma, and once that is corrected, it will cause a WARNING because you try to create the same variable three times.

The NOTE about missing values is caused by your data.

Re: Proc sql error

Sajid01 — Tue, 16 Mar 2021 14:09:30 GMT

Try this

Proc sql;
Create table bytra as

select
100*round(pt1/ys,0.01) as bytrapct1,
100*round(pt2/ys,0.01) as bytrapct2,
100*round(pt1/123, 0.01) as bytrapct3 /* I removed the comma here */

From file_1;

Quit;

Re: Proc sql error

ranikeka — Wed, 24 Mar 2021 18:12:42 GMT

Thanks 🙏

Re: Proc sql error

ranikeka — Wed, 24 Mar 2021 18:13:11 GMT

Thank you 🙏