08-29-2017 06:30 PM
So I am trying to insert data into a MS Access database that has a calculated field (field1/field3) in it-
but I am not sure from the SAS component how to structure the data per se for upload
i.e. as a binary, it can be 0 as fieldx or 1 as fieldx
but this field is calculated by two others that I would like Access to do the calculations for me.
Also not all observations have values.
I can always delete the field and upload the data myself but as it requires an update query I am trying to work around it not to require additional processing time where Access can do the work already.
Need further help from the community? Please ask a new question.