topic Re: how to use macro to do proc means and proc contents in SAS Programming

how to use macro to do proc means and proc contents

Bal23 — Mon, 29 Feb 2016 20:31:23 GMT

I have four datasets, child, adult, senior and over100, each one has over 10000 obs.

the orginal code is very simple

proc sort data=bpchild;
by id;
run;
PROC means DATA= bpchild;
var wvr_:;
run;
proc contents data= bpchild;
run;

I just need to replace child with adult, senior, over100.

would anybody teach me how to use macro do this? Thanks.

Re: how to use macro to do proc means and proc contents

Cynthia_sas — Mon, 29 Feb 2016 20:32:47 GMT

Hi, this should get you started:
https://support.sas.com/resources/papers/proceedings13/120-2013.pdf

cynthia

Re: how to use macro to do proc means and proc contents

Reeza — Mon, 29 Feb 2016 20:35:17 GMT

Don't.

Append the files together, use the INDSNAME to identify each source data set and then run a proc means with a BY statement.

This is more efficient. Datasets of 100K aren't big to SAS.

data all;
set child adult senior over100 indsname=source;
dsetname=source;
run;

proc sort data=all;
by dsetname id;
run;

proc means data=all;
by dsetname;
var wvr:;
run;

Re: how to use macro to do proc means and proc contents

LinusH — Mon, 29 Feb 2016 20:35:55 GMT

Wrap your code within a macro definition. The macro needs a parameter, the data sat name.
The parameter acts as macro variable within the macro, so just replace the data set names in your code with that.
Then call the macro once for each data set you wish to use.
See syntax and examples in the on line documentation.

Re: how to use macro to do proc means and proc contents

Bal23 — Mon, 29 Feb 2016 21:06:13 GMT

Thanks. But my work is to generate four tables, not a whole picture. Actually, I do have the original dataset, which includes them all. But I am requried to generate four tables.

Re: how to use macro to do proc means and proc contents

Bal23 — Mon, 29 Feb 2016 21:07:28 GMT

Thank you. Would you please provide sample code? That will be very helpful. It is hard for me to understand.

Re: how to use macro to do proc means and proc contents

Reeza — Mon, 29 Feb 2016 21:30:39 GMT

Wrap your code in %macro/%mend and assign a name, eg:

%macro summarize;

*your sas code;

%mend;

Test that it works by calling it.
```
%summarize;
```
Change macro to use a parameter
```
%macro summarize(dataset);
```
Change variable name in code to be parameter value, eg:
```
proc means data=&dataset;
...
run;
```
Test again
```
%summarize(bpchild);
```
Make sure it works for multiple cases.

Re: how to use macro to do proc means and proc contents

RW9 — Tue, 01 Mar 2016 10:32:33 GMT

Please clarify on this sentance:

"But I am requried to generate four tables."

Why are you required to generate four tables. The reason I ask is that @Reeza has provided code which is both simple to read, and efficient in terms of execution. So the question is, why does it then need to be four tables when further procedures can also use by group processing on the data, for instance to report out four tables:

ods tagsets.excelxp file="abc.xlsx" options=(sheet_interval=...);

proc report data=...

by dsetname;

...

run;

ods tagsets.close;

The thing is, your taking data which can be operated on as one step, splitting it up, then lopping over it each time to do the same thing, and you will find once you split the data every step thereafter than needs to loop over these, which makes life more complicated.

Re: how to use macro to do proc means and proc contents

Bal23 — Tue, 01 Mar 2016 14:05:06 GMT

Thanks. I am reading it. It takes while for me to finish.

Re: how to use macro to do proc means and proc contents

Bal23 — Tue, 01 Mar 2016 14:39:57 GMT

Thanks.

First,my work is, after I generated these four tables, I need to compare the frequency of all those variables. For example, if I have 2o variables, I need to compare the frequency of each variable, and then list them according to the frequency. I prefer to have a small one so that I can compre by looking at the list of variables directly. I do not know how to use sas to do that step. if you can give me advice, that will be helpful. This is why I ask for four tables seperatedly

Second, I am not familiar with the following code

indsname=source;
dsetname=source

I searched online. I feel that I should list variable names there. I have many variables. Then how should I list. What is the difference between indsname and dsetname here? I cannot figure out what 'source' means here.

Re: how to use macro to do proc means and proc contents

RW9 — Tue, 01 Mar 2016 14:45:43 GMT

Could you provide test data in the form of a datastep, so that we can provide some code, just guessing from the text here. Help on the indsname option:

http://www.amadeus.co.uk/sas-training/tips/1/1/106/the-indsname-option.php

Basically you would create a variable which holds the name of the dataset that data comes from, in the example given by @Reeza, this would be child or adult etc.

This variable is then used as a bygroup, you can also do frequencies and other things using by group.

Re: how to use macro to do proc means and proc contents

Bal23 — Tue, 01 Mar 2016 14:57:37 GMT

I have searched online and found the link you provided. Unfortunately, with my current computer, I could not access, maybe because of setting problems.

