How to append 180 datasets to one datasets?

[Beto16]

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

[Reeza · Accepted solution]

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. 

[Beto16]

Thanks Reeza that worked

[Reeza]

Why did you mark your answer as correct?

[Beto16]

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

[Cynthia_sas]

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

[Beto16]

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