topic Re: Based on date create new variable in SAS Programming

Based on date create new variable

newbi — Fri, 04 Apr 2014 17:23:50 GMT

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:

Result i want:

Date_KEY	RID	Sales	Sales Start Day
03/01/2014	1	$1000	1
03/02/2014	1	$1500	2
03/03/2014	1	$2000	3
03/05/2014	2	$1000	1
03/06/2014	3	$5000	1

Thanks in advance.

Linlin — Fri, 04 Apr 2014 17:33:42 GMT

data want;

set have; /* your dataset name */

by rid;

if first.rid then sales_start_day=0;

sales_start_day+1;

run;

Quentin — Fri, 04 Apr 2014 17:36:09 GMT

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

newbi — Fri, 04 Apr 2014 18:13:38 GMT

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;