topic Re: Deleting rows selected rows from datasets in Statistical Procedures

Deleting rows selected rows from datasets

Omodara — Fri, 06 Oct 2017 22:10:20 GMT

Please I have this set of data I want to delete rows 1-3, 5-6 and row 60

Which SAS code can I use?

Re: Deleting rows selected rows from datasets

Astounding — Fri, 06 Oct 2017 22:23:51 GMT

An easy way:

data want;

set have;

if _n_ in (1, 2, 3, 5, 6, 60) then delete;

run;

Re: Deleting rows selected rows from datasets

Omodara — Fri, 06 Oct 2017 22:29:39 GMT

I have tried it its showing empty table I suppose I should include the name of the data set some where. Let say tank id the original dataset name

Re: Deleting rows selected rows from datasets

Omodara — Fri, 06 Oct 2017 22:33:07 GMT

lets say the name of the initial data set is "tank" where how will I enter the code

Re: Deleting rows selected rows from datasets

Astounding — Sat, 07 Oct 2017 01:40:47 GMT

You mean this?

data want;

set tank;

if _n_ in (1, 2, 3, 5, 6, 60) then delete;

run;

But you will need to learn some basics. To be used in a SET statement, TANK has to be a SAS data set. So you need to learn how to get from a spreadsheet to a SAS data set.

Re: Deleting rows selected rows from datasets

Omodara — Sat, 07 Oct 2017 15:14:35 GMT

Yes