topic Re: How to find date of week in SAS Procedures

How to find date of week

Gil_ — Wed, 13 Dec 2017 22:44:58 GMT

Hi I have a data set looks like this
Id. Schedule. Today. Output
A1. MON TUE. WED. False
A2. WED SAT. WED. True
A3. MON TUE WED. WED. TRUE

I need to look in col Today see if it matches in the schedule for True or False

Re: How to find date of week

novinosrin — Wed, 13 Dec 2017 22:57:58 GMT

data have;
input id $ Schedule & $12. Today $;
datalines;
A1. MON TUE WED False
A2. WED SAT WED True
A3. MON TUE WED WED TRUE
;

data want;
set have;
if index(STRIP(Schedule),STRIP( today))>0 then output='T';
ELSE OUTPUT='F';
RUN;

data want;
set have;
OUTPUT = ifc(INDEX(STRIP(Schedule),STRIP( today))>0, 'T', 'F');
RUN;

Re: How to find date of week

Reeza — Wed, 13 Dec 2017 22:56:02 GMT

Are periods your delimiter?

Re: How to find date of week

skyvalley81 — Wed, 13 Dec 2017 22:58:50 GMT

Hi Gil_

Check if this is what you want.

data have;
input id:$2. Schedule:$20. Today:$20.;
cards;
A1 MON-TUE WED
A2 WED-SAT WED
A3 MON-TUE-WED WED
;
run;

data want;
set have;
outputs = ifc(index(strip(upcase(Schedule)), strip(upcase(today)))>0, "TRUE", "FALSE");
run;

Re: How to find date of week

Reeza — Wed, 13 Dec 2017 23:00:37 GMT

Because you’re looking for words, I’d probably recommend INDEXW or FINDW

Re: How to find date of week

skyvalley81 — Wed, 13 Dec 2017 23:02:59 GMT

HI Reeza, i totally agree these are two alternative options too.

Re: How to find date of week

ballardw — Wed, 13 Dec 2017 23:16:43 GMT

@Gil_ wrote:
Hi I have a data set looks like this
Id. Schedule. Today. Output
A1. MON TUE. WED. False
A2. WED SAT. WED. True
A3. MON TUE WED. WED. TRUE

I need to look in col Today see if it matches in the schedule for True or False

Provide what the output is supposed to look like for that example.

And tell us where your variables start and end. It isn't easy to tell from that example. Be aware, the message windows of this forum reformat text by removing blank characters and possibly other things. If your text as shown above doesn't match what you intended to post, try again by pasting into a code box opened using the forum {I} menu icon. That text box will not reformat text.

Better is to provide data step code to recreate your data. Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712 will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the {i} icon or attached as text to show exactly what you have and that we can test code against.

Re: How to find date of week

Gil_ — Thu, 14 Dec 2017 18:28:54 GMT

Thanks for responding I put in your code
Data test4;
Set test4;
OUTPUT = ifc(INDEX(STRIP(Schedule),STRIP( today))>0, 'T', 'F');
RUN;

The output is F FOR all if the entries
Today date shows Thu. And schedule has and entry of THU AND OUT PUT IS FALSE SHOULD BE TRUE

Re: How to find date of week

Reeza — Thu, 14 Dec 2017 18:30:04 GMT

Does the full demo code above work?

If so, there's something different about your dataset that we don't know and can't see.

Re: How to find date of week

skyvalley81 — Thu, 14 Dec 2017 20:10:44 GMT

It would be good if you provide it us your data in data step format in order to understand what is going wrong.

The reasons that you get incorrect results might be different character cases in the schedule and today variables.

If this is the case you can use the UPCASE function in order to ensure that the variables have the same character cases or the i modifier in the FIND functions. Check the codes below:

output = ifc(index(strip(upcase(schedule)),strip(upcase(today)))>0, 'T', 'F');
output = ifc(find(strip(schedule),strip(today), "i")>0, 'T', 'F');

Also make sure that the variables have the same levels. For example if the schedule variable is MON and the today Monday this code wont work.

Hope it helps.

Re: How to find date of week

Gil_ — Fri, 15 Dec 2017 23:30:29 GMT

Ok I realized that the Today is a number and schedule is character .. I have
Data test4;
Set test4;
Name=put (today,4.0)
Run;

To convert today to number I get the sas format of 21E3. I need it to be character to defect Fri

Re: How to find date of week

Gil_ — Fri, 15 Dec 2017 23:30:54 GMT

To be Text FRI

Re: How to find date of week

novinosrin — Fri, 15 Dec 2017 23:44:43 GMT

do you mean your today is a variable that is a numeric sasdate value, if yes-

This may help-

OUTPUT = ifc(INDEX(STRIP(Schedule),STRIP( upcase(put(today, weekdate3.))))>0, 'T', 'F');

Re: How to find date of week

Gil_ — Sat, 16 Dec 2017 15:11:28 GMT

To answer 1st question yes its a number its formatted Downame3. I inserted your code the error I get is

72-185 the INDEX function call has too many arguments.

Error 71-185 the IFC function call does not have enough arguments

Re: How to find date of week

novinosrin — Sat, 16 Dec 2017 17:35:43 GMT

works for me :

data have;
input id:$2. Schedule:$20.;
cards;
A1 MON-TUE WED
A2 WED-SAT WED
A3 MON-TUE-FRI WED
;

data want;
set have;
today=today();
OUTPUT = ifc(INDEX(STRIP(Schedule),STRIP( upcase(put(today, Downame3.))))>0, 'T', 'F');
run;

You may have to show your data to help me understand better.

Re: How to find date of week

Gil_ — Mon, 18 Dec 2017 19:37:08 GMT

Thank you