topic Re: sas functions in SAS Programming

sas functions

LineMoon — Thu, 09 Feb 2017 22:06:37 GMT

Hello,

Please, I would why when we call some sas function (ex: upcase, lowercase, ...) , sas sends an error message, it does not regonize the function. why ? and how can we identify the main raison for the matter ? is it a question of package ?

Re: sas functions

mkeintz — Thu, 09 Feb 2017 22:17:36 GMT

Example, with log please.

Re: sas functions

Reeza — Thu, 09 Feb 2017 22:26:22 GMT

Because it's not a valid function in the manner you're trying to use it.

SAS functions are upcase and lowcase (low vs lower). SAS SQL allows upper/lower to work to convert case as well, but those won't work in a data step.

FEDSQL has a set of specific functions available.

IML has a different set of functions.

SAS SQL has a few different ones as well.

If you're using SQL Pass Thru you need to use the native DB functions, ie Oracle or T-SQL.

If you try to use an IML function in SAS SQL its not going to work, except there are overlaps. For example up until 9.4 the median function worked in PROC SQL but wasnt' what you expect.

Find the relevant sections of the docs and bookmark them for reference.

Re: sas functions

LineMoon — Thu, 09 Feb 2017 22:33:42 GMT

@ll: Thank you all.

I think, it can be a question of prfil or sas package ?

So, how can we check , if the function existes ? and why it does not existe ?

Re: sas functions

Reeza — Thu, 09 Feb 2017 22:43:13 GMT

Read the documentation.

Re: sas functions

LineMoon — Thu, 09 Feb 2017 22:49:24 GMT

which one ?

Re: sas functions

Kurt_Bremser — Thu, 09 Feb 2017 22:59:30 GMT

Just google sas function functionname.

It's really that easy.

Re: sas functions

Reeza — Thu, 09 Feb 2017 23:01:20 GMT

Out of curiosity do you think I have that location memorized? No, To find it I would have to search and then post it. You'll do yourself a massive favour learning how to navigate the SAS Docs. I recommend starting with finding the SAS Base functions list and navigating that. Make sure its correct for your version of SAS. If you use 9.4 docs but have SAS 9.2 thats not going to help you. Or SAS has the help menu installed as well. Using the internal doc means it's guaranteed for your system.

Re: sas functions

LineMoon — Thu, 09 Feb 2017 23:11:05 GMT

@Kurt_Bremser that does not reply to my question

You can take an example with

https://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000245965.htm

Re: sas functions

ballardw — Thu, 09 Feb 2017 23:18:37 GMT

Start by running this code:

proc format library=work;
value poorothergrp
0 -<14 ='Top'
14 - 30='Bottom';
run;

Which will give the names of currently available functions and some other info.

There may be some that are in the result that aren't generally documented or apply to products that you don't have licensed or only apply to some operating systems

Re: sas functions

Reeza — Thu, 09 Feb 2017 23:36:30 GMT

@LineMoon wrote:

@Kurt_Bremser that does not reply to my question

You can take an example with

https://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000245965.htm

That's an example of what?

Please take the time to fully explain your questions. This type of back and forth is a waste of time and not productive in any manner, besides people responding 'Go google it' because its that basic. If you can't take the time to ask a question clearly, at some point it's not worth our time to answer it.

Re: sas functions

LineMoon — Fri, 10 Feb 2017 07:48:07 GMT

@ballardw : Thank you

Until now, I do not know see that ?, when I use this code

proc format library=work;

value poorothergrp

0 -<14 ='Top'

14 - 30='Bottom';

run;

data test;

v=3;

y=max(7,8);

run;

proc format

library = work;

select poorothergrp;

run;

Re: sas functions

Kurt_Bremser — Fri, 10 Feb 2017 09:11:24 GMT

@LineMoon wrote:

@Kurt_Bremser that does not reply to my question

You can take an example with

https://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000245965.htm

If the documentation of a function/call routine does not mention a special SAS module or has a "valid in" restriction, then the function/call routine in question is part of Base SAS and can be used anywhere SAS functions/routines can be used in a syntactically correct way.

BTW testing always trumps everything else. Use a function and look at the log. If you get an ERROR, consult the documentation. If that does not give you a clue, come back with that specific problem here, but don't pester the forum with unspecific and outright silly questions.

Re: sas functions

ballardw — Fri, 10 Feb 2017 16:03:48 GMT

@LineMoon wrote:

@ballardw : Thank you

Until now, I do not know see that ?, when I use this code

proc format library=work;

value poorothergrp

0 -<14 ='Top'

14 - 30='Bottom';

run;

data test;

v=3;

y=max(7,8);

run;

proc format

library = work;

select poorothergrp;

run;

Are you attempting to get the description of the format? You need to tell the procedure which catalog to look at.

Perhaps you are wanting:

proc format library = work fmtlib;
  select poorothergrp;
run;

to use the default FORMATS catalog in the work library.

Re: sas functions

LineMoon — Fri, 10 Feb 2017 21:12:01 GMT

@ballardw :

thank you.

proc format library = work fmtlib;

select poorothergrp;

run;

So, I have used it, I see in "result", the format of poorothergrp.

But, I do not get the informations about the functions : max,...

Re: sas functions

Reeza — Fri, 10 Feb 2017 21:29:44 GMT

SASHELP.VFUNC

If you ever want listings of something look at the SASHELP tables.

Re: sas functions

ballardw — Fri, 10 Feb 2017 23:27:38 GMT

@LineMoon wrote:

@ballardw :

thank you.

proc format library = work fmtlib;

select poorothergrp;

run;

So, I have used it, I see in "result", the format of poorothergrp.

But, I do not get the informations about the functions : max,...

what are you looking for? You haven't said. Proc FORMAT will only return information about FORMATS, not functions. The code for the dictionary.functions, save as sashelp.vfunc, lists the names of valid functions and a little bit about it, not syntax or behavior. That is what documentation contains. You might try looking at your online help from SAS for Base SAS and functions

Re: sas functions

Reeza — Fri, 10 Feb 2017 23:48:20 GMT

@ballardw I think the code you posted may have been intended for another question. Proc Format doesn't come into play when searching for functions.

The documentation is the source of truth, bible, gold standard, etc.

Re: sas functions

art297 — Sat, 11 Feb 2017 00:25:49 GMT

Could you provide one example, including the code you ran and the error you received?

Art, CEO, AnalystFinder.com

Re: sas functions

LineMoon — Sat, 11 Feb 2017 12:01:32 GMT

@art297

It was about the function UPCASE.

It can be a restrution made by the administrator.