topic Re: Drop statement for dropping list of variables. in SAS Programming

Drop statement for dropping list of variables.

rajvir — Wed, 09 Aug 2017 04:43:49 GMT

Got stuck with a problem related to Drop statement.attached herewith the problem and its 4 options.

Please help me to find 1.

Thanks

Re: Drop statement for dropping list of variables.

Reeza — Wed, 09 Aug 2017 04:49:50 GMT

Post your questions directly into the forum, not as attachments. Many users will not download attachments.

Re: Drop statement for dropping list of variables.

Shmuel — Wed, 09 Aug 2017 06:12:23 GMT

There are two ways to use DROP statement:

1) data wnat(DROP=var1 var2 ...); /* with the equal sign */

set have;

... any code ...

run;

2) data want;

set have;

... any code ...

DROP var1 var2 ...; /* without the equal sign */

run;

Re: Drop statement for dropping list of variables.

Tom — Wed, 09 Aug 2017 06:44:26 GMT

Let's look at the choices.

B anc C are wrong because they have commas.

B and D are wrong because they dont have the equal sign that all dataset options require.

So A is the best answer.

But all four are wrong because the parenthesis themselves are not part of the DROP= dataset option. If you have other dataset options, like LABEL= or RENAME= they would all be nested inside the single set of () following the dataset name.

Re: Drop statement for dropping list of variables.

rajvir — Wed, 09 Aug 2017 17:40:08 GMT

Hello Tom

But if we look at the given code its doesnt seem like a drop dataset option .

It looks like a statement so should it be the option D but ofcourse as you said without the () brackets.

Re: Drop statement for dropping list of variables.

Tom — Wed, 09 Aug 2017 17:50:08 GMT

The question specifically asked for how to specify the drop using dataset options.

Re: Drop statement for dropping list of variables.

Reeza — Wed, 09 Aug 2017 18:50:22 GMT

@rajvir wrote:

Hello Tom

But if we look at the given code its doesnt seem like a drop dataset option .

It looks like a statement so should it be the option D but ofcourse as you said without the () brackets.

A good rule of thumb if you're not certain about something is to check the documentation. You may not always understand exactly what it's saying, but the examples will often help with that. Reading through the examples may help with your understanding of the DROP dataset option, versus the DROP statement.

DROP, data step option

https://support.sas.com/documentation/cdl/en/ledsoptsref/69751/HTML/default/viewer.htm#n15goor3q758g5n1eykstufkpdhy.htm

DROP, statement

http://support.sas.com/documentation/cdl/en/lestmtsref/69738/HTML/default/viewer.htm#n1capr0s7tilbvn1lypdshkgpaip.htm

Documentation examples/explanations:

http://support.sas.com/documentation/cdl/en/basess/68381/HTML/default/viewer.htm#p10jjd7e6qn396n1a22uvw3va3ao.htm

Re: Drop statement for dropping list of variables.

rajvir — Wed, 09 Aug 2017 19:39:03 GMT

oops sorry ...You are right ......