Hi All, Please let me know if Update and Delete statements works in Proc SQL in the temporary tables (#temp_studies) while connecting to database backend (Rave). I am trying to update and delete few rows in temporary tables created, but it is not working. Below is the syntax which i have used for delete statement. Proc Sql; %connect_to_rave(datasrc=&datasrc.); execute ( create table #temp (Subject nvarchar(4000), Subjectid int, Sex Nvarchar(100)); insert into #temp('Saketh', 101, ' ') delete from #temp where sex eq ' ' ) by sqlsvr; create table temp as select * from connection to sqlsvr(select * from #temp); execute ( drop #temp) by sqlsvr; quit;
... View more