Making a project happen is one thing. What software to use is another thing.
Excuse me, but what is your game?
You are asking a question in quite few different subjects. Perhaps you could introduce yourself, your role and the challenges you're facing.
Your question is too broad to answer in a single post. I suggest you narrow your area of interest and provide more context to your question. Big data means different things to different people. How big is big in your case? At the lower end of "big" you often don't need to do anything special in SAS, just treat it like any other project.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.