topic Re: Data Manipulation in SAS Data Management

Data Manipulation

katie80 — Tue, 17 Nov 2015 22:06:50 GMT

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:

What is the easiest way to do this?

Thanks !!!

Astounding — Tue, 17 Nov 2015 22:18:46 GMT

This is probably easiest:

data want;

set have;

length var2 $ 8;

var2 = var1;

run;

katie80 — Tue, 17 Nov 2015 22:20:41 GMT

Thanks so much.

katie80 — Tue, 17 Nov 2015 22:32:10 GMT

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