01-12-2018 03:16 PM
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(¶m1, ¶m2,...,¶mn); 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;
01-12-2018 05:05 PM
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.
01-12-2018 06:02 PM
Group concatenation is also on other SAS users wish list. Please check the following SASware Ballot idea:
and vote for it!