Is there a way to send a SAS dataset through a proc sql odbc query in SAS EG so that it can be taken in and used by SQL server? ex) SAS Data WORK.A contains 3 columns ID, col1, col2. I have a table in Sql Management Studio environment with the same ID column. I would like to (somehow) do
Tag: sas-macro
Using macros in SAS SQL
I am wondering of I can consolidate some code into one PROC SQL statement instead of several back-to-back SQL statements. I am using macro to calculate the age of a participant at date of consent for a study, similar to what is provided here and here. I tried to troubleshoot the functionality of macros, and I calculated the total weight