Hi everyone,  I am beginner and a person who are newly learning SAS. I am trying to data pre-processing and have question. I can calculate mean for numeric type of attribute in SAS well. Here have question! In case of char type of attribute, how can we get mean? (Logically thinking, chart type attribute cannot calculate mean I think. In this case, to handle missing value, Can i use frequency result?)   For example, below is frequency result for job. I think NA is missing value here and want to replace to handle it. I can find the most high column of result : management. And I thought, I can replace the NA result to management. Is it okay? Or Is there any solution can you advice me?? Appreciate so much in advanced ... View more

Hi all,   I am currently trying to create table from csv file. In the file, there is two time format column.  For this columns, i tried to create table with time format with below codes. data carinsurance_train; infile "/home/eunvi920/assignment/carInsurance_train.csv" dlm=',' firstobs=2; input Id Age Job $ Marital $ Education $ Default Balance HHInsurance CarLoan Communication $ LastContactDay LastContactMonth $ NoOfContacts DaysPassed PrevAttempts Outcome $ CallStart time11. CallEnd time11. CarInsurance $; format CallStart time8. CallEnd time8.; put callstart=time8. callend=time8.; run; Table had created well but CallStart and CallEnd values are displayed as "."(dot). CSV can see the time exactly now.  example csv / sas result How can i key in time values from csv to sas well? If my code has problem, please kindly let me know.   Thank you  ... View more