topic Re: Datastep cannot access degrees() and acos() functions: ERROR 68-185 in SAS Programming

Datastep cannot access degrees() and acos() functions: ERROR 68-185

charles_pignon1 — Fri, 17 Apr 2015 14:54:40 GMT

Hello,

I am unable to access the functions degrees() and acos() within the datastep. When I try to run them the following error message appears:

ERROR 68-185: The function DEGREES is unknown, or cannot be accessed.

ERROR 68-185: The function ACOS is unknown, or cannot be accessed.

Here is the code I used:

data hello;

testdegrees=degrees(.5);

testacos=acos(.5);

run;

Re: Datastep cannot access degrees() and acos() functions: ERROR 68-185

ballardw — Fri, 17 Apr 2015 15:00:07 GMT

I suspect you are looking for arcos instead of acos. What is the function Degrees supposed to do? There is no such function in SAS, which is what the error message is saying.

Re: Datastep cannot access degrees() and acos() functions: ERROR 68-185

charles_pignon1 — Fri, 17 Apr 2015 17:18:32 GMT

The degrees function should return the number of degrees for an angle in radians; here is a link describing it:

http://support.sas.com/documentation/cdl/en/fedsqlref/67364/HTML/default/viewer.htm#p1c8k83ftmqzbkn1ovjwzbi9m32p.htm

I tried arcos and it worked, though, so maybe I'm just not getting functions from the right place... Here is the link that I found describing the acos function:

Function Descriptions : acos

Re: Datastep cannot access degrees() and acos() functions: ERROR 68-185

Reeza — Fri, 17 Apr 2015 17:25:05 GMT

You're looking at the FEDSQL SAS 9.4 documentation for first link and the second is SAS 7 documentation I think.

What version of SAS are you on?

Re: Datastep cannot access degrees() and acos() functions: ERROR 68-185

charles_pignon1 — Fri, 17 Apr 2015 17:44:01 GMT

SAS (r) Proprietary Software 9.3 (TS1M0)

I had noticed the SAS (r) Proprietary Software 9.3 (TS1M0) mentioned, but I thought the functions would have the same names across procedures...

Re: Datastep cannot access degrees() and acos() functions: ERROR 68-185

Reeza — Fri, 17 Apr 2015 17:50:12 GMT

For PROC SQL they do, though some of the summary functions such as mean, min, max, sum, and median operate differently.

FEDSQL is almost a different language introduced in SAS 9.4. Also, each version will have new functions.

I like how the 9.2 documentation is laid out personally, but the 9.3 documentation is here

SAS(R) 9.3 Language Reference by Name, Product, and Category

You're looking for BASE SAS functions.

SAS 9.2 documentation

SAS(R) 9.2 Language Reference: Dictionary, Fourth Edition

Re: Datastep cannot access degrees() and acos() functions: ERROR 68-185

charles_pignon1 — Fri, 17 Apr 2015 18:01:24 GMT

Hello,

Thanks for that clarification. Unfortunately, there appears to be no equivalent to the degrees function I was looking for in the SAS datastep (based on the functions in the 'trigonometric' category). I should be able to get it elsewhere though. Thanks!

Re: Datastep cannot access degrees() and acos() functions: ERROR 68-185

Rick_SAS — Fri, 17 Apr 2015 18:13:53 GMT

degrees = radians * 180 / constant("pi");

Re: Datastep cannot access degrees() and acos() functions: ERROR 68-185

charles_pignon1 — Fri, 17 Apr 2015 18:46:11 GMT

This worked perfectly. Thanks!

Re: Datastep cannot access degrees() and acos() functions: ERROR 68-185

dkb — Sun, 19 Apr 2015 23:45:16 GMT

The link given for the ACOS function leads to the documentation for SAS's version of the C language.