Hi, i want to make something like this work in proc sql: proc sql; %connect_to_sql_macro; create table sql.table as ( select some_id, date from connection to oracle ( select some_id, date, row_number()over(partition by some_id order by date) as row from dataset d join sql_table s on d.some_id=s.some_id ) where row=1 Basically i need to create table in oracle based on dataset joined with oracle table and take the first date for each id. If i use "from oracle" pass through it doesn't see the dataset, if i make it the other way around i can't use window functions(row_number()) becouse they are not in SAS. For now i create a table from that dataset and then do a pass through but it's large and i need to do it in one go. Any suggestions?
... View more
