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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.