Missing values on SAS Guide/Visual Analytics

bryanssilveira — Mon, 11 Jun 2018 14:30:44 GMT

Hi,

I have a base data that have some missing values in some columns. I do a upload from Guide to Visual Analytics by LARS and make calculations with this variable that have missing values. The problem is that SAS Visual Analytics don't use this line with missing values. Can I replace this missing values by zero on SAS Enterprise Guide ou Visual Analytics ? And how can I do this ?

Best Regards,

Bryan

Re: Missing values on SAS Guide/Visual Analytics

FredrikE — Tue, 12 Jun 2018 06:17:36 GMT

You can create a calculated variable either in EG or in VA:

if missing(var) then 0 else var

//Fredrik

topic Re: Missing values on SAS Guide/Visual Analytics in SAS Visual Analytics

Missing values on SAS Guide/Visual Analytics

Re: Missing values on SAS Guide/Visual Analytics