inserting data in MS access database w/ calculated field

LB — Tue, 29 Aug 2017 22:30:20 GMT

Hello all;

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.

Thanks

Lawrence

Re: inserting data in MS access database w/ calculated field

LinusH — Wed, 30 Aug 2017 09:13:00 GMT

Calculated fields fits best in views. And then you should be able to update the underlying table.

Re: inserting data in MS access database w/ calculated field

LB — Thu, 31 Aug 2017 18:21:17 GMT

Thanks!

Lawrence

topic Re: inserting data in MS access database w/ calculated field in SAS Programming

inserting data in MS access database w/ calculated field

Re: inserting data in MS access database w/ calculated field

Re: inserting data in MS access database w/ calculated field