SAS Support Communities

nurShahirah · ‎11-13-2020

Hi Mipate, I encounter almost the same problem with you when I try to parse my datetime data. I uploaded my data from a csv file and convert the format of the date column in SAS Viya into DDMMYY. format. But when I tried to parse the converted date column, the parse month and year did not gave me the value I was expecting. Eg: original date is 20/8/2020, but the parse month is 1 and parse year is 47. Can you advise on this? Thanks. Nur.

nurShahirah · ‎11-04-2020

Hello SAS community. 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. Below is how I wrote my coding using Proc Stdize procedure but it does not work. Can anyone help me to provide the solution to this?

Online Status	Offline
Date Last Visited	‎11-29-2021 02:02 AM

SAS Support Communities

Re: VA format is not working with parsing a datetime

SAS Viya: Prepare Data; How to replace missing values in the dataset u...

Re: How to incorporate 2 tables in one data visualisation

Re: VA format is not working with parsing a datetime

SAS Viya: Prepare Data; How to replace missing values in the dataset u...

Follow Us

What is...