BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Saurabh_Rana
Obsidian | Level 7

Whenever I Impute a variable in SAS Viya interface in "Model Build" it doesn't replace the existing variable but creates a new variable.

Saurabh_Rana_1-1600068407177.png

 

 

Even when I convert the format of a variable it creates a new variable instead of updating the existing one.

Saurabh_Rana_0-1600068150951.png

 

Is there any way I can impute/convert a variable without creating a new variable?

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
SophiaRowland
SAS Super FREQ

Yes, the imputation node does not replace the existing variable (https://go.documentation.sas.com/?activeCdc=vdmmlcdc&cdcId=capcdc&cdcVersion=8.5&docsetId=vdmmlref&d...) I would think of the "Model Build" interface as more of a model-pipeline builder. This model pipeline contains a series of steps to process data and build supervised machine learning models. As new data comes in, this model pipeline has everything it needs to process and score new data with minimal intervention. 

 

In the "Prepare Data" interface,  I would recommend creating the imputed column, removing the existing column, and then you can rename the imputed column if you like (https://go.documentation.sas.com/?cdcId=dprepcdc&cdcVersion=2.5&docsetId=datastudioadv&docsetTarget=...). When you save the table, you can overwrite the existing table and that should allow you to replace the existing column with the imputed column (https://go.documentation.sas.com/?cdcId=dprepcdc&cdcVersion=2.5&docsetId=datastudioadv&docsetTarget=...). 

 

If you like coding in SAS, you can also use the "Develop SAS" interface as well either through a DATA step or an imputation action. Does this answer your question?  

View solution in original post

1 REPLY 1
SophiaRowland
SAS Super FREQ

Yes, the imputation node does not replace the existing variable (https://go.documentation.sas.com/?activeCdc=vdmmlcdc&cdcId=capcdc&cdcVersion=8.5&docsetId=vdmmlref&d...) I would think of the "Model Build" interface as more of a model-pipeline builder. This model pipeline contains a series of steps to process data and build supervised machine learning models. As new data comes in, this model pipeline has everything it needs to process and score new data with minimal intervention. 

 

In the "Prepare Data" interface,  I would recommend creating the imputed column, removing the existing column, and then you can rename the imputed column if you like (https://go.documentation.sas.com/?cdcId=dprepcdc&cdcVersion=2.5&docsetId=datastudioadv&docsetTarget=...). When you save the table, you can overwrite the existing table and that should allow you to replace the existing column with the imputed column (https://go.documentation.sas.com/?cdcId=dprepcdc&cdcVersion=2.5&docsetId=datastudioadv&docsetTarget=...). 

 

If you like coding in SAS, you can also use the "Develop SAS" interface as well either through a DATA step or an imputation action. Does this answer your question?  

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 937 views
  • 0 likes
  • 2 in conversation