BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Terho
Obsidian | Level 7

Hello,

 

I am using a proc summary step to summarize my data.

However, I want to divide the summary statistics in the "VAR" statement below by 1,000,000.

 

PROC SUMMARY DATA=ExecSummary nway missing;
CLASS
JOBID
PERIOD_ID
SCENARIO;
VAR
RQ01
RQ02
NCO_9Q
NCO_13Q
;
OUTPUT out=ExecOutput (drop=_FREQ_ _TYPE_) sum=;
RUN;

 

Is there anyway to divide the summary statistics by 1 million directly in the proc summary step?

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
mkeintz
PROC Star

You could do make a weight variable:

 

data need / view=need;
  set execsummary;
  _wgt=1/1000000;
run;

PROC SUMMARY DATA=need nway missing;
  CLASS  JOBID  PERIOD_ID  SCENARIO;
  VAR  RQ01  RQ02  NCO_9Q  NCO_13Q ;
  weight _wgt; 
  OUTPUT out=ExecOutput (drop=_FREQ_ _TYPE_) sum=;
RUN;

 

There is not much efficiency loss here, since NEED is a data set view, not a data set file.  NEED will be activated only when called by the proc summary, and will stream its data to the proc, not to disk storage.  So virtually no input/output cost. 

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------

View solution in original post

3 REPLIES 3
Reeza
Super User

Can you apply a format to the results instead to scale the results?

 


@Terho wrote:

Hello,

 

I am using a proc summary step to summarize my data.

However, I want to divide the summary statistics in the "VAR" statement below by 1,000,000.

 

PROC SUMMARY DATA=ExecSummary nway missing;
CLASS
JOBID
PERIOD_ID
SCENARIO;
VAR
RQ01
RQ02
NCO_9Q
NCO_13Q
;
OUTPUT out=ExecOutput (drop=_FREQ_ _TYPE_) sum=;
RUN;

 

Is there anyway to divide the summary statistics by 1 million directly in the proc summary step?

 

Thanks


 

mkeintz
PROC Star

You could do make a weight variable:

 

data need / view=need;
  set execsummary;
  _wgt=1/1000000;
run;

PROC SUMMARY DATA=need nway missing;
  CLASS  JOBID  PERIOD_ID  SCENARIO;
  VAR  RQ01  RQ02  NCO_9Q  NCO_13Q ;
  weight _wgt; 
  OUTPUT out=ExecOutput (drop=_FREQ_ _TYPE_) sum=;
RUN;

 

There is not much efficiency loss here, since NEED is a data set view, not a data set file.  NEED will be activated only when called by the proc summary, and will stream its data to the proc, not to disk storage.  So virtually no input/output cost. 

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------
Terho
Obsidian | Level 7

Thank you! This worked wonderfully!

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1564 views
  • 3 likes
  • 3 in conversation