Question

Question Posted 12/11/15:
Hello sir,
I am using merged REGISTRY/DXSUM/ARM table to identify baseline diagnosis by PHASE=’ADNI1’, VISCODE=’bl’, and RGCONDCT=1 for example:
RID Phase VISCODE
295 ADNI1 bl
295 ADNI1 m06
295 ADNI1 m12
295 ADNI1 m24
295 ADNI1 m36
295 ADNI1 m48
How can I detect in ADNI-1 csv files Individual with RID=295 and Viscode='bl"
**123_S_5678, the last 4 digits correspond to the roster ID (RID) which you see in every CSV file, what about (bl)?

Thanks in advance
Response posted 12/11/15 by Danielle:
In ADNI, some information was obtained during the screening visit (VISCODE=="sc"), while additional information was obtained during the baseline visit (VISCODE=="bl"). As you noticed, RID is the unique participant identifier which may be used to merge across files. If you want the initial assessment information, you will want to consider both "sc" and "bl" as the VISCODEs in ADNI-1.
Response posted 12/11/15 by Marwa:
RID(295) is the same for bl and sc
example:
RID Phase VISCODE
295 ADNI1 bl
295 ADNI1 m06
295 ADNI1 m12
295 ADNI1 m24
295 ADNI1 m36
295 ADNI1 m48
How can I identify Individual CSV file as baseline diagnosis only. for example:
002_S_0295 is a CSV file , the diagnosis of this individual is baseline diagnosis or Screening diagnosis or both?
IF both ,how can I filter baseline diagnosis only?

Thanks in advance I appreciate your help
Response posted 12/11/15 by Danielle:
The best diagnosis to use for the initial diagnosis is from the baseline assessment (VISCODE=="bl"). See http://adni.loni.usc.edu/data-samples/data-faq/ for an FAQ on the difference between the screening and baseline diagnosis. In your software program, you should be able to restrict to VISCODE=="bl".