Try this...   data _null_; today=today(); format today MMYYN4.; PUT TODAY; run; Hope this helps. ... View more

Try ths.....   proc sql; create table want as select id, month, is_valid, max(is_valid) as is_valid_now from HAVE group by id; quit; Note that i created a new variable is_valid_now for you to see what happened.  You can change this to select id, month, max(is_valid) as is_valid   Hope this helps, kabayan? ... View more

Try this one...   proc sql; create table jan.unallocated as select EVENT_DT, DIVISION_NM, BRANCH_NM, PROGRAMME_NM_CT, CENTRE_TYPE, LOGON_ID, EMPLOYEE_NAME, TOTAL_CALLS, WORK_TIME from Data.Employee_Telephony where Event_DT between '01Jan2017.'d and '31Jan2017.'d and Logon_ID in ( select strip(distinct Employee_ID) from work.janunique) ; quit;   Hope this helps. ... View more

Its the sequence of the statements.   1. First sas read amount=4 2. Next SAS read and executed your first if statement (amount=4).  Given that the condition has been satisfied the assingment statement was executed. 3. Lastly, sas encountered another assignment statement that overwrites the previous value (amount=4) and set it to 7. ... View more

Try this....     %let Var1 = Name sex race occp; %let Var2 = Name age sex salary race country; data STRING1 (keep=string1 where=(string1 is not missing) ) STRING2 (keep=string2 where=(string2 is not missing) ); VAR1=upcase("&var1"); Var1wc=countw(var1); var2=upcase("&var2"); var2wc=countw(var2); do i=1 to max(var1wc,var2wc); length string1 string2 $32; string1 =scan(var1,i," "); string2 =scan(var2,i," "); output; end; run; proc sql noprint; select coalescec(string1 ,string2 ) into: var3 separated by " "; from WANT A , WANT B where string1= string2 ; quit;   Hope this helps. ... View more

Here is a better version.   Try this....   data WANT; set HAVE; where indexc(var,"*"); char_used=ifc(find(var,"H *",1),"H *","L *"); run; Since when a record has an "*" the values are either "H *" or "L *".   If you just want those records containing "H *" or "L *" then remove the assignment statement for char_used.   Hope this helps. ... View more

data want; set have; where indexc(var,"*"); chars=catx(" ",scan(var,-2" "),scan(var,-1," ")); run; ... View more

What's next after you have flagged records with "*"?     INDEXC - i think this is limited to just a character you can google it.   Try this....   data want; set have; where indexc(var,"*"); chars=catx(" ",scan(var,-2" "),scan(var,-1," ")); run; Hope this helps. ... View more

Try this.... data WANT; set HAVE; where indexc(var_char,"*"); run;   Hope this helps. ... View more

Try this...   First let me build a sample data. data have; do y=2016 to 2018; do m= 1 to 12; recruit_dt=mdy(i,1,y); format recruit_dt date9.; end; end; run; Second - remove records below 01Feb2017 like this data have (where=(recruit_dt >= '01Feb2017'd)); do y=2016 to 2018; do m= 1 to 12; recruit_dt=mdy(i,1,y); format recruit_dt date9.; end; end; run; Third compute the month. data have (where=(recruit_dt >= '01Feb2017'd)); do y=2016 to 2018; do m= 1 to 12; recruit_dt=mdy(i,1,y); month=intck('month','01Feb2017'd,recruit_dt); format recruit_dt date9.; end; end; run; Notice that month=0 for 01Feb2017?  We correct that using this..   data have (where=(recruit_dt >= '01Feb2017'd)); do y=2016 to 2018; do m= 1 to 12; recruit_dt=mdy(i,1,y); month=intck('month','01Feb2017'd,recruit_dt)+1; format recruit_dt date9.; end; end; run; The last dataset should help you do this one.   Hope this helps. ... View more

Amen PTLA (Praise The Lord Almighty).   You have a blessed day and coming weekend  jjadall1 ... View more