It is different than TSQL which the MS server uses. I doubt it uses Oracle syntax either, although I have not worked with that. To the best of my knowledge they created their own SQL. You might look at "The Essential PROC SQL Handbook for SAS Users" although that book is several years old now.
If you want to do SQL code in SAS you have to learn PROC SQL. It is not going to run on other SQL I am pretty sure.