Guidance on how to edit 1 column in xpt (since xpt not same as csv)

[sbjain]

Hi All,

Since xpt files not as directly translated as csv editing, can you please guide on how to write to a column to change its value in an xpt file. I only see example of mapping. I do not want to map, here is what I need to do:

1. Locate Column 1 --> change value '83302' to '2018_001'
2. Save the new file
3. Open next file --> locate column 1 --> change value to '2018_002'
   ..and so on.

Please help how to access 1 column, change value, and save file.
Also 2. Can we convert to CSV and then back to XPT file? Or not needed?

Thanks,
Saga

[selik]

Answered in #23