how to change values of a variable?

[srikanthyadav44]

Hi all, 

i am working on SAS 9.4 version. I need help on changing the values of a variable. 

I have to replace asset1 with 2000, asset2 with 2001, asset3 with 2002 and so on. it is unbalanced panel data of around 5000 companies with 19 years of time series observations from the year 2000 to 2018 My data set is like as follows. 

company   variable 

A	asset1
A	asset2
A	asset3
A	asset4
B	asset1
B	asset2
B	asset3
C	asset1
C	asset2
C	asset3
C	asset4
D	asset1
D	asset2
D	asset3

Thank you in advance.

[Kurt_Bremser]

newvar = 1999 + input(substr(variable,6),best.);

[PeterClemmensen]

Welcome to the SAS Community 🙂

data have;
input company $ variable $;
datalines;
A asset1
A asset2
A asset3
A asset4
B asset1
B asset2
B asset3
C asset1
C asset2
C asset3
C asset4
D asset1
D asset2
D asset3
;

data want;
    set have;
    newvar=sum(input(compress(variable, '', 'kd'), 8.), 1999);
run;

[srikanthyadav44 · Accepted solution]

thanks a lot. the code is working excellently. 

[srikanthyadav44]

dear draycut

can you please tell me know to change the code when i have 25 observations for each company?

thanks in advance 

[Kurt_Bremser]

Have you tried the code with 25 obs per company? If yes, where did the result not meet your expectations?

[srikanthyadav44]

yes. I tried. but all the observations of each  company are getting the value of '1999' only. 

my data starts at the year 1994 and ends at 2018. 

Kindly help me in changing the  previously used code to get the desired output. 

thanks in advance

[Kurt_Bremser]

Since @PeterClemmensen 's code DOES work (just run it), your data must be different than what you showed in your initial post. Please post correct example data in a data step with datalines, as seen in @PeterClemmensen 's post.