Re: how to use macro to do proc means and proc contents

Bal23 — Tue, 01 Mar 2016 15:40:57 GMT

*Create sample data;
data childhave;
input patientid var_hed var_eye var_col var_leg var_hea var_lea var_alh;
cards;
371130 1 . . . . . 1

214144 . 1 . . . . . 

181841 . . . . 1.1

168065 . . 1....
779199 . . . 1 1 .
155981 1 . 1 . . . .
603224 . . . . . 1 .

;

run;

this is my test data, for one dataset, child group

thanks

Re: how to use macro to do proc means and proc contents

Reeza — Tue, 01 Mar 2016 15:43:34 GMT

@Bal23 Have you tried the steps I've outlined. Besides writing the code letter for letter for you, I'm not sure how else to explain it.

If you're having trouble, post the code you've tried.

You've also stated you want 4 tables, the BY does generate 4 separate tables.

Re: how to use macro to do proc means and proc contents

Bal23 — Tue, 01 Mar 2016 15:54:34 GMT

As I said, I do not understand how to use this

indsname=source;
dsetname=source;

I did search online, I got the same link that I could not access

Then, I provided my sample data a few minutes ago. Please check and it will be great if you can provide help regarding my sample data, since I do not know how to modify your above code

thanks.

Re: how to use macro to do proc means and proc contents

Reeza — Tue, 01 Mar 2016 15:57:14 GMT

indsname is a dataset option. It identifies records by creating a variable that stores the name of the data set that provides the record.

However, that variable isn't stored automatically, so you need to reassign it in your data step.

It is only valid in SAS 9.3+

INDSNAME=variable
creates and names a variable that stores the name of the SAS data set from which the current observation is read. The stored name can be a data set name or a physical name. The physical name is the name by which the operating environment recognizes the file.
Tips	For data set names, SAS adds the library name to the variable value (for example, WORK.PRICE) and converts the two-level name to uppercase.
Unless previously defined, the length of the variable is set to 41 bytes. Use a LENGTH statement to make the variable length long enough to contain the value of the physical filename if the filename is longer than 41 bytes.
If the variable is previously defined as a character variable with a specific length, that length is not changed. If the value placed into the INDSNAME variable is longer than that length, then the value is truncated.
If the variable is previously defined as a numeric variable, an error will occur.
The variable is available in the DATA step, but the variable is not added to any output data set.
Example	Retrieving the Name of the Data Set from Which the Current Observation Is Read

http://support.sas.com/documentation/cdl/en/lestmtsref/68024/HTML/default/viewer.htm#p00hxg3x8lwivcn1f0e9axziw57y.htm

Re: how to use macro to do proc means and proc contents

Bal23 — Tue, 01 Mar 2016 16:20:00 GMT

*Create sample data;
data childhave;
input patientid var_hed var_eye var_col var_leg var_hea var_lea var_alh;
cards;
371130 1 . . . . . 1

214144 . 1 . . . . . 

181841 . . . . 1.1

168065 . . 1....
779199 . . . 1 1 .
155981 1 . 1 . . . .
603224 . . . . . 1 .

;

run;

@Reeza, I have read this. Without any example, it is hard for me to do. (i did click but was not able to get any example).

Therefore, I copied and pasted my sample data set again and hope to get sample code from you

Thanks

Re: how to use macro to do proc means and proc contents

Bal23 — Tue, 01 Mar 2016 17:17:17 GMT

@cynthiaI have read the note from the link you provided however, I still do not know how to apply it to solve my problem.

As Reeza said below (that is originally a kind of my plan, but not in details, as he provided). however, I still have trouble to do it

%macro summarize;

*your sas code;

%mend;

%macro sum; proc sort data=bp2∑ by patientid; run; PROC means DATA=bp2∑ var wvr_:; run; %mend; data want; set bp2∑ run; %sum(child, adult, senior, over100)
Test that it works by calling it.
```
%summarize;
```
Change macro to use a parameter
```
%macro summarize(dataset);
```
Change variable name in code to be parameter value, eg:
```
proc means data=&dataset;
...
run;
```
Test again
```
%summarize(bpchild);
```
Make sure it works for multiple cases.

Re: how to use macro to do proc means and proc contents

Bal23 — Tue, 01 Mar 2016 17:19:42 GMT

@Reeza

this is my code, based on your code above

I am thinking to have a variable that can be used to replace child, adult, senior and over100. There are some problems with this code, so please give advice. thanks

%macro sum;

  proc sort data=bp2&sum;
by patientid;
run;
 PROC means DATA=bp2&sum;
var wvr_:;
run;

    %mend;
	
data want;
set bp2&sum;
run;
%sum(child, adult, senior, over100)

Re: how to use macro to do proc means and proc contents

RW9 — Tue, 01 Mar 2016 17:35:34 GMT

So from the test data you posted:

data childhave;
input patientid var_hed var_eye var_col var_leg var_hea var_lea var_alh;

You proc means is simply:

proc means data=childhave;
  var var_:;
run;