topic Replace all missing values of specific years in a panel data to 0 (not all missing values to 0) in SAS Programming

Replace all missing values of specific years in a panel data to 0 (not all missing values to 0)

nazmul — Sat, 20 May 2017 19:15:26 GMT

Hi, I want to change all missing values from the year 1982 to 1988 to 0, but I want to keep data from 1980 to 1981 and from 1989 to 1991 unchanged. I just put income variable here but my original data set has 45 variables. I want to apply the change to all the variables. Could anyone please help me?

Re: Replace all missing values of specific years in a panel data to 0 (not all missing values to 0)

Reeza — Sat, 20 May 2017 19:26:11 GMT

Please do not post data as an image. To use your data we would have to type it out, which you should really do ahead of time.

There are instructions here on how to post your data.

https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712

Your question is a conditional execution.

So your conditions appear to be:

If year Greater than or equal to 1982 and year less than or equal to 1988

If income is missing then set income to 0

Else do nothing

If this is correct you can convert it to code via:

*If year Greater than or equal to 1982 and year less than or equal to 1988;
if year >= 1982 and year <= 1998 then do;
    *If income is missing then set income to 0;
     if income = . then income=0;
*else do nothing;
end;

To incorporate multiple values you would need an array.

To create an array you need to list all the variables somehow and they need to be the same type.

I would suggest giving the expansion a try yourself and posting back if you have issues:

Here's a tutorial:

https://stats.idre.ucla.edu/sas/seminars/sas-arrays/

Re: Replace all missing values of specific years in a panel data to 0 (not all missing values to 0)

nazmul — Sat, 20 May 2017 19:36:07 GMT

Thank you for your help. Regarding my impage upload, I am sorry I did not know the rule. Should I upload a SAS file instead from next time?

Re: Replace all missing values of specific years in a panel data to 0 (not all missing values to 0)

Reeza — Sat, 20 May 2017 20:07:04 GMT

Don't upload any files.

In the future use the instructions in the post linked to create a data step so someone can recreate your dataset via a program. This means there's no risk of downloading an infected file.

Re: Replace all missing values of specific years in a panel data to 0 (not all missing values to 0)

nazmul — Sat, 20 May 2017 20:10:17 GMT

Thank you for your suggestion. I will do