topic Re: SAS MACRO DEFINE.XML CREATION ERROR in SAS Programming

SAS MACRO DEFINE.XML CREATION ERROR

agsuthar — Sat, 03 Mar 2018 16:39:47 GMT

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

Re: SAS MACRO DEFINE.XML CREATION ERROR

agsuthar — Sat, 03 Mar 2018 17:00:56 GMT

I am attaching file if you have problem in solving it.

Re: SAS MACRO DEFINE.XML CREATION ERROR

agsuthar — Sat, 03 Mar 2018 17:01:26 GMT

Re: SAS MACRO DEFINE.XML CREATION ERROR

agsuthar — Sat, 03 Mar 2018 17:01:50 GMT

Re: SAS MACRO DEFINE.XML CREATION ERROR

Astounding — Sat, 03 Mar 2018 17:13:54 GMT

Try issuing this statement first then re-running:

options mprint mlogic symbolgen;

That will provide more information in the log.

Re: SAS MACRO DEFINE.XML CREATION ERROR

agsuthar — Sat, 03 Mar 2018 17:38:36 GMT

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

MLOGIC(IMPORTALLMETA): Ending execution.

Re: SAS MACRO DEFINE.XML CREATION ERROR

Astounding — Sat, 03 Mar 2018 21:41:36 GMT

Better call SAS technical support for that. There's no reasonable way that %SYSFUNC(COUNTW could return a number like -6E307.