cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
2much2learn
‎09-01-2015
  • 6 Posts
  • 0 Likes Given
  • 0 Solutions
  • 4 Likes Received

Re: Merge criteria

by Calcite | Level 5 in SAS Procedures
‎01-12-2012 04:21 PM
‎01-12-2012 04:21 PM
I see you got some nice suggestions. It seems to me hash() could be one of possible approaches, since it does not require sorting and is capable of searching multiple variables at the same time. data SET1; infile cards; input AREA $  Prov $; cards; Tor         Ont Osh       Ont Mon       Que Van        BC Win        Man Ont        Ont Que       Que Man      Man BC         BC ; data SET2; infile cards; input AREA $  val; cards; Tor          3.5 Mon        4.4 Van        2.1 BC         3.2 Man        2.8 Que        1.9 Ont         2.5 ; data merged;    if _n_=1 then do;      if 0 then set set2; declare hash merg (dataset: "set2"); merg.definekey("area"); merg.definedata("val"); merg.definedone();    end; set set1; if merg.find(key:area)=0 then output; else if merg.find(key:prov)=0 then output; else delete; run; proc print;run; Kindly Regards, Haikuo ... View more

retain variable across observations

by Calcite | Level 5 in SAS Procedures
‎01-12-2012 01:51 PM
‎01-12-2012 01:51 PM
Slightly different from Linlin's approach: 1) does not populate the missing value of date2: data want (drop=_:); set have; retain _d2; _d2=coalesce(date2,_d2); value=ifn(date1<= _d2,1,0); run; 2)does populate the missing value: data want (drop=_:); set have ( keep=date2 obs=0) have (rename=date2=_d2); date2=ifn(_d2 ne ., _d2,date2); value=ifn(date1<= date2,1,0); run; ... View more

how to seperate non matching records for 2 dataset

by Calcite | Level 5 in SAS Enterprise Guide
‎01-12-2012 12:51 PM
1 Like
‎01-12-2012 12:51 PM
1 Like
And if you only care about non-matching records, SQL is more handy as it does not require sorting: proc sql; create table nm as select * from t2 except select * from t1; quit; Haikuo ... View more

how to seperate non matching records for 2 dataset

by Calcite | Level 5 in SAS Enterprise Guide
‎01-12-2012 12:44 PM
3 Likes
‎01-12-2012 12:44 PM
3 Likes
I am not 100% sure about what exactly OP wanted, but here to start the discussion: data t1; infile cards; input id $ a; cards; a 1 b 2 c 3 ; data t2; infile cards; input id $ a; cards; a 1 b 1 c 1 a 2 b 2 c 2 a 3 b 3 c 3 ; proc sort data=t1; by id a; run; proc sort data=t2; by id a; run; data m nm; merge t1 (in=t1) t2(in=t2); by id a; if t1 and t2 then output m; else if t2 and not t1 then output nm; run; 'm' will be the records shared by two tables, nm will be the records uniquely exist in table2. Kindly Regards, Haikuo ... View more

Not able to Paste the code in the Editor Window

by Calcite | Level 5 in SAS Programming
‎01-12-2012 11:25 AM
‎01-12-2012 11:25 AM
Just to follow up the thread. Well, after having tried many ways in vain, I end up with a portable web browser 'opera usb'. Basically you don't need to install it,just run it from anywhere. It seems to be one of a dozen those so called'portable browsers' .It serves my purpose. Now I can 'copy and paste' using mycompany computer. Thanks, Haikuo ... View more

Not able to Paste the code in the Editor Window

by Calcite | Level 5 in SAS Programming
‎01-10-2012 10:41 AM
‎01-10-2012 10:41 AM
I am experiencing the same issue. I am currently on winxp, sp3 using IE8. I have tried all of the walk-arounds suggested here, still NO go. Please Help! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Likes from
View All
Quick links