DATA Step, Macro, Functions and more

Deleting Rows

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 9
Accepted Solution

Deleting Rows

Does anyone know how I can delete exrta rows? I really just want to keep the first row and delete all others. Thanks!


Accepted Solutions
Solution
‎08-26-2016 10:24 PM
Super User
Posts: 17,819

Re: Deleting Rows

You can select your output statistics by specifying them after the out= 

 

output out=want n=/autoname;

 

View solution in original post


All Replies
Super Contributor
Posts: 490

Re: Deleting Rows

What rows or rows in what? Give example of your data set

Occasional Contributor
Posts: 9

Re: Deleting Rows

Hi,

 

I am using a data set that I imported from excel. I used  proc means in order to create a new set of rows that shows the N, min, max, std, and mean. I just want to keep the row that show N, number of observation for each variable, which is the first row.

 

Here is my code:

 

proc means noprint data=one N;
var A B C D E;
  output out=one2;
run;

data one3 (keep = A B C D E);
  set one2 one (in=in2);
run;

 

 

Solution
‎08-26-2016 10:24 PM
Super User
Posts: 17,819

Re: Deleting Rows

You can select your output statistics by specifying them after the out= 

 

output out=want n=/autoname;

 

☑ This topic is SOLVED.

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

Discussion stats
  • 3 replies
  • 299 views
  • 2 likes
  • 3 in conversation