topic Re: constraints in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/constraints/m-p/170773#M44123 <HTML><HEAD></HEAD><BODY><P>You can define and maintain using proc datasets there is no need for proc sql.&nbsp; <BR />There is far more for setting technical options for SAS datasets with that one <A href="http://support.sas.com/documentation/cdl/en/proc/67327/HTML/default/viewer.htm#p0xdkenol7pi1cn14p0iq38shax4.htm" title="http://support.sas.com/documentation/cdl/en/proc/67327/HTML/default/viewer.htm#p0xdkenol7pi1cn14p0iq38shax4.htm">Base SAS(R) 9.4 Procedures Guide, Third Edition</A> </P><P>IT is behavior of the SAS dataset type.</P><P></P><P>Proc SQL is for people rather new in SAS with some other RDBMS experience. IT is just a small part what SAS is offering</P><P>Does that answer your question? </P></BODY></HTML> Fri, 03 Oct 2014 05:48:33 GMT jakarman 2014-10-03T05:48:33Z constraints https://communities.sas.com/t5/SAS-Procedures/constraints/m-p/170772#M44122 <HTML><HEAD></HEAD><BODY><P>Hi;</P><P>I jus need a simple clarification about table constarints. Once table constraints are implemented through proc sql, will it be enforced even when I work the datasets using the regular data steps? Or is it just for the proc sql only?</P><P>Thanks,</P></BODY></HTML> Fri, 03 Oct 2014 00:42:18 GMT https://communities.sas.com/t5/SAS-Procedures/constraints/m-p/170772#M44122 JVarghese 2014-10-03T00:42:18Z Re: constraints https://communities.sas.com/t5/SAS-Procedures/constraints/m-p/170773#M44123 <HTML><HEAD></HEAD><BODY><P>You can define and maintain using proc datasets there is no need for proc sql.&nbsp; <BR />There is far more for setting technical options for SAS datasets with that one <A href="http://support.sas.com/documentation/cdl/en/proc/67327/HTML/default/viewer.htm#p0xdkenol7pi1cn14p0iq38shax4.htm" title="http://support.sas.com/documentation/cdl/en/proc/67327/HTML/default/viewer.htm#p0xdkenol7pi1cn14p0iq38shax4.htm">Base SAS(R) 9.4 Procedures Guide, Third Edition</A> </P><P>IT is behavior of the SAS dataset type.</P><P></P><P>Proc SQL is for people rather new in SAS with some other RDBMS experience. IT is just a small part what SAS is offering</P><P>Does that answer your question? </P></BODY></HTML> Fri, 03 Oct 2014 05:48:33 GMT https://communities.sas.com/t5/SAS-Procedures/constraints/m-p/170773#M44123 jakarman 2014-10-03T05:48:33Z