topic Re: create a sas macro so that it can be run for any airport in SAS Programming

create a sas macro so that it can be run for any airport

mrahouma — Sun, 17 Nov 2019 03:58:22 GMT

I want to create a sas macro so that it can be run for any airport. to calculate sum flights and sum passenger per that airport

I want to call the macro once for each of the 12 airports.

Please note that all airports names consist of 3 letters.

Re: create a sas macro so that it can be run for any airport

Kurt_Bremser — Sun, 17 Nov 2019 08:16:29 GMT

Since all the relevant procedures support by-group processing, no macro coding is necessary.

If you still think you need a macro, post the code that does one calculation.

And don't forget to give us usable example data (in a data step with datalines).

Re: create a sas macro so that it can be run for any airport

Astounding — Sun, 17 Nov 2019 18:41:48 GMT

Looking at your data structure, I think it's more complex than using a BY statement. A macro could look like this:

%macro sum_airline (airline=);
   proc means data=airtraffic;
      var &airline.Flights &airline.Passengers;
      output out=&airline.Summary sum=;
   run;
%mend sum_airline;

Then you can use the macro for each airport:

%sum_airline (airline=BOS)

%sum_airline (airline=ATL)

Notice that this macro prints the results, and also creates a data set holding the sums.

For next time, a positive step you could take would be to write a program that processes one airline. No macro language involved. For example, it should be up to you to be able to code this much before macro language is involved:

proc means data=airtraffic sum;
   var ATLFlights ATLPassengers;
run;

Re: create a sas macro so that it can be run for any airport

mrahouma — Tue, 19 Nov 2019 01:59:40 GMT

Thank you so much