topic Re: Creating Week Number in each observation in SAS Programming https://communities.sas.com/t5/SAS-Programming/Creating-Week-Number-in-each-observation/m-p/281943#M57226 <P>Please try this.</P> <P>&nbsp;</P> <P>data want;<BR />set have;<BR />do week=1 to 52;<BR />&nbsp; &nbsp; output;<BR />end;<BR />run;</P> Mon, 04 Jul 2016 04:40:45 GMT stat_sas 2016-07-04T04:40:45Z Creating Week Number in each observation https://communities.sas.com/t5/SAS-Programming/Creating-Week-Number-in-each-observation/m-p/281942#M57225 <P>Hi SAS Community,</P> <P>&nbsp;</P> <P>I have a total of 2500 unique customer numbers and I want to include the variable 'week' in <STRONG>each customer observation</STRONG>. I will outline this into tabular format below.</P> <P>&nbsp;</P> <P>What do I have now?</P> <TABLE width="83"> <TBODY> <TR> <TD width="83">Customer ID</TD> </TR> <TR> <TD>EDDY</TD> </TR> <TR> <TD>CHRIS</TD> </TR> <TR> <TD>PETER</TD> </TR> <TR> <TD>MALCOMN</TD> </TR> <TR> <TD>DAVID</TD> </TR> <TR> <TD>EVANS</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>What do I want?</P> <TABLE width="147"> <TBODY> <TR> <TD width="83">Customer ID</TD> <TD width="64">Week</TD> </TR> <TR> <TD>EDDY</TD> <TD>1</TD> </TR> <TR> <TD>EDDY</TD> <TD>2</TD> </TR> <TR> <TD>EDDY</TD> <TD>3</TD> </TR> <TR> <TD>EDDY</TD> <TD>4</TD> </TR> <TR> <TD>EDDY</TD> <TD>5</TD> </TR> <TR> <TD>EDDY</TD> <TD>6</TD> </TR> <TR> <TD>EDDY</TD> <TD>7</TD> </TR> <TR> <TD>EDDY</TD> <TD>…</TD> </TR> <TR> <TD>EDDY</TD> <TD>52</TD> </TR> <TR> <TD>CHRIS</TD> <TD>1</TD> </TR> <TR> <TD>CHRIS</TD> <TD>2</TD> </TR> <TR> <TD>CHRIS</TD> <TD>3</TD> </TR> <TR> <TD>CHRIS</TD> <TD>4</TD> </TR> <TR> <TD>CHRIS</TD> <TD>5</TD> </TR> <TR> <TD>CHRIS</TD> <TD>6</TD> </TR> <TR> <TD>CHRIS</TD> <TD>7</TD> </TR> <TR> <TD>CHRIS</TD> <TD>…</TD> </TR> <TR> <TD>CHRIS</TD> <TD>52</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>…</TD> </TR> <TR> <TD>EVANS</TD> <TD>1</TD> </TR> <TR> <TD>EVANS</TD> <TD>2</TD> </TR> <TR> <TD>EVANS</TD> <TD>3</TD> </TR> <TR> <TD>EVANS</TD> <TD>4</TD> </TR> <TR> <TD>EVANS</TD> <TD>5</TD> </TR> <TR> <TD>EVANS</TD> <TD>6</TD> </TR> <TR> <TD>EVANS</TD> <TD>7</TD> </TR> <TR> <TD>EVANS</TD> <TD>…</TD> </TR> <TR> <TD>EVANS</TD> <TD>52</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Appreciate your help! Thanks.</P> <P>&nbsp;</P> <P>Dave</P> Mon, 04 Jul 2016 04:22:00 GMT https://communities.sas.com/t5/SAS-Programming/Creating-Week-Number-in-each-observation/m-p/281942#M57225 DavidLie 2016-07-04T04:22:00Z Re: Creating Week Number in each observation https://communities.sas.com/t5/SAS-Programming/Creating-Week-Number-in-each-observation/m-p/281943#M57226 <P>Please try this.</P> <P>&nbsp;</P> <P>data want;<BR />set have;<BR />do week=1 to 52;<BR />&nbsp; &nbsp; output;<BR />end;<BR />run;</P> Mon, 04 Jul 2016 04:40:45 GMT https://communities.sas.com/t5/SAS-Programming/Creating-Week-Number-in-each-observation/m-p/281943#M57226 stat_sas 2016-07-04T04:40:45Z