For character format like "02/01/2013", try ... new_date = input(character_date, ??MMDDYY10.) ; For charachter format like "20130506", try... new_date = input(character_date, ??YYMMDD10.) ;
... View more
Is this what you are looking for ? x2=compress(tranlate(x1,'_',' '), '~!@#$%^&*()+|}{[]\<>?'); x1=your original column x2=new output note : you could change the list of special characters you want to remove.
... View more
Since you do not list the selection criter, I have to guess from your output dataset. I got close to your output dataset. The following logic will have the one more record for D667 of 500000 amount. Hope this help. data appr reject; set file1; /*** your inpurt data set ***/ if reason='APPROVE' then output appr; else output reject; run; proc sort data=reject out=reject2x(drop=date) nodupkey; by id amount; run; proc sort data=appr; by id amount; run; data reject2x(keep=id amount); merge reject2x(in=a) appr(in=b); by id amount; if a and b then delete; run; proc sort data=reject; by id amount; run; data reject; merge reject(in=a) reject2x(in=b); by id amount; if a and b; if last.amount; run; data all; set appr reject; run;
... View more