topic SAS Viya: Prepare Data; How to replace missing values in the dataset using Data Step? in SAS Viya https://communities.sas.com/t5/SAS-Viya/SAS-Viya-Prepare-Data-How-to-replace-missing-values-in-the/m-p/696756#M739 <P>Hello SAS community.</P><P>&nbsp;</P><P>I am learning how to clean data using Prepare Data page in SAS Viya. Im using a mock data which I have imported into the CAS library and wanted to replace the missing values inside the dataset with the mode of the column as all the data contains categorical type of data.&nbsp;</P><P>&nbsp;</P><P>Below is how I wrote my coding using Proc Stdize procedure but it does not work.&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 999px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/51397i861FD8CB6E00FDB3/image-size/large?v=v2&amp;px=999" role="button" title="image.png" alt="image.png" /></span></P><P>&nbsp;</P><P>Can anyone help me to provide the solution to this?</P> Thu, 05 Nov 2020 02:51:28 GMT nurShahirah 2020-11-05T02:51:28Z SAS Viya: Prepare Data; How to replace missing values in the dataset using Data Step? https://communities.sas.com/t5/SAS-Viya/SAS-Viya-Prepare-Data-How-to-replace-missing-values-in-the/m-p/696756#M739 <P>Hello SAS community.</P><P>&nbsp;</P><P>I am learning how to clean data using Prepare Data page in SAS Viya. Im using a mock data which I have imported into the CAS library and wanted to replace the missing values inside the dataset with the mode of the column as all the data contains categorical type of data.&nbsp;</P><P>&nbsp;</P><P>Below is how I wrote my coding using Proc Stdize procedure but it does not work.&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 999px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/51397i861FD8CB6E00FDB3/image-size/large?v=v2&amp;px=999" role="button" title="image.png" alt="image.png" /></span></P><P>&nbsp;</P><P>Can anyone help me to provide the solution to this?</P> Thu, 05 Nov 2020 02:51:28 GMT https://communities.sas.com/t5/SAS-Viya/SAS-Viya-Prepare-Data-How-to-replace-missing-values-in-the/m-p/696756#M739 nurShahirah 2020-11-05T02:51:28Z Re: SAS Viya: Prepare Data; How to replace missing values in the dataset using Data Step? https://communities.sas.com/t5/SAS-Viya/SAS-Viya-Prepare-Data-How-to-replace-missing-values-in-the/m-p/697780#M740 <P>Moved to SAS Viya community.</P> Tue, 10 Nov 2020 00:58:56 GMT https://communities.sas.com/t5/SAS-Viya/SAS-Viya-Prepare-Data-How-to-replace-missing-values-in-the/m-p/697780#M740 ChrisNZ 2020-11-10T00:58:56Z