topic study material in New SAS User

study material

Pooja98 — Fri, 16 Oct 2020 17:16:16 GMT

Can anyone share the study material for macros and sql ???

Re: study material

Reeza — Fri, 16 Oct 2020 17:28:56 GMT

For Macros:

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

LexJansen - user written papers and tutorials

https://www.lexjansen.com/search/searchresults.php?q=macro%20tutorials

SQL

I'd recommend the Kaggle SQL course first (free) or W3Schools or FreeCodeCamp and then learn how to use it in SAS specifically.

https://www.freecodecamp.org/news/sql-and-databases-full-course/

Re: study material

FreelanceReinh — Fri, 16 Oct 2020 18:24:05 GMT

For PROC SQL I recommend Howard Schreier's excellent book PROC SQL by Example: Using SQL within SAS® (from which I learned it), especially if you already know some DATA step programming. The latter is also assumed for Christianna S. Williams's paper PROC SQL for DATA Step Die-hards (which I used back then as well).