topic Re: How to Use Proc Sort Using Macros in SAS Programming

How to Use Proc Sort Using Macros

SushilKumar — Mon, 19 Aug 2013 08:44:43 GMT

Hi ,

Could any one help me Out that how to use Proc sort in macros.

Re: How to Use Proc Sort Using Macros

Murray_Court — Mon, 19 Aug 2013 09:31:23 GMT

A macro that will sort a dataset?

%Macro sorter(dsn, var);

proc sort data=&dsn.;

by &var.;

run;

%mend;

%sorter(sample_dataset, age);

will sort sample_dataset by the variable age.

Re: How to Use Proc Sort Using Macros

jakarman — Mon, 19 Aug 2013 10:29:16 GMT

Good question to start with Murray.

Have seen a lot of people starting to learn SAS calling everything a "macro".

Not been aware of te datastep / procedures / sas-macro / scl , metadata and may other artifacts used ad code/programming tools.

Re: How to Use Proc Sort Using Macros

SushilKumar — Tue, 20 Aug 2013 07:17:50 GMT

Thank you murray

Could you explain me how it works, because i new to sas macros

Re: How to Use Proc Sort Using Macros

LinusH — Tue, 20 Aug 2013 07:56:56 GMT

SAS macros is a whole programming language, and teaching a such is not suitable in a forum.

I suggest that you spend some time with the documentation, and potentially read some papers (i.e. from SAS Global Forum), and potentially attend to some training (physical or online).

Re: How to Use Proc Sort Using Macros

Murray_Court — Tue, 20 Aug 2013 09:03:49 GMT

Macros allow you to automatically submit programs based on arbitrary requirements.

If I have to sort 100 datasets in the same way, to save time I would write the 'sorter' macro as above, and call it with reference to my 100 datasets, this saves a lot of copying and pasting, as the macro prossesor does that for us.

For a rounded education on macros I would reccomend the SAS Certification Prep Guide:: Advanced Programming for SAS 9, Third Edition. About a thir dof this book looks exclusively at the way macros work.

Re: How to Use Proc Sort Using Macros

SushilKumar — Tue, 20 Aug 2013 09:48:41 GMT

thank you