01-31-2018 09:39 AM
I have created a report that extracts and summarizes data from about 10 data sets. Most of these data sets will have to be maintained since the data is not all that clean. I am trying to create an interface that can be used to pull the data, view/edit etc in a way that does not require SAS expertise. Can some one help.
01-31-2018 09:55 AM
Trying to create an interface? You can do some things via a prompt, but if your cleaning data you should really have some auditable process in place, i.e. a database. I suppose you could dump the data out to Excel and let them update it there, will likely cause more data issues than you first had though. Clean the data at source in the data capture part, best way (espcially if audited database).