topic Re: how to change values of a variable? in New SAS User

how to change values of a variable?

srikanthyadav44 — Wed, 03 Jul 2019 12:08:33 GMT

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.

Re: how to change values of a variable?

Kurt_Bremser — Wed, 03 Jul 2019 12:13:24 GMT

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

Re: how to change values of a variable?

PeterClemmensen — Wed, 03 Jul 2019 12:13:55 GMT

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;

Re: how to change values of a variable?

srikanthyadav44 — Thu, 04 Jul 2019 09:26:45 GMT

thanks a lot. the code is working excellently.

Re: how to change values of a variable?

srikanthyadav44 — Fri, 05 Jul 2019 10:39:08 GMT

dear draycut

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

thanks in advance

Re: how to change values of a variable?

Kurt_Bremser — Fri, 05 Jul 2019 10:45:16 GMT

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

Re: how to change values of a variable?

srikanthyadav44 — Sat, 06 Jul 2019 18:46:10 GMT

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

Re: how to change values of a variable?

Kurt_Bremser — Sat, 06 Jul 2019 19:34:05 GMT

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.