Are you posting this in the Stored Process forum because you need to create a stored process that will report on the frequency for 3 variables???
Generally, when you develop a stored process you either start from SAS code (such as PROC FREQ) or you start from an Enterprise Guide task, such as the One-Way Frequencies Task. Either way, you will have to talk to your SAS Administrator or your Data Administrator to determine which SAS tables you are able to access.
If you are NOT going to create a Stored Process, but instead, just want to get a report of frequency counts, you might want to post this question in the SAS Procedures forum and not the Stored Process forum. The stated purpose of this forum is to "discuss the development and deployment of stored processes as stand-alone applications or integrated with the SAS Business Intelligence Server."
How are you using SAS to run your programs??? Are you running as part of a SAS BI Server installation or are you using SAS Enterprise Guide or Foundation SAS outside the context of the SAS BI Server (sometimes, also known as the Business Intelligence Platform or the SAS Platform for Business Analytics).
What kind of code have you already tried to use to get your frequency counts?