SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Extract Week from first.date

Accepted Solution Solved
Reply
Contributor
Posts: 64
Accepted Solution

Extract Week from first.date

[ Edited ]

Hi,

data have;

input id date ;

datalines;                     

id   date

1  01/01/2016

1  01/14/2016

1  01/22/2016

2 02/03/2016

2 04/03/2016

run;

 

 

I want to extract week from the first date for the id (observation) and add the same value to others even if the others are different eg

Data want

id  data                week

1  01/01/2016         1

1  01/14/2016         1

1  01/22/2016         1

2 02/08/2016          2

2 04/25/2016          2

 

 

Thank you


Accepted Solutions
Solution
‎04-07-2016 09:42 PM
Super Contributor
Posts: 490

Re: Extract Week from first.date

data have;
input id date mmddyy10. ;
cards;                     
1 01/01/2016
1 01/14/2016
1 01/22/2016
2 02/16/2016
2 04/03/2016
;
run;
 proc sort  data=have;
 by id date;
 run;
 
 
 data want ;
 set have;
 by id;
 retain week;
 if first.id then  week=intck('week',intnx('month',date,0),date)+1; 
 run;
   

View solution in original post


All Replies
Solution
‎04-07-2016 09:42 PM
Super Contributor
Posts: 490

Re: Extract Week from first.date

data have;
input id date mmddyy10. ;
cards;                     
1 01/01/2016
1 01/14/2016
1 01/22/2016
2 02/16/2016
2 04/03/2016
;
run;
 proc sort  data=have;
 by id date;
 run;
 
 
 data want ;
 set have;
 by id;
 retain week;
 if first.id then  week=intck('week',intnx('month',date,0),date)+1; 
 run;
   
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 266 views
  • 1 like
  • 2 in conversation