Example of table merging by identifier

This program creates two temporary SAS^© tables (sample1 and sample2) containing simulated data (student grades). It displays this data, then merges the two tables on the common column 'sid' to create a consolidated table named 'MERGED', whose content is then displayed.

Data Analysis

Type : INTERNAL_CREATION

Data is generated directly in the source code via the DATALINES statement.

1 Code Block

DATA STEP Data

Explanation :
Creation of dataset 'sample1' containing an identifier (sid) and a mark.

Copied!

1	DATA sample1;
2	INPUT sid mark;
3	DATALINES;
4	1 100
5	2 90
6	3 30
7	4 50
8	5 60
9	;

2 Code Block

DATA STEP Data

Explanation :
Creation of dataset 'sample2' containing an identifier (sid) and two other marks (mark1, mark2).

Copied!

1	DATA sample2;
2	INPUT sid mark1 mark2;
3	DATALINES;
4	1 90 80
5	2 80 76
6	3 75 23
7	4 62 42
8	5 71 43
9	;

3 Code Block

PROC PRINT

Explanation :
Visualization of the two source datasets.

Copied!

1	PROC PRINT DATA=sample1;
2	PROC PRINT DATA=sample2;

4 Code Block

DATA STEP Data

Explanation :
Merging tables 'sample1' and 'sample2' by aligning observations on the key variable 'sid'. The result is stored in the 'MERGED' table.

Copied!

1	DATA MERGED;
2	MERGE sample1 sample2;
3	BY sid;

5 Code Block

PROC PRINT

Explanation :
Visualization of the merge result and script termination.

Copied!

1	PROC PRINT DATA=MERGED;
2
3	RUN;
4	QUIT;

This material is provided "as is" by We Are Cas. There are no warranties, expressed or implied, as to merchantability or fitness for a particular purpose regarding the materials or code contained herein. We Are Cas is not responsible for errors in this material as it now exists or will exist, nor does We Are Cas provide technical support for it.

Retour à la liste