SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Issue to create macro in Data management studio

Frequent Contributor
Posts: 140

Issue to create macro in Data management studio



I am trying to create a macro variable in data managemnt studio
But i am getting the issue

I have opened administration taba ns in macro file i have given macro and added the macro New_MC and in the value i have given the path that is required

Then in the input tab i have given the macro with %%New_MC%% but i am getting unabel to open the text file
can any one help me.

2) Query _2
How can we check the value the macro was resolved to in Data management studio

Ex: in sas

%put &%New_MC
like this, how can we chek in data management stuio

SAS Employee
Posts: 75

Re: Issue to create macro in Data management studio

1. For your first question:  May I ask how you are trying to use the macro you are creating? The DM Studio user guide has a chapter about macros. It has topics about how to create macros for specific purposes. If you are just testing perhaps you could pick one of the types described in the chapter: Using Macro Variables

I am not sure what you mean by not being able to open a text file. One possibility is that you are trying to open the "system" macro file which you might not have access to. But this is just a guess on my part. 


2. For your second question, one way to check how macros are resolving is as follows. I hope that it helps in your case:

"To see how the current macro variables and configuration directives are resolving, select Tools > Data Management Studio Options > Advanced from the main menu." (Usage Notes for Macro Variables)  User-defined macros are at the bottom of the long list of items in the Advanced panel.

Ask a Question
Discussion stats
  • 1 reply
  • 2 in conversation