Hello, I try to import an ODM XML file via PROC CDISC into SAS datasets. The following script was used in the past but now it occur a syntax error. Till now I spend a lot of time to solve the error but I did not found anything. Here is the error message (regarding SASDATASETNAME....): 6 ODMMINIMUMKEYSET=NO USENAMEASLABEL=YES; 6 ! CLINICALDATA OUT=OUT.&DSET SASDATASETNAME="&DSET" - 22 76 6 ! SITEREF=YES INVESTIGATORREF=YES; RUN; ERROR 22-322: Syntax error, expecting one of the following: COMMENT, DOMAIN, DOMAINCODE, NAME, ORIGIN, PURPOSE, SASDATASETNAME. ERROR 76-322: Syntax error, statement will be ignored. NOTE: The SAS System stopped processing this step because of errors. I hope anybody in this community could help me. Thanks in advance. Kind regards, Tanja The following script I used: /* Program Description: Program to create a SAS dataset for every itemgroup within a XML ODM file */ /***** SAS Site number ********/ %put sitenumber: &SYSSITE; /***** PROC CDISC VERSION *****/ proc cdisc version; run; /************* ODM IMPORT **********************/ /* create filenames/libnames for XML ODM studydefs */ FILENAME XMLIMP 'Y:\...\dataexport_56881_2015-04-13_10-24-40.xml'; LIBNAME XMLIMP xml xmltype=CDISCODM FormatActive=No FormatNoReplace=No; LIBNAME OUT 'Y:\...\SAS_data'; LIBNAME FLIB 'Y:\...\SAS_data'; %global DSETS; /* MACRO for reading in ALL ItemGroups from ODM file in one step */ %MACRO ALLSETS (LIB, FLIB); PROC SQL noprint; SELECT UNIQUE MEMNAME INTO :DSETS SEPARATED BY '|' FROM DICTIONARY.TABLES WHERE UPCASE(LIBNAME)="&LIB"; %PUT DATASETS: &DSETS; QUIT; %LET NUM=1; %LET DSET=%SCAN(%QUOTE(&DSETS),&NUM,|); %DO %UNTIL (%QUOTE(&DSET)=%STR()); PROC CDISC MODEL=ODM READ=XMLIMP FORMATACTIVE=YES FORMATNOREPLACE=NO LANGUAGE="EN"; ODM ODMVERSION="1.2" ODMMAXIMUMOIDLENGTH=20 ODMMINIMUMKEYSET=NO USENAMEASLABEL=YES; CLINICALDATA OUT=OUT.&DSET SASDATASETNAME="&DSET" SITEREF=YES INVESTIGATORREF=YES; RUN; %LET NUM=%EVAL(&NUM+1); %LET DSET=%SCAN(%QUOTE(&DSETS),&NUM,|); %END; %MEND ALLSETS; %ALLSETS (XMLIMP, FLIB);
... View more