Deleting rows selected rows from datasets

[Omodara]

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?

[Astounding]

An easy way:

data want;

set have;

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

run;

[Omodara]

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

[Omodara]

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

[Astounding]

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.

[Omodara]

Yes