- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Is there a function in SAS to that converts "Sunday" = 1, "Monday" = 2, etc. or should I just write the codes to do it?
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
I think you need to write the code 😞
Typically you can browse by category for reference.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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 );
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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. );
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
I think you need to write the code 😞
Typically you can browse by category for reference.