topic Re: How to read multiple dataset from 1 library in SAS Programming

How to read multiple dataset from 1 library

pdhokriya — Wed, 08 Sep 2021 14:14:55 GMT

How to read and manipulate multiple dataset from 1 library

Ex.

- datasets in work library has 4datasets (one two three four)

- want to add condition on each datasets ( like if stutus = "Y" then output ; )

Re: How to read multiple dataset from 1 library

Tom — Wed, 08 Sep 2021 14:26:55 GMT

What are you going to read the datasets with? A procedure, like PROC MEANS? A data step?

If a data step do you need to read all of them together? How do you want to combine them? What output dataset(s) are you creating?

Sounds like you just want to use a WHERE statement.

where status = "Y" ;

Re: How to read multiple dataset from 1 library

Reeza — Wed, 08 Sep 2021 15:25:35 GMT

When you want to do the same thing multiple times in SAS look at either BY group processing or macro with loops or call execute.

UCLA introductory tutorial on macro variables and macros

https://stats.idre.ucla.edu/sas/seminars/sas-macros-introduction/

Tutorial on converting a working program to a macro

This method is pretty robust and helps prevent errors and makes it much easier to debug your code. Obviously biased, because I wrote it 🙂 https://github.com/statgeek/SAS-Tutorials/blob/master/Turning%20a%20program%20into%20a%20macro.md

Examples of common macro usage

https://communities.sas.com/t5/SAS-Communities-Library/SAS-9-4-Macro-Language-Reference-Has-a-New-Appendix/ta-p/291716

Re: How to read multiple dataset from 1 library

pdhokriya — Wed, 08 Sep 2021 17:39:08 GMT

Yes I want too read and create all the datasets at a time.

where considtion I understood.

Re: How to read multiple dataset from 1 library

Kurt_Bremser — Thu, 09 Sep 2021 06:59:11 GMT

If I understand you correctly, you have X number of datasets, and after the task have the same X number of datasets, but with reduced observations because of the applied WHERE?