topic Re: Deleting Rows in SAS Programming

Deleting Rows

drichmo1 — Sat, 27 Aug 2016 00:26:56 GMT

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

Re: Deleting Rows

mohamed_zaki — Sat, 27 Aug 2016 00:39:59 GMT

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

Re: Deleting Rows

drichmo1 — Sat, 27 Aug 2016 01:20:18 GMT

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;

Re: Deleting Rows

Reeza — Sat, 27 Aug 2016 02:03:26 GMT

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

output out=want n=/autoname;