I have a macro variable, Nums
, which has a list of values i.e 101, 102, 103, 104, 105
. I have a SAS dataset which has various columns, one of which is a date column. I need to add the Nums
macro variable to this SAS dataset as a column. Below is the code I have used to generate a macro variable list. Not sure how to proceed further.
PROC SQL;
SELECT ID
INTO IDs seperated by ',' FROM Datatable;
QUIT;