SAS Programming

DATA Step, Macro, Functions and more
BookmarkSubscribeRSS Feed
agsuthar
Calcite | Level 5

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

6 REPLIES 6
agsuthar
Calcite | Level 5

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

agsuthar
Calcite | Level 5
 
Astounding
PROC Star

Try issuing this statement first then re-running:

 

options mprint mlogic symbolgen;

 

That will provide more information in the log.

agsuthar
Calcite | Level 5

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.

Astounding
PROC Star

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

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 6 replies
  • 1216 views
  • 0 likes
  • 2 in conversation