topic Re: Calculate the sum of a variable in SAS Programming

Calculate the sum of a variable

fayemelissa — Wed, 18 Nov 2020 01:12:01 GMT

How would I be able to create a code for this without using an sql procedure?

Determine the day of the week (Monday to Friday) for which the total observed usage time during the study period was the highest. The result of your procedure should show the days of week only.

I want to have a table with The weekdays and their total of usage time. To do so I have to calculate the sum of the usage time and exclude the weekend days.There are multiple observations for the usage time per day. This is what I have so far:

PROC SUMMARY DATA=NewBixi;
	VAR Timeusage;
	OUTPUT OUT=Usage SUM=;
	BY Day;
RUN;
PROC PRINT DATA=Usage;
	ID Day;
	WHERE Jour not in("Sunday";"Saturday");
RUN;

However; Saturday still shows in my table and I do not want to have the _type_ and _Freq_ columns in my final table.

Thank you for your help!

Re: Calculate the sum of a variable

ChrisNZ — Wed, 18 Nov 2020 03:51:35 GMT

Your code will not run. Look at the log.

Re: Calculate the sum of a variable

andreas_lds — Wed, 18 Nov 2020 05:50:22 GMT

Please post the data you have in usable form.

I would expect one date variable to be part of the data, allowing the usage of the format-statement in proc summary to get the required aggregation. To remove unwanted variable, use the keep/drop dataset-option in the output-statement of proc summary. The code is, of course, untested:

proc summary data=have nway;
  class Day;
  var Timeusage;
  format Day weekday.;
  output out=result(drop= _type_ _freq_) sum=;
run;