DATA Step, Macro, Functions and more

Deleting lines in one Variable but not others

Reply
Occasional Contributor
Posts: 8

Deleting lines in one Variable but not others

My Data is as follows

 

Var_A   Var_B   Var_C

5            7            2

3             8           3

1           5            6

14           7            0

7          11          13

15        5            3

 

I want to delete lines > 4  of Var_A but keep all other variables the same

So my table looks like

Var_A   Var_B   Var_C

5            7            2

3            8           3

1            5            6

14          7            0

              11          13

              5            3

Does SAS permit me to do this? And how?

    Randy

PROC Star
Posts: 7,360

Re: Deleting lines in one Variable but not others

data have;
  input Var_A   Var_B   Var_C;
  cards;
5            7            2
3             8           3
1           5            6
14           7            0
7          11          13
15        5            3
;

data want;
  set have;
  if _n_ gt 4 then call missing(Var_A);
run;

Art, CEO, AnalystFinder.com

 

Ask a Question
Discussion stats
  • 1 reply
  • 92 views
  • 3 likes
  • 2 in conversation