proc summary

[SASUser0001]

hi I have marco that is creating proc summary statement . I wanted to scale in output  everything by a number like 2 or 3 . like in below program I want to multiply outdata with a number like 2 or 3 based on I will create a macro on top with %let statement . can anyone help please .

output out= outdata (drop=_type_ _freq_) sum=;

run;

[ballardw]

You use a data step on the  output data from your proc summary.

data want;

   set outdata;

   <calculations go here>

;

[SASUser0001]

hi this is my programe where should I use

macro d1(name, list)

proc summary data=total nway missing

　

var &list

output out= data1 (drop=_type_ _freq_) sum=

run

mend d1

[Kurt_Bremser]

1. Post complete working non-macro code of the step you want to repeat. Your code as posted is syntactically invalid.
2. Post a second example for the second iteration, so we can see what needs to change.
3. Tell us over which range the iterations need to run.
4. Use the "little running man" icon to post the code examples.

[PaigeMiller]

---

@SASUser0001 wrote:

hi this is my programe where should I use

macro d1(name, list)

proc summary data=total nway missing

　

var &list

output out= data1 (drop=_type_ _freq_) sum=

run

mend d1

---

Please help us all out and don't post code that doesn't have semi-colons and doesn't have % signs on the macro commands and has other obvious syntax errors. Please use the "running man" icon and post your code in the window that appears.

Also, @ballardw has already explained that you need to do the multiplication in a data step after your PROC SUMMARY, and he has given example code. Give that a try.