Sas

[Sowmya12]

Col1
  2019-01-03
2019-03-01t11.30
2019-04-09
2014-02-03


I need to get the other column as
Col2
2019-03-01t11.30
2019-04-09
2014-02-03
2014-02-03

I have the cold and I need to get the col2

[japelin]

Do you mean you want to get col2 from col1?
It looks like 2019-01-03 is missing and 2014-02-03 is duplicated, please provide the conditions.

[PeterClemmensen]

What is the logic here?

[Sowmya12]

I need the dates from first column by leaving the first date from first
column.
Second date from first column should be the first date for new column. In
that way sequence should generate
Example:
Col1
2019-04-09
2019-07-08
2014-02-03
The output new column should be
Col2
2019-07-08
2014-02-03
2014-02-03

[japelin]

how about this code?

data have;
  input dt1:yymmdd10.;
  format dt1 yymmdd10.;
datalines;
2019-04-09
2019-07-08
2014-02-03
;
run;

data temp;
  set have;
  key=_n_;
run;
proc sort data=temp;
  by descending key;
run;
data next;
  set temp;
  retain dt2;
  format dt2 yymmdd10.;
  by descending key;
  if _n_=1 then dt2=dt1;
  output;
  dt2=dt1;
run;
proc sort data=next out=want(drop=key);
  by key;
run;