BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Ujjawal
Quartz | Level 8

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;

 

1 ACCEPTED SOLUTION

Accepted Solutions
PGStats
Opal | Level 21

Constraints are kept and respected if you stay within SQL. Try


proc sql;
update temp
set weight = .
where age >= 15;
quit;

 

 

PG

View solution in original post

3 REPLIES 3
PGStats
Opal | Level 21

Constraints are kept and respected if you stay within SQL. Try


proc sql;
update temp
set weight = .
where age >= 15;
quit;

 

 

PG
PGStats
Opal | Level 21

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.

PG
Ksharp
Super User

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;

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1350 views
  • 2 likes
  • 3 in conversation