Hi,

I changed the data format from long to wide (variable 'binary') and the data is in form:

Code:
ID ProgramID binary666 binary667 ... binary 721
1    2                  0               1                      1
1    4                  1               1                      -
1    3                  1               -                      1
I would like to rename the variable 'binary666' - 'binary721' into "201507" to "201912".

The time variable was initially 'month' in format '201507'. I want to preserve the name of the variable as it was to have a monthly trend.

Also, I would like to replace the missing values into 0 but is there a way to use 'replace' for multiple variables at the same time?

Thank you very much in advance!