Data Manipulation

[katie80]

Hi, 

I have a character variable with length of 9 that starts with 6 digits followed by two letters and ending in one digit: 000000LL0. 

I want to get rid of the last digit so that my new variable is of length 8 wihout the last digit, so convert var1 to var2: 

var1	var2
000369AM0	000369AM
000369AM2	000369AM
000369AM7	000369AM
000369AM3	000369AM
700369AD1	700369AD
700369AD5	700369AD

What is the easiest way to do this? 

Thanks !!!

[Astounding]

This is probably easiest:

data want;

set have;

length var2 $ 8;

var2 = var1;

run;

[katie80 · Accepted solution]

Thanks so much. 

[katie80]

Any change you could help me with this question as well? 

https://communities.sas.com/t5/SAS-Data-Management/Data-Manipulation-calculating-lagged-standard-dev...