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;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.