You can define and maintain using proc datasets there is no need for proc sql.
There is far more for setting technical options for SAS datasets with that one Base SAS(R) 9.4 Procedures Guide, Third Edition
IT is behavior of the SAS dataset type.
Proc SQL is for people rather new in SAS with some other RDBMS experience. IT is just a small part what SAS is offering
Does that answer your question?
---->-- ja karman --<-----