I have added constraints into a table but it removes it when someone overwrites the table. Is there any way to prevent it?
DATA TEMP;
SET SASHELP.CLASS;
RUN;
PROC SQL;
ALTER TABLE TEMP
ADD CONSTRAINT NOT_NULL_WEIGHT NOT NULL(WEIGHT);
QUIT;
DATA TEMP;
SET TEMP;
IF AGE >=15 THEN WEIGHT = .;
RUN;
Constraints are kept and respected if you stay within SQL. Try
proc sql;
update temp
set weight = .
where age >= 15;
quit;
Constraints are kept and respected if you stay within SQL. Try
proc sql;
update temp
set weight = .
where age >= 15;
quit;
Use MODIFY if you want to retain the constraint. But note that
DATA TEMP;
modify TEMP;
IF AGE >=15 THEN WEIGHT = .;
RUN;
is not equivalent to the SQL UPDATE query above. There is no rollback with MODIFY.
Add a password in this table to avoid to rewrite it .
DATA TEMP(pw=aw12);
SET SASHELP.CLASS;
RUN;
data temp;
set sashelp.class;
run;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.