topic Re: When I submit this code to create a Macro Def. I only see the log there is no report? in SAS Programming

When I submit this code to create a Macro Def. I only see the log there is no report?

hmlong25 — Wed, 05 Mar 2025 17:47:15 GMT

Reminder: If you restarted your SAS session, you must recreate the MC1 library so you can access your practice files. In SAS Studio, open and submit the libname.sas program in the EMC1V2 folder. In Enterprise Guide, run the Autoexec process flow.

Open m104p01.sas from the practices folder. Review and submit the program. Verify that it generates a report for Gold customers that contains 680 rows.
Convert the code to a macro named Customers that accepts a positional parameter named Type.
- Submit the macro definition and review the log to verify that the macro compiled successfully.
- Call the Customers macro with the parameter value Gold. Verify that the title is Gold Customers and that there are 680 rows in the report.
- Call %Customers again with the parameter value High Activity. Verify that no rows were selected due to a case difference.
Solution:
```
%macro customers(type); 
title "&type Customers"; 
proc sql number;
select Name, Age_Group, Type 
    from mc1.customers 
    where Type contains "&type"; 
quit; 
title;
%mend customers;

%customers(Gold)
%customers(High Activity)
```

Re: When I submit this code to create a Macro Def. I only see the log there is no report?

PaigeMiller — Wed, 05 Mar 2025 18:31:53 GMT

What does the log say? Turn on the macro debugging options first by running this command

options mprint;

and then run the macro again. That should help you debug it. If you still can't figure it out, please copy and paste the log as text into the window that appears when you click on the </> icon. We need to see the entire log for the calls to the macro, not selected parts of the log.

Re: When I submit this code to create a Macro Def. I only see the log there is no report?

hmlong25 — Wed, 05 Mar 2025 20:01:49 GMT

I had to restart my computer and then the report ran. thank you for that other option I will try!