topic Re: How to append 180 datasets to one datasets? in SAS Programming

How to append 180 datasets to one datasets?

Beto16 — Thu, 14 Jul 2016 21:42:16 GMT

Hi team I was able to import 180 datasets to work. same columns each file has 35k records they are all title with date it was produced. . For example
D160101. D160102. D160103. D160104 ...
I have hundreds datasets how can I create a macro to append all of them ? Thanks

Re: How to append 180 datasets to one datasets?

Reeza — Thu, 14 Jul 2016 21:47:39 GMT

They all start with D? Do you have other datasets in the library that you need to exclude?

You can do it without a macro, using the colon short cut. This will append all datasets that start with the letter D.

data want;
set D:;
run;

If you need a macro and want to use proc append, I would use the following method:

1. Write macro to use PROC APPEND

2. Obtain list of dataset name from sashelp.vtable -> store in a dataset

3. Use call execute to execute macro from #1.

Re: How to append 180 datasets to one datasets?

Beto16 — Fri, 15 Jul 2016 13:53:51 GMT

Thanks Reeza that worked

Re: How to append 180 datasets to one datasets?

Reeza — Fri, 15 Jul 2016 14:03:37 GMT

Why did you mark your answer as correct?

Re: How to append 180 datasets to one datasets?

Beto16 — Sat, 30 Jul 2016 18:19:17 GMT

Reeza. data want; set D:; run; this appended all the files that start with D it's what I was looking for

Re: How to append 180 datasets to one datasets?

Cynthia_sas — Sat, 30 Jul 2016 19:29:03 GMT

But it was Reeza's answer that was correct. You marked your response as correct, not her answer.
cynthia

Re: How to append 180 datasets to one datasets?

Beto16 — Sun, 31 Jul 2016 00:11:36 GMT

Oops I didn't see that's what I did my error