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
Calculated fields fits best in views. And then you should be able to update the underlying table.
Calculated fields fits best in views. And then you should be able to update the underlying table.
Thanks!
Lawrence
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: