I need to apply sum function to a character data type from a sas data set using PROC SQL. I am trying to use cast and to_number but gives me a error message "needs a numeric argument for sum function
the code is something like this.
Connect to oracle.....
create table WORK.xx as
( SELECT "xyz" as File_name,
Count(*) AS members,
sum(yy_AMT) as yy_AMT
where yy_amt was defined as charecter data type in work.zzz dataset.
I did not understand your question. But from what I understood. Yes I am using PROC SQL and connecting to oracle and the select statement is in the SQL syntax.What did you mean by your question? What are you trying to hint?Let me know. So, that I can think on the correct lines.