Help using Base SAS procedures

i want to append three excel files data into one dataset

Reply
Occasional Contributor
Posts: 12

i want to append three excel files data into one dataset

1. have.xls

id  name  salary

1  sri        1000

2  ram       2000

3  tango    3000

2 .  temp.xls

id  name  salary

1    gang  5000

2    hunk  300

5    pen    600

3. test.xls

id  name   salary

6  geoge   560

7  john      450

above there are 3 excel files i want to import data into dataset and append in to one dataset

Super User
Posts: 5,257

Re: i want to append three excel files data into one dataset

proc import + proc append

Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 157 views
  • 0 likes
  • 2 in conversation