DATA Step, Macro, Functions and more

Based on date create new variable

Accepted Solution Solved
Reply
SAS Employee
Posts: 73
Accepted Solution

Based on date create new variable

Would someone be able to offer advice on how I can do the following:

Based on date_key i would like to create new column which can provide Sales start day (1st day of sale).  For example:

Date_KEYRIDSales
03/01/20141$1000
03/02/20141$1500
03/03/20141$2000
03/05/20142$1000
03/06/20143$5000

Result i want:

Date_KEYRIDSalesSales Start Day
03/01/20141$10001
03/02/20141$15002
03/03/20141$20003
03/05/20142$10001
03/06/20143$50001

Thanks in advance.


Accepted Solutions
Solution
‎04-04-2014 01:33 PM
Super Contributor
Posts: 1,636

Re: Based on date create new variable

data want;

set have; /* your dataset name */

by rid;

if first.rid then sales_start_day=0;

sales_start_day+1;

run;

View solution in original post


All Replies
Solution
‎04-04-2014 01:33 PM
Super Contributor
Posts: 1,636

Re: Based on date create new variable

data want;

set have; /* your dataset name */

by rid;

if first.rid then sales_start_day=0;

sales_start_day+1;

run;

PROC Star
Posts: 1,322

Re: Based on date create new variable

Hi,

Not sure I follow your logic, but I think below will make your WANT table:

data want;

  set have;

  by RID Date_Key;

  if first.RID then SalesStartDay=0;

  if first.Date_Key then SalesStartDay ++ 1;

run;

HTH

SAS Employee
Posts: 73

Re: Based on date create new variable

Thanks for all your help.

Linlin solutin worked:

data want;

set have; /* your dataset name */

by rid;

if first.rid then sales_start_day=0;

sales_start_day+1;

run;

🔒 This topic is solved and locked.

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

Discussion stats
  • 3 replies
  • 205 views
  • 0 likes
  • 3 in conversation