I have sas dataset , a field is date i.e 200802, I have since 200601 till 200802, i have to append the data in every month, I need to know that how i can check that if data already exist for example, i ready have 200802 and i want to protect that this data must not be appended again untill end 200803. How to protect it ?
While you can write a process to first check for the existence / absence of a month of data before an append is performed, that is outside the scope of this discussion group. If I were tasked with auditing your data prior to, or after submission to the FDA, I'd want reassurances that the append processes had worked correctly, without loss or duplication of any data. The problems start with verifying that when a certain month of data is appended, the month is complete and is not added before the end of data collection. Overcoming that limitation adds another level of complexity to the problem and requires a custom built process for your site. Technical Support or a skilled consultant would be needed for this.
It was my understanding that data for clinical trials was managed by a data administrator, whose responsibility it was to ensure that data submitted is complete, in the correct format and only added once. Do you not have a person in such a role managing your data libraries?