| Date: | Fri, 12 Mar 2004 12:21:51 +0530 |
|---|
| Reply-To: | Nitin Chandak <nitin.chandak@GLOBALCASE.NET> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Nitin Chandak <nitin.chandak@GLOBALCASE.NET> |
|---|
| Subject: | Constraints Information |
|---|
| Content-Type: | text/plain; charset="iso-8859-1" |
|---|
Hi All,
Run the below code. You will find out dataset test2 is having all the
information
related to dataset test1 except information on constraints.
How to find out constraints and not null columns information from dictionary
tables
or from any PROC?
Thanks in advance.
<SAS>
data test1;
infile datalines;
input a1 a2 a3 $;
datalines;
1.00 2.00 a
4.00 5.00 b
7.00 8.00 c
run;
proc sql;
alter table test1 add constraint ck check (a3 NE 'Z');
alter table test1 modify a3 not null;
describe table constraints test1;
insert into test1 values (1,10,'a');
insert into test1 values (1,20,'Z');
quit;
proc contents data=test1 out=test2 noprint;
run;
proc print data=test2; run;
</SAS>
Regards,
Nitin Chandak
Stingray Technologies Pvt. Ltd.
B-10, Sector 1, Udyog Marg,
Noida-201 301 (NCR Delhi).
nitin.chandak@globalcase.net
Mobile : 09811431769
| 
