Help using Base SAS procedures

can i delete row?

Accepted Solution Solved
Reply
New Contributor
Posts: 4
Accepted Solution

can i delete row?

i want to delete same id. Is there a way? please help me.. thank you..

 

ex)

 

original set                                     fina set

 

id  year  x                                       id  year  x

a  2000  2              -------->             a  2000  2

a  2001  5                                      a   2001 5

b  2000  .                                       c   2000 3

b  2001  5                                      c   2001 3

c  2000  3

c  2001  3


Accepted Solutions
Solution
3 weeks ago
Trusted Advisor
Posts: 1,384

Re: can i delete row?

It seems you want to delete all rows of same ID YEAR, when IND is missing.

You may try next code:

proc sql
   create table to_del as
   select distinct ID, YEAR
   where IND=.
   from have
order by ID, YEAR; quit; data want; merge have(in=inh) del (in=ind); by ID YEAR; if inh and not ind; run;

View solution in original post


All Replies
PROC Star
Posts: 253

Re: can i delete row?

you can remove duplicates by using proc sort. But example you have given is not clear. can you elaborate your example, that is explain in brief, why you want to delete a particular id.

New Contributor
Posts: 4

Re: can i delete row?

i will analyze by DIFFERENCE-IN-DIFFERENCES (DiD) analysis. and I will use BALANCED DATA SET.  understand me?

 

idYEARTIMEINDTIME x IND idYEARTIMEINDTIME x IND
a200000.230 a200000.230
a200110.220.22 a200110.220.22
b200000.430c200000.550
b20011.. c200113333
c200000.550 d200000.250
c200113333 d200110.40.4
d200000.250      
d200110.40.4      
Solution
3 weeks ago
Trusted Advisor
Posts: 1,384

Re: can i delete row?

It seems you want to delete all rows of same ID YEAR, when IND is missing.

You may try next code:

proc sql
   create table to_del as
   select distinct ID, YEAR
   where IND=.
   from have
order by ID, YEAR; quit; data want; merge have(in=inh) del (in=ind); by ID YEAR; if inh and not ind; run;
New Contributor
Posts: 4

Re: can i delete row?

thank you so much!!

Super User
Posts: 9,682

Re: can i delete row?

data have;
input id $  year  x ;
cards ;
a  2000  2    
a  2001  5                    
b  2000  .                                   
b  2001  5                          
c  2000  3
c  2001  3
;
run;

proc sql;
select *
 from have
  group by id
   haing nmiss(x)=0;
quit;
New Contributor
Posts: 4

Re: can i delete row?

thank you very much!

It was a great help. thank you.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 6 replies
  • 311 views
  • 0 likes
  • 4 in conversation