Hi,
I want to restrict my sample to have quasi-balanced pre-and post- observations..
For example,
Data original;
input supplier customer year post;
datalines;
1001 8001 2000 1
1001 8001 2001 1
1002 8006 1995 0
1002 8006 1996 0
1002 8006 1997 1
1002 8006 1998 1
1002 8006 1999 1
1003 8008 2005 0
1003 8008 2006 0
1003 8009 2006 0
1003 8009 2007 1
;
run;
I want to keep observations having both pre-and post- period. That is, I want to exclude observations having only (Post = 0s) or (Post = 1s).
So, I want to have like this datasets.. after coding;
Data hope;
input supplier customer year post;
datalines;
1002 8006 1995 0
1002 8006 1996 0
1002 8006 1997 1
1002 8006 1998 1
1002 8006 1999 1
1003 8009 2006 0
1003 8009 2007 1
;
run;
Thank you!
same as PG, did PG miss customer in group by?
Data original;
input supplier customer year post;
datalines;
1001 8001 2000 1
1001 8001 2001 1
1002 8006 1995 0
1002 8006 1996 0
1002 8006 1997 1
1002 8006 1998 1
1002 8006 1999 1
1003 8008 2005 0
1003 8008 2006 0
1003 8009 2006 0
1003 8009 2007 1
;
run;
proc sql;
create table hope as
select *
from original
group by supplier,customer
having count(distinct post) = 2
order by supplier, year;
quit;
select the suppliers with two post values:
proc sql;
create table hope as
select *
from original
group by supplier
having count(distinct post) = 2;
quit;
same as PG, did PG miss customer in group by?
Data original;
input supplier customer year post;
datalines;
1001 8001 2000 1
1001 8001 2001 1
1002 8006 1995 0
1002 8006 1996 0
1002 8006 1997 1
1002 8006 1998 1
1002 8006 1999 1
1003 8008 2005 0
1003 8008 2006 0
1003 8009 2006 0
1003 8009 2007 1
;
run;
proc sql;
create table hope as
select *
from original
group by supplier,customer
having count(distinct post) = 2
order by supplier, year;
quit;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.