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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.