East Carolina University
Department of Psychology

Merging Data Files:  SAS


   Here is a simple example, with comments in green

options formdlim='-' pageno=min nodate;
/* Assign name outf2 to the demogs file and outd to the soph-srData file.*/
filename outf2 'D:\Research-Misc\Dudley\demogs.txt';
filename outd 'D:\Research-Misc\Dudley\soph-srData.txt';
/* Read in the outd file.  Truncover -- see Missover-Truncover-Pad
data senior_sophomore; infile outd truncover;
input @1 id 4. @7 (a1-a9)($1.) @16 (b1a b1b b1c b1d b1e)($1.)
@21 (b2a b2b b2c b2d)($1.) @25 (b3a b3b b3c b3d b3e b3f)($1.)
@31 (b4a b4b b4c b4d b4e)($1.) @36 (b5a b5b b5c b5d)($1.)
@40 (c1a c1b c1c c1d c1e c1f c1g c1h c1i c1j c1k c1l c1m c1n)($1.)
@54 (c2a c2b)($1.) @56 (d1a d1b d1c)($1.)
@59 (d2a d2b d2c d2a1 d2b1 d2c1 d2a2 d2b2 d2c2)($1.)
@68 (d3a d3b d3c)($1.) @71 (d4a d4b d4c)($1.)
@74 (d5a d5b d5c)($1.) @77 (d6a d6b d6c)($1.)
@80 (d7a d7b d7c)($1.) @83 (d8a d8b)($1.) @85 (d9a d9b)($1.)
@87 (d10a d10b)($1.) @89 (e1 e2a e2b e3-e6)($1.)
@96 f1 $1. @97 (h1-h5)($1.) @102 (i1 i2a i2b i2c i2d i3 i4)($1.)
@109 j3 $1. @110 cipcod $12.
/* end of senior data - leave one blank column */
@123 (sqa1-sqa9)($1.) @132 (sqb1a sqb1b sqb1c sqb1d sqb1e)($1.)
@137 (sqb2a sqb2b sqb2c sqb2d sqb2e)($1.)
@142 (sqb3a sqb3b sqb3c sqb3d sqb3e)($1.)
@147 (sqb4a sqb4b sqb4c sqb4d)($1.)
@151 (sqb5a sqb5b sqb5c sqb5d sqb5e sqb5f)($1.)
@157 (sqb6a sqb6b sqb6c sqb6d sqb6e)($1.)
@162 sqb7a $1. @163 (sqc1 sqc2 sqc3)($1.) @166 (sqd1a sqd1b)($1.)
@168 (sqd2a sqd2b)($1.)
@170 (sqd3a sqd3b)($1.) @172 (sqd4a sqd4b)($1.)
@174 (sqd5a sqd5b)($1.) @176 (sqd6a sqd6b)($1.)
@178 (sqd7a sqd7b)($1.) @180 sqd8a $1. @181 sqd9a $1. @182 sqd10a $1.
@183 (sqe1-sqe5)($1.) @188 sophsem $3. @191 srsem $3.;
/* end of soph data
Sort by the variable you will use to match cases.*/
proc sort; by id; run;
/* Read in the outf2 file.*/
data demogr; infile outf2 truncover;
input @1 id 4. @5 high_act_score 6. @11 high_msat_score 6.
@17 high_vsat_score 6. @23 prog $20. @43 bmon 2. @45 bday $2. @47 byr 4.
@51 degr $10. @61 gpa 5.3 @66 hrsearnd 7.2 @73 hrstran 7.2
@80 race $1. @81 sex $1. @82 cit $1. @83 term $1. @84 year $4.;
run;
/* Sort by the matching variable.*/
proc sort; by id; run;
/* Create the merged data, "both."*/
data both; merge senior_sophomore demogr; by id; run;
/* Get a description of the merged data set.*/
proc contents varnum; run;


snake on a stick

Back to my SAS Help page

 Visit Karl's Index Page


Contact Information for the Webmaster,
Dr. Karl L. Wuensch


This page most recently revised on 9-10-11.