topic Re: Weekday text to value in SAS Programming

Weekday text to value

kimih0223 — Thu, 30 Jun 2016 14:46:10 GMT

Is there a function in SAS to that converts "Sunday" = 1, "Monday" = 2, etc. or should I just write the codes to do it?

Re: Weekday text to value

sh0e — Thu, 30 Jun 2016 14:51:17 GMT

Check out the WEEKDAY function which returns a number (1 to 7, I think) based on a SAS date. For example,

day_no = WEEKDAY( SASdate );

Re: Weekday text to value

Reeza — Thu, 30 Jun 2016 14:57:43 GMT

I think you need to write the code 😞

Typically you can browse by category for reference.

https://support.sas.com/documentation/cdl/en/lefunctionsref/67960/HTML/default/viewer.htm#p0w6napahk6x0an0z2dzozh2ouzm.htm

Re: Weekday text to value

kimih0223 — Thu, 30 Jun 2016 14:59:03 GMT

I believe this returns weekday based on SAS date value which is numeric.

I was wondering if there's any function that converts actual text i.e. "Sunday" into 1.

Re: Weekday text to value

sh0e — Thu, 30 Jun 2016 15:04:00 GMT

The WEEKDAY function does use a SAS date. I assumed that you had the date availabel as a SAS date. If it is just a matter of mapping a string to a value, that's a job for PROC FORMAT.

proc format;
  value $day2num
  'Sunday' = '1'
  'Monday' = '2'
  ...
  ;
  run;

data x;
  daynum = put( daystring, $day2num. );