topic Re: Sas in SAS Programming

Sas

Sowmya12 — Wed, 14 Apr 2021 06:21:04 GMT

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

Re: Sas

japelin — Wed, 14 Apr 2021 07:12:04 GMT

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.

Re: Sas

PeterClemmensen — Wed, 14 Apr 2021 07:17:24 GMT

What is the logic here?

Re: Sas

Sowmya12 — Wed, 14 Apr 2021 07:24:56 GMT

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

Re: Sas

japelin — Wed, 14 Apr 2021 07:45:25 GMT

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;