If X then do y with practice p201p03

maximek — Sat, 05 Dec 2020 12:16:00 GMT

Hello everyone,

In the first level of the practice dedicated to the first lesson of the second course, it is requested to create three tables : monument, park and other with the following conditions :

Drop Parktype for monument and park

Drop Region for the three tables.

The correct solution is :

data monument(drop=ParkType) park(drop=ParkType) other; 
    set pg2.np_yearlytraffic;
    if ParkType = 'National Monument' then output monument;
    else if ParkType = 'National Park' then output park;
    else output other;
    drop Region;
run;

But I tried to do it with "if then do" statements :

data monument park other;
	set pg2.np_yearlytraffic;
	drop Region;
	if ParkType = 'National Monument' then 
	do;
	drop Parktype;
	output monument;
	end;
	else if ParkType = 'National Park' then do;
	drop Parktype;
	output park;
	end;
	else output other;

run;

The issue being that now, the table other does not contain "Parktype" and I don't understand why is that so.

Any help would be greatly appreciated.

Regards

Re: If X then do y with practice p201p03

Cynthia_sas — Mon, 07 Dec 2020 18:22:03 GMT

Hi:
Please go back and review the material in Programming 2 on the DROP and KEEP statement. These statements cannot be executed conditionally. They are COMPILE time statements.
Cynthia

Re: If X then do y with practice p201p03

maximek — Sat, 26 Dec 2020 10:07:27 GMT

thanks for your kind answer

topic Re: If X then do y with practice p201p03 in Programming 1 and 2

If X then do y with practice p201p03

Re: If X then do y with practice p201p03

Re: If X then do y with practice p201p03