Wondered if there is an easy way to recode a variable, and keep the same name and position. For example, using the attached code, I can recode variable Type in sashelp.cars, after that I want to call it Type and keep the same position. Imagine there are hundreds of variables. I don't want to list all of them to keep the order. Is there any easy way to do it with too many coding? PROC SQL;
CREATE TABLE want AS
SELECT Make,
Model,
case when Type in ("Hybrid", "Wagon")
then "Wagon"
else type
end as type,
Origin,
DriveTrain,
MSRP,
Invoice,
EngineSize,
Cylinders,
Horsepower,
MPG_City,
MPG_Highway,
Weight,
Wheelbase,
Length
FROM SASHELP.CARS;
QUIT;
... View more