BookmarkSubscribeRSS Feed
RandyStan
Fluorite | Level 6

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

1 REPLY 1
art297
Opal | Level 21
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

 

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1065 views
  • 4 likes
  • 2 in conversation