sas - update a table efficiently using proc sql -

-

i need update table past missing information using past versions of same table. update needed earlier information not available anymore in recent table. let tablea table @ time0 , tableb table @ time1 , on. i'm interested in last updated table.

so far have tried method;

create view _tableb select *  tablea  union  select *  tableb  a.id not in (select id tablea);

then proceeded with:

create view _tablec select * _tableb union  select * tablec a.id not in (select id _tableb);

and on till reach final table create table. 

create table _tablet  select *  _tables  union  select *  tablet a.id not in (select id _tables);

do see better here?

p.s: have mention each observations can have many languages. information in way

id|lguage1|lguage2|lguage3|

and put wide2long using view , this method.

id1|lguage1  id1|lguage2  id1|lguage3 id2|lguage1

the informations not sorted id , language.
thanks.

given couple of assumptions, can simplify greatly:
1. each individual dataset has no duplicate id's.
2. each dataset sorted id.

then this: data result; set _tables ... _tablec _tableb _table; id; if first.id; run;

this way, code more compact , data read once. read in tables , output interweaved result (i.e.: result sorted on id)

the firs.id filter means keep first record of each id value encounters. since datasets mentioned recent first, take recent record available each id , ditch others.


Comments

Post a Comment

Popular posts from this blog

c++ - Linked List error when inserting for the last time -

-
so have part of code here this loop 5 times (max = 5) insert word link list. for ( int = 0 ; < max ; i++ ) { string alphabet = g->returnalphabets(); l[i]->addwords(alphabet[i]); } and have insert word part here string line; fstream myfile ("words.txt"); while (!myfile.eof()) { getline(myfile,line); if ( alphabet == line[0] ) { listnode *newnode = new listnode; if ( head == null ) { newnode->item = alphabet; newnode->next = null; head = newnode; } else { newnode->item = line; prev = cur; prev->next = newnode; } cur = newnode; } } myfile.close(); my problem gives me error on last loop. meaning on max = 4, insert node. rest of loop fine. when decrease max 4 meaning loop 4 times, program error-free when program loops 5 times gives error. anyone can poin...
Read more

java - activate/deactivate sonar maven plugin by profile? -

-
i use sonar plugin executes if activated in maven profile. sonar runs on every compile. the problem build fail other team members not have sonar application installed locally. pom.xml checked in team members same copy including sonar configuration, don't want them modify purpose of disabling sonar (they might inadvertently check modified copy in). please advise how configure maven (.m2/settings.xml) and/or pom.xml sonar feature can enabled/disabled local profile. here sonar configuration in each project's pom.xml: <plugin> <groupid>org.codehaus.mojo</groupid> <artifactid>sonar-maven-plugin</artifactid> <version>1.0</version> <executions> <execution> <id>make-sonar</id> <phase>compile</phase> <goals> <goal>sonar</goal> </goals> </execution> </executions> ...
Read more

java - What is the difference between String. and String.this. ? -

-
this question has answer here: meaning of .this , .class in java 2 answers i'll straight point. im still learning bit of syntax , want know difference between code is code a: public class buttonz extends jbutton{ public buttonz(){ settext(new string(string.valueof(i))); } } please ignore fact i undeclared, not lost. code b: public class buttonz extends jbutton{ public buttonz(){ settext(new string(string.this.charat(i))); } } what don't yet understand difference in typing string.this , string. i under assumption when use dot operator on class accessing it's static methods(and/or variables if they're not hidden). i have studied little bit , have concluded when using string. accessing string static methods.. when using string.this. i'm accessing methods class buttonz extendi...
Read more