topic how to merge same data but in two different datasets in SAS Programming

how to merge same data but in two different datasets

torvin10 — Tue, 13 Nov 2018 03:36:18 GMT

I have to merge these two sets of data, which contains exactly the same data, but written in different ways:

* (i);
A123   4Mar1989    8,60000
A037  23Jun1957   21,45000
M015  19Sep1977   17,50000

* (ii);
A123  4Mar1989  8,6,00
***************
    A037 23Jun1957  21,450
**************
 M015 19Sep1977$17,500
***********

The first record should have

ID = "A123", DEPT = "A", BIRTHDAY = 10655, YEAR = 1989, SALARY = 8600

So far my approach has been(which doesn´t work):

data i;
   input $ID $Dep $BIRTHDAY $YEAR $SALARY;
   datalines;
A123   4Mar1989    8,60000
A037  23Jun1957   21,45000
M015  19Sep1977   17,50000
;
run;

Any suggestions?

Re: how to merge same data but in two different datasets

Reeza — Tue, 13 Nov 2018 03:55:38 GMT

What type of output are you looking for, a text file or a SAS dataset? Do already have these read into SAS datasets? What is the original source and can you read those in already or is that part of the problem you’re facing? This was posted on SO and a solution provided, if that didn’t work, please outline how.

You say merge, but your code only reads in a data set so have you attempted to merge these at all so far?

@torvin10 wrote:

I have to merge these two sets of data, which contains exactly the same data, but written in different ways:

Offsite data:
* (i);
A123   4Mar1989    8,60000
A037  23Jun1957   21,45000
M015  19Sep1977   17,50000

* (ii);
A123  4Mar1989  8,6,00
***************
    A037 23Jun1957  21,450
**************
 M015 19Sep1977$17,500
***********
The first record should have
ID = "A123", DEPT = "A", BIRTHDAY = 10655, YEAR = 1989, SALARY = 8600
So far my approach has been(which doesn´t work):
data i;
   input $ID $Dep $BIRTHDAY $YEAR $SALARY;
   datalines;
A123   4Mar1989    8,60000
A037  23Jun1957   21,45000
M015  19Sep1977   17,50000
;
run;
Any suggestions?

Re: how to merge same data but in two different datasets

torvin10 — Tue, 13 Nov 2018 05:01:09 GMT

Im trying to make a SAS data file which contains five variables. The original source is a .txt document. And i couldn´t find the solved problem that you mentioned.

I´ve tried merging the datasets by doing so:

data i ii;
  input DEPT $1. @1 ID $ BIRTHDAY :date9. +(-5) YEAR :8. SALARY comma10.0;
  datalines;
A123   4Mar1989    8,60000
A037  23Jun1957   21,45000
M015  19Sep1977   17,50000

A123  4Mar1989  8,6,00

***************
    A037 23Jun1957  21,450
**************
 M015 19Sep1977$17,500
***********
;
run;

However this creates a set where the * also is a part of the dataset, which is unwanted.