topic Re: Creating the same column but shifted by one position in SAS Programming

Creating the same column but shifted by one position

Hugo_B — Tue, 21 May 2019 10:32:58 GMT

Hello I have the following data:

DATA HAVE;
enfile cards turnover;
input columnA $ columnB $ columnC $;
datalines;
AAAA aaaa hello1
BBBB bbbb hello2
CCCC cccc hello3
DDDD dddd hello4
EEEE eeee hello5
;
RUN;

I want to add a column representing the leading ColumnA;

And have something like:

DATA WANT;
enfile cards turnover;
input columnA $ columnB $ columnC $ leadingcolumnA $;
datalines;
AAAA aaaa hello1 BBBB
BBBB bbbb hello2 CCCC
CCCC cccc hello3 DDDD
DDDD dddd hello4 EEEE
EEEE eeee hello5 
;
RUN;

When I do

DATA want;
merge have have(firstobs=2 Rename=columnA=LeadingColumnA);
run;

It shifted the ColumnB and ColumnC as well, which is not what I want.

Do you have any Idea how to do that ?

Thank you

Re: Creating the same column but shifted by one position

novinosrin — Tue, 21 May 2019 10:56:18 GMT

Hi @Hugo_B you missed keep=columnA. So without that, you are allowing B,C to be overwritten.

merge have have(firstobs=2 Rename=columnA=LeadingColumnA keep=columnA);

Re: Creating the same column but shifted by one position

Jagadishkatam — Tue, 21 May 2019 10:53:13 GMT

Please try

data want;
merge have have(firstobs=2 keep=columna rename=(columna=last)) ;
run;