topic Re: Creating a dummy variable in SAS Enterprise Guide

Creating a dummy variable

matt23 — Tue, 31 Jul 2018 13:10:54 GMT

I am trying to create a dummy variable where if weekday=1, then Monday=1...

so far I have this:

data want
set have;
if weekday=1 then mon=1;
else mon=0;
run;

but this does not actually create the variable, what am I missing?

Re: Creating a dummy variable

PaigeMiller — Tue, 31 Jul 2018 13:13:25 GMT

We would need to see a (portion of) your data. We can't answer your question without it. (Or better yet, YOU look at the data and see if you can figure out why this simple code isn't working, before asking us. Don't actually ask us without YOU looking at the data first to see if you can figure it out)

Re: Creating a dummy variable

PeterClemmensen — Tue, 31 Jul 2018 13:14:29 GMT

Do you have a variable called weekday in your data? Or do you simply have a date variable?

If the latter is the case, you should use the WEEKDAY Function instead.

Anyway, always a good idea to specify what your data looks like

Re: Creating a dummy variable

matt23 — Tue, 31 Jul 2018 13:22:29 GMT

I do have a variable called weekday that goes from 0 to 6

Re: Creating a dummy variable

matt23 — Tue, 31 Jul 2018 13:23:24 GMT

nvm I got it working

Re: Creating a dummy variable

Astounding — Tue, 31 Jul 2018 13:24:59 GMT

Did you read the log?

You are missing a semicolon at the end of the DATA statement. Depending on the setting for system options, using SET as a data set name may or may not generate an error message. You will have to check to see whether your original data set is intact or not.

Re: Creating a dummy variable

matt23 — Tue, 31 Jul 2018 13:27:46 GMT

Sorry, one more question:

if this works, if weekday=1 then mon=1;
else mon=0;

then how would I do if weekday=2,3,4 then TWT=1 ??

Re: Creating a dummy variable

Astounding — Tue, 31 Jul 2018 13:31:59 GMT

if weekday in (2, 3, 4) then TWT=1;

Re: Creating a dummy variable

matt23 — Tue, 31 Jul 2018 13:42:38 GMT

how would I do that if I want a variables that is between two values like between 75 and 85? (75:85) only gives me full values but I have decimals in them so this doesn't work and the statement 'between' does not seem to work

Re: Creating a dummy variable

PaigeMiller — Tue, 31 Jul 2018 13:45:00 GMT

You have to stop telling us "doesn't work". You have to explain what happened and what you expected to happen. You have to show us the SASLOG.

Re: Creating a dummy variable

matt23 — Tue, 31 Jul 2018 13:47:00 GMT

25         if weekday=0 then sun=1;
26         else sun=0;
27         if Temperature =< 75 then low=1;
28         else low=0;
29         if Temperature between 75 and 85 then mid=1;
                          _______
                          388
                          202
ERROR 388-185: Expecting an arithmetic operator.

I'm sorry, I just thought it would be enough

won't happen again

Re: Creating a dummy variable

Astounding — Tue, 31 Jul 2018 15:17:57 GMT

if (75 <= var <= 85) then .......

Re: Creating a dummy variable

ballardw — Tue, 31 Jul 2018 21:00:08 GMT

@Astounding wrote:

if weekday in (2, 3, 4) then TWT=1;

Twt= weekday in (2, 3, 4);

Avoids need for Else twt=0.