topic Re: Drop statement must be included in set statement? in SAS Programming

Drop statement must be included in set statement?

SasStatistics — Tue, 18 May 2021 11:01:13 GMT

data indian(drop=MaxWindMPH) atlantic(drop=MaxWindKM) pacific;
	set pg2.storm_summary(drop=MinPressure); *Notice where drop is here;
	
	*drop=MinPressure; *This does not work? I have to include it into the set statement, but according to picture (see below) I should not have to?;
	
	length Ocean $ 8;
	Basin=upcase(Basin);
	StormLength=EndDate-StartDate;
	MaxWindKM=MaxWindMPH*1.60934;
	if substr(Basin,2,1)="I" then do;
		Ocean="Indian";
		output indian;
	end;
	else if substr(Basin,2,1)="A" then do;
		Ocean="Atlantic";
		output atlantic;
	end;
	else do;
		Ocean="Pacific";
		output pacific;
	end;
run;

Re: Drop statement must be included in set statement?

PaigeMiller — Tue, 18 May 2021 11:27:22 GMT

drop=MinPressure;

is not valid syntax. If you remove the equal sign, it should work. (When you use DROP as a data set option as in a SET statement, then the equal sign is required)

Re: Drop statement must be included in set statement?

Kurt_Bremser — Tue, 18 May 2021 11:40:10 GMT

The DROP statement is its own statement and cannot be part of another statement.

The DROP= dataset option can be part of any dataset specification (SET, MERGE, DATA, DATA=, CREATE TABLE AS, FROM).

I STRONGLY suggest you use the SAS documentation for your further studies, particularly the DROP Statement

Re: Drop statement must be included in set statement?

AMSAS — Tue, 18 May 2021 12:11:27 GMT

@SasStatistics
From the screenshot, it looks like you are taking some training. I would suggest that you go back over the Directing DATA Step Output section, as it probably explained the difference between Drop Statement and Drop Data Set Option.