In the following code, I want the macro variable _SOURCE_CD to resolve it as missing. Also I don't wish explicitly create that macro variable with missing before I call this macro variable. Could you please help me to resolve this?    %let _LEGAL_CD=RMN; data l; lel=compress(COALESCEC("&_SOURCE_CD.","&_LEGAL_CD.")); call symput('lel',lel); run; Log:     26 %let _LEGAL_CD=RMN; 27 28 29 data l; 30 lel=compress(COALESCEC("&_SOURCE_CD.","&_LEGAL_CD.")); WARNING: Apparent symbolic reference _SOURCE_CD not resolved. SYMBOLGEN: Macro variable _LEGAL_CD resolves to RMN 31 call symput('lel',lel); 32 run; NOTE: The data set WORK.L has 1 observations and 1 variables. Output:   lel &_SOURCE_CD.   Desired Output:   lel RMN ... View more

Could you please help me understand why the below INSERT INTO code is not working as excepted? I know that it will work if I code the WHERE after select clause but I would like to know why it is not working if I code before SELECT. How to make this work?   /* dataset 1*/ data have1; input name $ age; datalines; bill 20 sam 10 ram 30 ; /* dataset 2*/ data have2; input name $ age; datalines; bill 20 raj 40 ; /* create a temp table*/ proc sql; create table have3 as select * from have1 where trim(name) not in(select trim(name) from have2); quit; /* then insert into final table only age eq 20*/ proc sql; insert into have2(where=(age=20)) select * from have3; quit; ... View more

Assume I have a variable called FLAG (character variable) for which I have to pass values as follows.   A. First 10 obs should have value 'O' B. Next 10 obs should have value 'MODO' C. Last 10 instead should have missing values ' '   E.g. FLAG O O O .. . MODO MODO .. . .           Any help in providing me the data step for this?  ... View more