Question
Question Posted 08/06/13:
The 'clielg' data set does not have column labels. Using the data dictionary I have identified a few, however, I am unable to confidently label the rest. Is there a way to get a labeled version or to have the labels sent to me in the order in which they appear in the data set?
Thank you
The 'clielg' data set does not have column labels. Using the data dictionary I have identified a few, however, I am unable to confidently label the rest. Is there a way to get a labeled version or to have the labels sent to me in the order in which they appear in the data set?
Thank you
Response posted 08/06/13 by Mike Donohue:
We assume you are using the SPSS, Stata, or SPSS data package. To identify the columns see the accompanying code file. For example, if you are working with the SAS package see ADNIMERGE_SAS/code/clielg.sas, specifically the lines:
INFILE "../data/clirev.csv"
DSD
LRECL= 321 ;
INPUT
ORIGPROT
COLPROT
RID
SITEID
VISCODE
USERDATE
V1
CLIPASS
CLIDATE
CLICOMM
CLIPASSWD
;
LABEL ORIGPROT = "Protocol from which subject originated" ;
LABEL COLPROT = "Protocol under which data was collected" ;
LABEL RID = "" ;
LABEL SITEID = "" ;
LABEL VISCODE = "" ;
LABEL USERDATE = "" ;
LABEL V1 = "USERDATE2" ;
LABEL CLIPASS = "" ;
LABEL CLIDATE = "Approval Date" ;
LABEL CLICOMM = "Comments:" ;
LABEL CLIPASSWD = "I certify that I am using my own personal username and password and understand that by using my username and password, I am authorizing this electronic signature to be the legally binding equivalent of my handwritten signature executed on paper. Enter Your Password:" ;
FORMAT CLIPASS CLIPASS. ;
FORMAT USERDATE yymmdd10.;
FORMAT V1 yymmdd10.;
FORMAT CLIDATE yymmdd10.;
RUN;
INFILE "../data/clirev.csv"
DSD
LRECL= 321 ;
INPUT
ORIGPROT
COLPROT
RID
SITEID
VISCODE
USERDATE
V1
CLIPASS
CLIDATE
CLICOMM
CLIPASSWD
;
LABEL ORIGPROT = "Protocol from which subject originated" ;
LABEL COLPROT = "Protocol under which data was collected" ;
LABEL RID = "" ;
LABEL SITEID = "" ;
LABEL VISCODE = "" ;
LABEL USERDATE = "" ;
LABEL V1 = "USERDATE2" ;
LABEL CLIPASS = "" ;
LABEL CLIDATE = "Approval Date" ;
LABEL CLICOMM = "Comments:" ;
LABEL CLIPASSWD = "I certify that I am using my own personal username and password and understand that by using my username and password, I am authorizing this electronic signature to be the legally binding equivalent of my handwritten signature executed on paper. Enter Your Password:" ;
FORMAT CLIPASS CLIPASS. ;
FORMAT USERDATE yymmdd10.;
FORMAT V1 yymmdd10.;
FORMAT CLIDATE yymmdd10.;
RUN;
