answersLogoWhite

0

How do I Merge data in SAS?

User Avatar

Anonymous

8y ago
Updated: 8/21/2019

Use the merge command. For example:

Data set one

ID A B

10 1 2

20 3 4

30 5 6

Data set two

ID C

10 0

20 5

30 7

data three;

merge one two;

by id;

run;

Output:

ID A B C

10 1 2 0

20 3 4 5

30 5 6 7

User Avatar

Wiki User

8y ago

What else can I help you with?

Related Questions

In what way SAS related to DATA mining in Bioinformatics?

SAS is statistical software that can be used as a tool for data mining.


What is an SAS certification?

An SAS certification is given to individuals who participate in the SAS Software Certificate Program. The certification is given to people who are looking for experience with SAS software and who are seeking analytical experience.


What is SAS Programming?

SAS (Statistical Analysis System) is a software suite that can archive, alter, manage and retrieve data from a variety of sources and perform statistical analysis on it. SAS is Build a strong SAS programming foundation to manipulate the data, perform complex queries and simple analyses, and generate reports.


What has the author Rebecca J Elliott written?

Rebecca J. Elliott has written: 'Learning SAS in the computer lab' -- subject(s): Statistics, Data processing, SAS (Computer file), Informatique, SAS (Logiciel), Statistique 'Learning SAS in the computer lab' -- subject(s): SAS (Computer file), Statistics, Data processing 'Learning SAS in the computer lab' -- subject(s): SAS (Computer file), Statistics, Data processing


What are some bestselling SAS software?

SAS 9.3 is one of the best products for SAS software. It offers the newest functions and subroutines, and has the newest features for data support. It can be used for a variety of work.


Who is best merge sort or insertion sort?

Merge sort is good for large data sets, while insertion sort is good for small data sets.


What has the author Rick Aster written?

Rick Aster has written: 'Professional SAS programming secrets' -- subject(s): SAS (Computer file) 'Professional SAS user interfaces' -- subject(s): Data processing, SAS (Computer file), Statistics, User interfaces (Computer systems) 'Professional SAS Programmer's Pocket Reference' -- subject(s): SAS (Computer file) 'A Look At SAS Files'


What has the author George Fernandez written?

George Fernandez has written: 'Statistical data mining using SAS applications' -- subject(s): SAS (Computer file), Computer programs, Commercial statistics, Data mining


What has the author Maura Ellen Stokes written?

Maura Ellen Stokes has written: 'Categorical data analysis using the SAS system' -- subject(s): Data processing, Mathematical statistics, SAS (Computer file)


Is SAS programming with Oracle DBA a good profile I work as an Oracle DBA administrator but I want to move to SAS programming Will it help?

It's no so much moving on but adding on. Oracle SQL stores the data and retrieves it, SAS formats and massages the extracted data for presentation to end users.


Do you have to merge all the data in a data source?

No. There are various ways of merging some data only. It will depend on what you are doing, but you may want to just merge a certain number or ones that fit certain criteria. It is possible to do that.


Where can one get more information on sas programming?

One may find information on SAS Programming through books in their local library or bookshop. The SAS website however, has the main source of information on the subject. Here you can access materials, book courses, and arrange to train online through the website.