Hello, I need some help with my program. I have a list of x therapies (thlist) in one variable. Now I want to create a macro variable (since thlist can change over time) that I can use in a dataset (data01) to exclude all data that has the therapy listet in thlist. So far i got this: *this is my therpylist; data thlist; set have; run; --> looks like this: var therapy 1 th1 2 th2 3 th3 ... *Now create a macrolist; data macrolist; set thlist end=last; call symput("norpt", therapy); if last then call symput("numnorpt", _n_); run; *%put total No of no reports: &numnorpt; *%put no report Therapien: &norpt1; Following step doesnt work! *replace hardcoding, creating macro; options mtrace mprint; %Macro norptlist; data norpt_&&norpt&i; set macrolist; %do i =1 %to &numorigins; where nr = "&&norpt&i"; %end; run; %Mend norptlist; %norptlist; When I have the macrovariable I want to delete all data that have the therapy listed in my macrolist: I would do this: DATA new; SET data; if therapy eq &&norpt&i then delete; RUN; Would appreciate some help on this. Thx
... View more