SAS does support integrity constraints but they do not come along with the data when you create a data set from an Oracle table. They must be recreated using PROC DATASETS. Here's a link to Mike Raithel's 2011 SGF paper. It's a .pdf so just search on 'constraint'. http://support.sas.com/resources/papers/proceedings11/274-2011.pdf
If the primary key and foreign key physically exist as fields in an Oracle table I don't know of any reason why they wouldn't be in the SAS data set, but there won't be anything other than the variable name to indicate that they are the PK and FK.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.