How to sort by date and create two new data sets.

ebonfil89 — Fri, 23 Feb 2018 00:45:35 GMT

Hello,

I am in need of some help.

I have a data set that that contains 7000 observations and one of the variables is wear-date. Wear date specifies the date the data was recorded. The format for wear date is (i.g. 11/9/2014).

I would like to create two data sets from one main data set. One for weekday observations and one for weekend observations. Therefore I need to sort dates by weekday and weekends.

I was told to use the "weekday function", however, I am not sure if this is in a data or proc step.

Any help would be appreciated, I am a beginner, and I am using SAS studio. Thank you.

Below is an example data set.

ID      wearDate   sed   wearTime (MIN)
281    11/9/14   667   984
282 11/10/14   792   1009
283    11/11/14   674   875
284    11/12/14   785   1029
285    11/13/14   684   909
286    11/14/14   662   878

Re: How to sort by date and create two new data sets.

Reeza — Fri, 23 Feb 2018 01:09:54 GMT

Functions are used in a data step or PROC SQL, not in other PROCS.

If you review the documentation for WEEKDAY() it returns 1-7, with 1/7 being weekends so you can classify your dates. Then you can separate them. I'm not sure why you need to sort.

1. Create a new variable using the WEEKDAY function to get the weekday

2. Create another new variable that shows if it's a weekend or weekday

Why do you need separate data steps? It's unlikely you actually do need a separate data sets.

data identify_weekday;

set have; *this should be your input data set;

weekDayNumber = weekday(date); *get weekday;

If weekDayNumber in (1, 7) then weekDayType='Weekend';
else if weekDayNumber in (2:6) then weekDayType='Weekday';
else weekDayType='CHECKME';

run;

*Check coding is correct;
proc freq data=identify_weekday;
table weekDayType*weedDayNumber;
run;

*See summaries by weekdayType;
proc means data=identify_weekday;
class weekDayType;
var wearTime;
run;

@ebonfil89 wrote:

Hello,

I am in need of some help.

I have a data set that that contains 7000 observations and one of the variables is wear-date. Wear date specifies the date the data was recorded. The format for wear date is (i.g. 11/9/2014).

I would like to create two data sets from one main data set. One for weekday observations and one for weekend observations. Therefore I need to sort dates by weekday and weekends.

I was told to use the "weekday function", however, I am not sure if this is in a data or proc step.

Any help would be appreciated, I am a beginner, and I am using SAS studio. Thank you.

Below is an example data set.

ID      wearDate   sed   wearTime (MIN)
281    11/9/14   667   984
282 11/10/14   792   1009
283    11/11/14   674   875
284    11/12/14   785   1029
285    11/13/14   684   909
286    11/14/14   662   878

topic How to sort by date and create two new data sets. in SAS Procedures

How to sort by date and create two new data sets.

Re: How to sort by date and create two new data sets.