Hello everyone, If I have a macro variable and I would like to put quotation marks around it, is there a function to do this? Thanks   Example: Have: %let ppl= 001-001 001-002; Want:  "001-001" "001-002"     ... View more

Hello, I have what appears to be an easy question but am getting an error. Perhaps you can help: Below is an example--I want to subset dataset x based on pt variable common only in dataset y. I want to do this using a macro variable (I realize there are many ways to do this but I just want to do it this way)...Can you help with the error? data x; input pt ht; datalines; 1001 100 1002 32 1003 42 1004 93 ; data y; input pt; datalines; 1003 1003 1001 ; proc sql noprint;      select distinct(pt) into :ids separated by ','      from y; quit; data x2;      set x;      if pt in &ids then output; run; I get an error message for the last datastep...Any ideas why? Thanks very much for reading! ... View more

Hello everyone, I am a relatively new SAS programmer and have what appears to be a rather basic question: I am trying to execute a SAS macro that I have written in a datastep. To do that, you use the call execute command. The one issue that I am encountering is that I dont get the results I am looking for. I think the problem lies with the fact that macros exucute during the compile phase whereas the datastep is run during the execution phase. So what I want is for the macro to run in the execution stage not the compile stage. Below is very simple example code I wrote: (Note:I realize I can do this many many ways including SQL, merge etc), but I really am only interested in doing this the macro iterative way...more from a learning perspective. Appreciate your help! data x; input pt $ wt; datalines; 1001 120 1002 244 1002 246 1003 145 1004 241 ; data y; input pt; datalines; 1002 1003 1005 ; %macro search(id); proc sql; select mean(wt) into :result from x where pt="&id"; quit; %mend search; data y2; set y; call execute('%search(id='||pt||')'); wt=symget('result') run; ... View more