I am having difficulty in creating define.xml file. When I run this part of code...
%ImportALLMeta(CRT-Specification-V1.0,"dm,suppdm,
DatasetMetadata,
StudyInfo,
ValueLevel,
ControlledTerminology,
Methods,
Comments")
It shows log out put as shown below -
11826 %ImportALLMeta(CRT-Specification-V1.0,"dm,suppdm,
11827 DatasetMetadata,
11828 StudyInfo,
11829 ValueLevel,
11830 ControlledTerminology,
11831 Methods,
11832 Comments")
ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric
operand is required. The condition was: &len
ERROR: The %TO value of the %DO J loop is invalid.
ERROR: The macro IMPORTALLMETA will stop executing.
How to correct this error? Any suggestion?
PS: I am using SAS 9.0 version
I am attaching file if you have problem in solving it.
Try issuing this statement first then re-running:
options mprint mlogic symbolgen;
That will provide more information in the log.
Ok. Here is the detailed log of error.
13621 %ImportALLMeta(CRT-Specification-V1.0,"dm,suppdm,
MLOGIC(IMPORTALLMETA): Beginning execution.
13622 DatasetMetadata,
13623 StudyInfo,
13624 ValueLevel,
13625 ControlledTerminology,
13626 Methods,
13627 Comments")
MLOGIC(IMPORTALLMETA): Parameter FILENAME has value CRT-Specification-V1.0
MLOGIC(IMPORTALLMETA): Parameter METAS has value "dm,suppdm,
DatasetMetadata, StudyInfo,
ValueLevel, ControlledTerminology,
Methods,
Comments"
MLOGIC(IMPORTALLMETA): %LET (variable name is LEN)
SYMBOLGEN: Macro variable METAS resolves to "dm,suppdm,
DatasetMetadata, StudyInfo,
ValueLevel,
ControlledTerminology, Methods,
Comments"
SYMBOLGEN: Macro variable LEN resolves to -6.1809460637981E307
ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric
operand is required. The condition was: &len
ERROR: The %TO value of the %DO J loop is invalid.
ERROR: The macro IMPORTALLMETA will stop executing.
MLOGIC(IMPORTALLMETA): Ending execution.
Better call SAS technical support for that. There's no reasonable way that %SYSFUNC(COUNTW could return a number like -6E307.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.