Thanks guys ... silly silly mistake .. ... View more

My code calls the variable MONTH and not DATE, which apparently is what you call the variable. You'd have to make that change. ... View more

I would suggest the coalescec function, which returns the left most non-missing (non-blank in the case of character variables) argument from a list of arguments:   data want (drop=altpartnum); set have; partnum=coalesce(altpartnum,partnum); run;   If PartNum and AltPartnum are numeric variables, then use the coalesce function instead. ... View more

Programming is not always necessarily years of experience, rather the ability to grasp and think fast in my opinion. Being new is never a constraint and I'm relatively new      data One; input Name $50.; cards; Raam Rahim Ram Rahima Rahim Raam Rama Rahim ; run; data _null_; if _n_=1 then do; declare hash H () ; h.definekey ("name1","name2") ; h.definedata ("name") ; h.definedone () ; end; set one end=lr; name1=scan(upcase(name),1,' '); name2=scan(upcase(name),2,' '); rc=h.check(); rc1=h.check(key:name2,key:name1); if rc1 ne 0 and rc ne 0 then rc2=h.add(); if lr then h.output(dataset:'want'); run;   ... View more

yessir !! that did it too .. thanks ... View more

Programming is not always necessarily years of experience, rather the ability to grasp and think fast in my opinion. Being new is never a constraint and I'm relatively new      data One; input Name $50.; cards; Raam Rahim Ram Rahima Rahim Raam Rama Rahim ; run; data _null_; if _n_=1 then do; declare hash H () ; h.definekey ("name1","name2") ; h.definedata ("name") ; h.definedone () ; end; set one end=lr; name1=scan(upcase(name),1,' '); name2=scan(upcase(name),2,' '); rc=h.check(); rc1=h.check(key:name2,key:name1); if rc1 ne 0 and rc ne 0 then rc2=h.add(); if lr then h.output(dataset:'want'); run;   ... View more

thanks all !!! I love this site and these boards !! ... View more

How about this one ?   data have; input C1 C2 C3 C4 C5; cards; 10 12 15 55 15 10 10 15 10 12 10 10 10 10 10 10 10 12 12 15 ; run; data want; if _n_=1 then do; declare hash h(ordered:'a'); declare hiter hi('h'); h.definekey('k'); h.definedata('k','count'); h.definedone(); end; set have; array x{*} c1-c5; do i=1 to dim(x); k=x{i}; rc=h.find(); if rc=0 then do;count=count+1;h.replace();end; else do;count=1;h.add();end; end; do while(hi.next()=0); if count>=max then do;max=count;RESULT=k; end; end; h.clear(); drop i k rc max count; run; P.S. If you can use SAS/IML, that could fast you a lot more and save you a lot code. ... View more

Hi:   All of our Programming courses use the ORION libref. However, every course has a program that makes the data needed for the course. The Programming 2 data is NOT the same as that used in Programming 1.   cynthia ... View more

Thanks Xia Keshan     that did the trick !!!! you da man !   Junaid F.   ... View more