You asked "how much effort should I put in learning SAS commands? Is it better to use PROC SQL and what I already know or using SAS language is better?"
SAS SQL is a little different then other systems' SQL. You can use SAS functions and some SAS file options within SAS SQL. SAS Base, in some cases, is shorter in code and more efficient. Sas Base contains statements (commands), functions and many procedures. Some of these code may differ depending on the SAS platform you use.
You should look for a learning program in order to progress efficiently to get a good experience.
... View more