topic deleting obs with conditions in SAS Programming

deleting obs with conditions

Amalik — Sat, 28 Apr 2018 04:27:01 GMT

Hi,

If my data looks like follows, how do I drop permnos where (A200801--A200805) contains less than say 4 observations?

PGStats — Sat, 28 Apr 2018 04:54:14 GMT

If those variables are numeric and you want to delete observations with less than 4 non missing values, then:

if n(of A200801 -- A200805) < 4 then delete;