The SAS Output Delivery System and reporting techniques

Need to change value of variable in datastep only..

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 88
Accepted Solution

Need to change value of variable in datastep only..

Hi maybe its silly question still i want to know,

I have dataset called test having variable name with value abc so now i want to change the value from abc to xyz using only datastep and no proc. How can i do that.

i have below one (one observation and one variable only)

name         

====

abc

and i want below one using only datastep no proc how can i do that?

name

====

xyz


Regrads,

Tushar J


Accepted Solutions
Solution
‎05-14-2013 11:00 AM
Grand Advisor
Posts: 17,308

Re: Need to change value of variable in datastep only..

you probably have more conditions, but since you haven't stated them the following does what you'd want...

data test2;

set test;

name="xyz";

run;

View solution in original post


All Replies
Solution
‎05-14-2013 11:00 AM
Grand Advisor
Posts: 17,308

Re: Need to change value of variable in datastep only..

you probably have more conditions, but since you haven't stated them the following does what you'd want...

data test2;

set test;

name="xyz";

run;

Contributor
Posts: 36

Re: Need to change value of variable in datastep only..

If you have a number of records you may want to change the name only when it is abc.

data test2;

  set test;

  if name='abc' then name='xyz';

run;

Frequent Contributor
Posts: 88

Re: Need to change value of variable in datastep only..

Thanks Reeza and barheat  it worked.

Regards,

Tushar Jagtap

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 281 views
  • 2 likes
  • 3 in conversation