topic Re: sas visual analytics missing value in SAS Visual Analytics

sas visual analytics missing value

Rajesh_02 — Tue, 13 Jun 2023 12:12:12 GMT

how to show 0 instead of (missing) in sas va 8.5.1 , when there is no data available

Re: sas visual analytics missing value

Madelyn_SAS — Tue, 13 Jun 2023 13:34:33 GMT

Are there entire rows missing in the data, or do you simply need to replace a missing value in an existing row? Visual Analytics cannot show a row that does not exist in the data. To replace a value within a row, you can create a calculated item. For example,

IF ( 'Salary'n Missing )
RETURN 0
ELSE 'Salary'n

Re: sas visual analytics missing value

Rajesh_02 — Wed, 21 Jun 2023 14:19:25 GMT

Hey Medelyn,

Thanks for the reply,But actually there is no row at all for the specific category.

Let me explain:

1. We have 2 year data (2019,2020,2021,2022)

2.Each year have category(car) and measure(making_cost)-e.g.2019 (maruti-10cr,Audi-2 cr,BMW-5cr) 2020 (maruti-3 cr)

3.As explained in the upper line ,in the year 2020 - there is no category i.e.Audi,BMW. So when we filter year 2020 then key value making cost is (missing)

4.So i need to treat the (missing) into '0'

5.By creating a calculative field for iF else ,we need at-least one column value to replace.