that is right but in order to avoid to replace my dataset repeatedly, i am asking for advice to have a sas macro, so that I need not do it repeatedly   also, i am asking for advice whether there is a sas code to compare the frequency of each variable afterwards ... View more

@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∑ by patientid; run; PROC means DATA=bp2∑ var wvr_:; run; %mend; data want; set bp2∑ run; %sum(child, adult, senior, over100) ... View more

@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. ... View more

*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 ... View more

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. ... View more

*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 ... View more

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

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.     ... View more

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

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

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. ... View more