topic Re: delete rows conditionally in SAS Programming

delete rows conditionally

BrahmanandaRao — Tue, 01 Feb 2022 06:37:02 GMT

proc sql;
create table students (name varchar(12),
address varchar(20),
marks num(3));
quit;


proc sql;
insert into students 
values('Anand','Hyderabad',80)
values('Siva','Bangalore',65)
values('aditya','Rjy',65)
values('Krishna','Pune',65)
values('vasu','Vja',65);
quit;



proc sql;
delete from students
where  name='Krishna' marks=65;
quit;

Here i want to delete kirshna marks how to delete rows conditionally

Re: delete rows conditionally

japelin — Tue, 01 Feb 2022 06:52:48 GMT

You can delete rows this way.

proc sql;
delete from students
where  name='Krishna' and marks=65;
quit;

proc sql;
delete from students
where  name='Krishna';
quit;

To specify multiple conditions, use And, Or, etc. to connect them.

Re: delete rows conditionally

BrahmanandaRao — Tue, 01 Feb 2022 06:55:58 GMT

How delete krishna's marks only

Re: delete rows conditionally

japelin — Tue, 01 Feb 2022 07:00:06 GMT

If you want to delete the value of a specific column instead of a row, use update.


proc sql;
update students 
set marks=null /* set null or . */
where  name='Krishna';
quit;

Re: delete rows conditionally

BrahmanandaRao — Tue, 01 Feb 2022 07:06:25 GMT

Thank You Japelin