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;
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.