Hi, I am wondering if it is possible to use case when expression in Proc SQL to replace missing values of a variable based on a single condition without creating a new variable. I know that I can work around this by creating a new variable and then dropping it later if needed but I wanted to find out if it is possible without creating a new variable. For e.g. If I have to replace missing values of Car_Model variable to Unspecified from Car_History dataset, can I do something like this ? Proc Sql; create table New_Cars as select distinct *, case when Car_Model is missing then 'Unspecified' end from Car_History; run;
... View more
