DATA Step, Macro, Functions and more

PLSQL-like functions in PROC SQL or PROC FEDSQL?

Reply
Contributor
Posts: 71

PLSQL-like functions in PROC SQL or PROC FEDSQL?

I would like to be able to recreate the functionality of PLSQL functions in SAS.  Specifically a function that returns a table from a set of parameters.  Something like:

 

PROC SQL;
  SELECT *
  FROM myfunction(&param1, &param2,...,&paramn);
QUIT;

Would this be possible with PROC DS2 or PROC FCMP?

 

Would an aggregation function be possible?  For instance I have a column of strings with another column to indicate group and I want to concatenate them based on the group column.  Something like:

 

PROC SQL;
  SELECT myaggregationfunction(STRING_COLUMN)
  FROM mytable
  GROUP BY GROUP_COLUMN;
QUIT;
Super User
Posts: 3,761

Re: PLSQL-like functions in PROC SQL or PROC FEDSQL?

Posted in reply to tomcmacdonald

What is your use case? There may be a better way to approach your problem than in SQL. In Oracle you don't have so much choice, but in SAS you do.

Esteemed Advisor
Posts: 5,391

Re: PLSQL-like functions in PROC SQL or PROC FEDSQL?

Posted in reply to tomcmacdonald

Group concatenation is also on other SAS users wish list. Please check the following SASware Ballot idea:

 

https://communities.sas.com/t5/SASware-Ballot-Ideas/create-string-summary-functions/idi-p/288035

 

and vote for it! Smiley Happy

PG
Ask a Question
Discussion stats
  • 2 replies
  • 117 views
  • 0 likes
  • 3 in conversation