Weekday text to value

[kimih0223]

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

[sh0e]

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 ); 

[kimih0223]

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.

[sh0e]

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. );  

[Reeza · Accepted solution]

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#p0w6napahk...