I have learnt many string int functions, procedure,merging etc that we can use in Data Step and almost completed its problems in SAS by Example. Next i learn the things with Proc SQL . Please anyone suggest me any good resource so i can practice more and become more confident for SAS. because i need to complete the scenario based questions which can be beneficial for interviews also.
And if anyone has Little SAS problem book PDF, please share.
There are many books out there for learning SAS. I recommend SAS® Certification Prep Guide: Advanced Programming for SAS®9, Fourth Edition which covers PROC SQL. See Table of contents and also sample before, so that you will get an idea.
Please stop asking for sharing PDF copies for books, they have copyrights and illegal to share.
Don't ask for PDF versions of copyrighted material. It's illegal and disrespectful, several of the authors contribute regularly here and have spend hours working on those books and I can assure you they're not raking in the dollars from them either. The book is relatively inexpensive and many libraries have digital versions available.
https://communities.sas.com/t5/SAS-Communities-Library/Free-SAS-Learning-Resources/ta-p/425554
My suggestion is to look through the certification guide or the prep list for the certification guide. And then search for papers on that topic on lexjansen.com or search on here for that topic to see what issues people are having and how the solutions are coded.
Base topics:
data step thoroughly:
SET
MERGE
UPDATE
OUTPUT statement
ARRAYS
PROCS:
Proc means
proc freq
proc transpose
PROC SQL for joins
If you want real life practice, try answering questions on here without first looking at the answers. It's the best example of real life questions and situations with a lot of helpful answers.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.