topic Re: Dummy variable in SAS Studio

Dummy variable

Kati — Fri, 31 Jan 2020 15:58:18 GMT

Hi,

I need to create dummy variable EVENT, which take value one in trading days 0 and +1, I have a column called window, which present trading days, which values goes -16 through + 16, so when window is 0 and 1, event should get value 1, and otherwise event=0

How to do this?

I get error message that statement is not valid or it is used out of proper order.

I use SAS University Edition

have tried to do this:

event=0,

if window=1 or window=0 then event=1;

Thank you,

-beginner

Re: Dummy variable

ed_sas_member — Fri, 31 Jan 2020 16:11:53 GMT

HI @Kati

It seems you have a typo -> the coma should be a semi-colon:

event=0, -> event=0;

if window=1 or window=0 then event=1;

Re: Dummy variable

Kati — Fri, 31 Jan 2020 16:13:15 GMT

Well, in actual code it is a ;

Re: Dummy variable

Kati — Fri, 31 Jan 2020 16:14:34 GMT

Seems that I have some other problem as well, can you help with that?

Re: Dummy variable

ed_sas_member — Fri, 31 Jan 2020 16:14:55 GMT

OK. Could you please share a sample of your data and the full data step code you are using ?

Re: Dummy variable

ed_sas_member — Fri, 31 Jan 2020 16:19:23 GMT

Here is some code that could answer your question.

Could you please compare your code ?

data have;
	input window;
	datalines;
-16
1
7
0
;
run;

data want;
	set have;
	event = 0;
	if window = 0 or window = 1 then event = 1;
run;