ZuoTi.Pro
Question

how do we join two large SAS files with a common column in SAS? for example...

how do we join two large SAS files with a common column in SAS?

for example i am having a huge data with 6.5 million entries of a people academic history and every individual has a unique id and other file contains 14.5 million entries of individual profile and it also has a unique id, how can i merge the files by taking the unique id as a common column?

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

THE DEFAULT MATCH-MERGE

There are many definitions for merge. All of them talk about taking two or more sorted input files and combining them into one output file. Of course, sorted means that the input files have a common key and that the records in each file are ordered according to the key field(s). Consider the following two input files, as an example.

These two files have a common key field called ID. The records in both files are sorted by ID. A match-merge in SAS means that records from the one file will be matched up with the records of the second file that have the same ID. The information in the matched records is combined to form one output record. Here is how the above two input files are match-merged in SAS.

0 0
Add a comment
Know the answer?
Add Answer to:
how do we join two large SAS files with a common column in SAS? for example...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • C Programming - Please Help us! Implementing Load Balancing, the 3 Base Code files are at the bot...

    C Programming - Please Help us! Implementing Load Balancing, the 3 Base Code files are at the bottom: Implementing Load Balancing Summary: In this homework, you will be implementing the main muti-threaded logic for doing batch based server load balancing using mutexes Background In this assignment you will write a batch-based load balancer. Consider a server which handles data proces- sing based on user requests. In general, a server has only a fixed set of hardware resources that it can...

  • We are going to assume the class is a group of policy makers at a large...

    We are going to assume the class is a group of policy makers at a large insurance company – ABC HMO. Part of our pay is based on the company's financial performance for the current year. Specifically, the company looks at actual vs. projected medical expenses per member. The expected is based on last year's actual adjusted for inflation. One of our planners read the below article in the NY Times and recommends we reduce our coverage of routine breast...

  • Question: What does Hobbes suggest is the reason we have government at all? How does Locke’s...

    Question: What does Hobbes suggest is the reason we have government at all? How does Locke’s view of the need for government differ? Using these sources: From Thomas Hobbes, Leviathan book 1, chapter 13 So that in the nature of man, we find three principal causes of quarrel. First, competition; secondly, diffidence; thirdly, glory. The first maketh men invade for gain; the second, for safety; and the third, for reputation. The first use violence, to make themselves masters of other...

  • C++ Design a class bankAccount that defines a bank account as an ADT and implements the...

    C++ Design a class bankAccount that defines a bank account as an ADT and implements the basic properties of a bank account. The program will be an interactive, menu-driven program. a. Each object of the class bankAccount will hold the following information about an account: account holder’s name account number balance interest rate The data members MUST be private. Create an array of the bankAccount class that can hold up to 20 class objects. b. Include the member functions to...

  • Playgrounds and Performance: Results Management at KaBOOM! (A) We do this work because we want to...

    Playgrounds and Performance: Results Management at KaBOOM! (A) We do this work because we want to make a difference in the world; how can we go further faster? - Darell Hammond, CEO and co-founder, KaBOOM! Darell Hammond stepped onto the elementary school playground and took a long, slow look around. It was 8 a.m. on an unusually warm fall day in 2002 and the playground was deserted, but Hammond knew the children would start arriving soon to admire their new...

  • Explain how the below key concept are linked to this case (i.e. how the key concepts...

    Explain how the below key concept are linked to this case (i.e. how the key concepts you have learned in this topic is applied in this case study?) Culture and Cross-Cultural Risk Culture is the values, beliefs, customs, arts, and other products of human thought and work that characterize the people of a given society. Cross-cultural risk arises from a situation or event in which a cultural misunderstanding puts some human value at stake. Values and attitudes are shared beliefs...

  • Hi there! I need to compare two essay into 1 essay, and make it interesting and...

    Hi there! I need to compare two essay into 1 essay, and make it interesting and choose couple topics which im going to talk about in my essay FIRST ESSAY “Teaching New Worlds/New Words” bell hooks Like desire, language disrupts, refuses to be contained within boundaries. It speaks itself against our will, in words and thoughts that intrude, even violate the most private spaces of mind and body. It was in my first year of college that I read Adrienne...

  • use the information in chapter one to complete it ( in case you do not have...

    use the information in chapter one to complete it ( in case you do not have the book, i post a picture). write a few sentences in each box explaining the extent to which the statements in the left column apply to each of the theories. thank you! Themes and theories Constructivism (Piaget) Social constructivism (Vygotsky) Bioecological systems theory (Bronfenbrenner) nta The environment plays an important role in development Innate factors drive development Development follows a smooth continuous path ning...

  • How can we assess whether a project is a success or a failure? This case presents...

    How can we assess whether a project is a success or a failure? This case presents two phases of a large business transformation project involving the implementation of an ERP system with the aim of creating an integrated company. The case illustrates some of the challenges associated with integration. It also presents the obstacles facing companies that undertake projects involving large information technology projects. Bombardier and Its Environment Joseph-Armand Bombardier was 15 years old when he built his first snowmobile...

  • SESSION 12 Workers for Ivanka's clothing company The reality of working in a factory making clothes...

    SESSION 12 Workers for Ivanka's clothing company The reality of working in a factory making clothes for Ivanka Trump’s label has been laid bare, with employees speaking of being paid so little they cannot live with their children, anti-union intimidation and women being offered a bonus if they don’t take time off while menstruating. The Guardian has spoken to more than a dozen workers at the fashion label’s factory in Subang, Indonesia, where employees describe being paid one of the...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT