Recode variable keeping the same name and position

[Rabelais]

@Tom @Quentin So the code by @mkeintz in order to work should be changed in this way (the only differences are at lines 8 and 15). Do you agree?

proc sql  noprint;
  create view vcars as select 
    case when type='Hybrid' then 'Hyb' 
         when type='Sedan'  then 'Sed' 
         when type='Sports' then 'Spo' 
         when type='Truck'  then 'Trk' 
         else type
    end as type_new
   ,*
  from sashelp.cars;
quit;

data want;
  set sashelp.cars (obs=0)
  vcars(drop=type rename=(type_new=type));
run;

[Kurt_Bremser]

In a case like yours, where the type and length of the variable do not change, this will do it:

data want;
set sashelp.cars;
type = ifc(type = 'Hybrid','Wagon`,type);
run;

[sasecn]

Thanks.

[sasecn]

Thank you for all the help! Great explanation from everyone 😀

[SASKiwi]

@sasecn  - Please help us by updating your post as answered if you are happy with the responses.