You can't call a macro for every row in a data step.  The macros write code that is then executed.  Look at this call execute that will sets FLAG to equal which variable matched the values in the X.  Pay attention to the log.  It will show you the code that is actually generated.   DATA X; INPUT X$ Y$; DATALINES; X 2 Y 4 ; RUN; DATA Y; X="2";Y="0"; output; X="0";Y="4"; output; X="5";Y="3"; output; RUN; data _null_; set x end=finished; if _n_ = 1 then do; CALL EXECUTE('DATA NEW;'); CALL EXECUTE('SET Y;'); CALL EXECUTE('if 0 = 1 then FLAG="";'); end; CALL EXECUTE('else if ' || X || ' = "' || strip(Y) || '" then FLAG="' || strip(X) || '";'); if finished then do; CALL EXECUTE('else FLAG="N";'); CALL EXECUTE('run;'); end; run; ... View more

@Aman4SAS wrote: HI Sir,   Thanks for your reply.   I think i was not able to discribe my question   suppose  %let A=09DEC2017 now i want to create a date variable month in my date set . in normal sql what i am using simply "&A."d as month format date9. but at the same time when i using same code inside oracle passthrough its not working. to get the only vaule i can use single quote like '&A.' but i want it as datetype. how can i do that.   Please suugest That is a question for ORACLE.  It will not understand the date literal syntax that SAS uses.  You need to use a method that Oracle understands since you are sending the code directly to the database.  You might try '09-DEC-2017' which is a format you can generate with SAS using the DATE11. format.  Or look into the TO_DATE() function in Oracle that will let you tell it how to convert the string literal to a date. ... View more

Hi: These comments fit my issues - Thanks again Cynthia!!! ... View more

If that is the case then do data have; input id var1 var2 var3; datalines; 1 10 5 24 2 20 7 32 3 30 20 62 4 30 30 98 5 30 30 63 6 40 45 21 7 40 75 33 8 50 60 90 ; proc sort data=have; by var1-var3; run;   ... View more

@slchen It's a good habit to declare your variables as local. You'll save yourself many headaches. So this is a (slightly) better macro: %macro test/minoperator mindelimiter='|'; %local list part; %let list=13|14|15|25|26|27; %do part = 1 %to 30; %if &part in &list %then %put &=part; %end; %mend; %test; ... View more

proc sql; create table test as select a.*,b.*, cats(a.var1,put(b.var2,best.)) as var from a as a , b as b ; quit; ... View more

Making sample data that doesn't reflect your situation means having to answer your question twice.    Youll have to loop through the array then to find your first non missing value. You can use LEAVE to exit a loop.    VNAME can still be used to find variable name and _n_ for row number.     ... View more

  data test; input name $ age; datalines; a 1 a 2 a 3 A 1 a 4 A 3 A 2 ; run; proc print; run; proc summary nway data=test; format name $upcase.; class name; output out=nodupkey(drop=_type_ _freq_) idgroup(out(age--age)=); run; proc print; format _all_; run; ... View more