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 Employee

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 Employee

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?  

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

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
  • 361 views
  • 0 likes
  • 2 in conversation