MACRO Explanation

[R_A_G_]

Hello Experts,

I have 2 questions regarding Macro:

1) when we assign replication to a set of codes, is there a common problem with these replication going threw the codes differently. Ex: I have 3 replication and the first 2 skips a step while the last one goes threw the whole thing as it supposed to. Is there a common obvious mistake that I should look for

2) when we have a macro within macro with for example 100 iteration. what happens?

do SAS goes threw each macro separately or behaves like a loop, finishing the macro within before ending the macro outside


Thank you for your help
R.A.G.

[Doc_Duke]

I don't understand question 1. an example would help.

For question 2, by specifying OPTIONS MACROGEN; you can see exactly the code that is generated by a macro (and by a macro within a macro).

[R_A_G_]

Thank you Doc,

Maybe this will help, I am getting these errors:

first error:
MPRINT(CREATEMPLUSINPUT): * Item by threshold data for writing item-based commands;
MPRINT(CREATEMPLUSINPUT): DATA itembythresh;
MPRINT(CREATEMPLUSINPUT): SET kernel;
MPRINT(CREATEMPLUSINPUT): RUN;
ERROR: You cannot open WORK.ITEMBYTHRESH.DATA for output access with member-level control
because WORK.ITEMBYTHRESH.DATA is in use by you in resource environment DMS Process.
NOTE: The SAS System stopped processing this step because of errors.

2nd ERROR:
SYMBOLGEN: Macro variable COMMANDFILE resolves to CDM_1
NOTE: Line generated by the invoked macro "WRITEMPLUS".
3 * Name of Mplus file to be written with returns and breaks; FILE
----
180
3 ! "c:\CDM1\&commandfile..inp"; * Mplus TITLE command; PUT @1 "TITLE: ! Section
3 ! that appears in header of output file"; PUT @5
ERROR 180-322: Statement is not valid or it is used out of proper order.

[Cynthia_sas]

Hi:
This looks like a small part of a bigger process. Is this issue related to any of these previous postings?
http://support.sas.com/forums/thread.jspa?messageID=49931쌋
http://support.sas.com/forums/thread.jspa?messageID=48701븽
http://support.sas.com/forums/thread.jspa?messageID=50680엸
http://support.sas.com/forums/thread.jspa?messageID=50685엽

cynthia

[R_A_G_]

Hi Cynthia,

It does relate to the previous issue in a way.

It all comes from the same MACRO but the problems are different.

Thank you

[ballardw]

The error: ERROR: You cannot open WORK.ITEMBYTHRESH.DATA for output access with member-level control
because WORK.ITEMBYTHRESH.DATA is in use by you in resource environment DMS Process.

means that some other program has the output data set open and/or locked so the referenced data step can't use it. It is likely you opened the data set to see the results previously and didn't close it from the table view.

[R_A_G_]

Thank you
that make sense and I am sure you are right. B/C when I have 1 iteration it works fine the problem starts when I have more than 1 iteration which from what you've said means the first iteration opens it and does not close it. How do I close these three files. I have tried the following and still does not work:

%let ITEMBYTHRESH=%sysfunc(close(&.ITEMBYTHRESH));
I have 3 of these files with different names

Thank you