DATA Step, Macro, Functions and more

inserting data in MS access database w/ calculated field

Accepted Solution Solved
Reply
Regular Contributor
Regular Contributor
Posts: 161
Accepted Solution

inserting data in MS access database w/ calculated field

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

 

 

 

 


Accepted Solutions
Solution
‎08-31-2017 02:20 PM
Super User
Posts: 5,916

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

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

Data never sleeps

View solution in original post


All Replies
Solution
‎08-31-2017 02:20 PM
Super User
Posts: 5,916

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

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

Data never sleeps
Regular Contributor
Regular Contributor
Posts: 161

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

Thanks! 

 

Lawrence 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 150 views
  • 2 likes
  • 2 in conversation