topic Re: proc summary in SAS Programming

proc summary

SASUser0001 — Sat, 16 May 2020 00:11:32 GMT

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;

Re: proc summary

ballardw — Sat, 16 May 2020 00:48:21 GMT

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

data want;

set outdata;

;

Re: proc summary

SASUser0001 — Sat, 16 May 2020 01:04:31 GMT

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

Re: proc summary

Kurt_Bremser — Sat, 16 May 2020 06:15:38 GMT

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

Re: proc summary

PaigeMiller — Sat, 16 May 2020 10:38:17 GMT

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