topic NOTE: Mathematical operations could not be performed in SAS Programming

NOTE: Mathematical operations could not be performed

vinod4842 — Mon, 12 Jun 2017 05:41:25 GMT

data NRI_team;
/*retain TEAM ACCOUNTS_OPENED_LAST_MONTH C2T_till_date_for_last_month C2T_for_the_month */
/*Accounts_current_year Accounts_C2T_current_year C2T_for_the_current_year New_Traders_today New_Traders_current_month; */
set vinod.Nri_team_wise_conversation;
C2T_for_the_month=C2T_till_date_for_last_month/ACCOUNTS_OPENED_LAST_MONTH*100;
C2T_for_the_current_year=Accounts_C2T_current_year/Accounts_current_year*100;
format C2T_for_the_month percent8.2;
format C2T_for_the_current_year percent8.2;

run;

log file::::::::::::::

182 data NRI_team;
183 /*retain TEAM ACCOUNTS_OPENED_LAST_MONTH C2T_till_date_for_last_month C2T_for_the_month */
184 /*Accounts_current_year Accounts_C2T_current_year C2T_for_the_current_year New_Traders_today
184! New_Traders_current_month; */
185 set vinod.Nri_team_wise_conversation;
186 C2T_for_the_month=C2T_till_date_for_last_month/ACCOUNTS_OPENED_LAST_MONTH*100;
187 C2T_for_the_current_year=Accounts_C2T_current_year/Accounts_current_year*100;
188 format C2T_for_the_month percent8.2;
189 format C2T_for_the_current_year percent8.2;
190
191 run;

NOTE: Division by zero detected at line 186 column 47.
NOTE: Division by zero detected at line 187 column 51.
TEAM=IBG OTHERS ACCOUNTS_OPENED_LAST_MONTH=0 C2T_till_date_for_last_month=0 Accounts_current_year=0
Accounts_C2T_current_year=0 New_Traders_today=0 New_Traders_current_month=0 C2T_for_the_month=.
C2T_for_the_current_year=. _ERROR_=1 _N_=1
NOTE: Division by zero detected at line 186 column 47.
NOTE: Division by zero detected at line 187 column 51.
TEAM=QATAR ACCOUNTS_OPENED_LAST_MONTH=0 C2T_till_date_for_last_month=0 Accounts_current_year=0
Accounts_C2T_current_year=0 New_Traders_today=0 New_Traders_current_month=0 C2T_for_the_month=.
C2T_for_the_current_year=. _ERROR_=1 _N_=7
NOTE: Mathematical operations could not be performed at the following places. The results of the
operations have been set to missing values.
Each place is given by: (Number of times) at (Line):(Column).
2 at 186:47 2 at 187:51
NOTE: There were 11 observations read from the data set VINOD.NRI_TEAM_WISE_CONVERSATION.
NOTE: The data set WORK.NRI_TEAM has 11 observations and 9 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.01 seconds

this is error occuring

Mathematical operations could not be performed at the following places. The results of the
operations have been set to missing values.

values missing in the dataset and calculations was not performed showing error and wd use

Re: BASE SAS

art297 — Sat, 10 Jun 2017 12:50:46 GMT

You are trying to divide a couple of numbers by avariables that have a value of 0.

You would have to show some example data of what you have, what you want to do with that data, and the file you want as a result (based on that example data).

Art, CEO, AnalystFinder.com

Re: BASE SAS

WarrenKuhfeld — Sat, 10 Jun 2017 12:51:53 GMT

http://support.sas.com/kb/19/965.html

Try the DIVIDE function rather than '/'.

Re: BASE SAS

Reeza — Sat, 10 Jun 2017 15:50:50 GMT

1. This is not an Error, it's a Note. It tells you something may be wrong.

2. Error is clear:

Note: Division by zero detected at line 186 column 47

3. Check Line 186

Fix line in question and repeat until all Notes are either acceptable or gone.

@vinod4842 wrote:

data NRI_team;
/*retain TEAM ACCOUNTS_OPENED_LAST_MONTH C2T_till_date_for_last_month C2T_for_the_month */
/*Accounts_current_year Accounts_C2T_current_year C2T_for_the_current_year New_Traders_today New_Traders_current_month; */
set vinod.Nri_team_wise_conversation;
C2T_for_the_month=C2T_till_date_for_last_month/ACCOUNTS_OPENED_LAST_MONTH*100;
C2T_for_the_current_year=Accounts_C2T_current_year/Accounts_current_year*100;
format C2T_for_the_month percent8.2;
format C2T_for_the_current_year percent8.2;

run;

log file::::::::::::::

182 data NRI_team;
183 /*retain TEAM ACCOUNTS_OPENED_LAST_MONTH C2T_till_date_for_last_month C2T_for_the_month */
184 /*Accounts_current_year Accounts_C2T_current_year C2T_for_the_current_year New_Traders_today
184! New_Traders_current_month; */
185 set vinod.Nri_team_wise_conversation;
186 C2T_for_the_month=C2T_till_date_for_last_month/ACCOUNTS_OPENED_LAST_MONTH*100;
187 C2T_for_the_current_year=Accounts_C2T_current_year/Accounts_current_year*100;
188 format C2T_for_the_month percent8.2;
189 format C2T_for_the_current_year percent8.2;
190
191 run;

NOTE: Division by zero detected at line 186 column 47.
NOTE: Division by zero detected at line 187 column 51.
TEAM=IBG OTHERS ACCOUNTS_OPENED_LAST_MONTH=0 C2T_till_date_for_last_month=0 Accounts_current_year=0
Accounts_C2T_current_year=0 New_Traders_today=0 New_Traders_current_month=0 C2T_for_the_month=.
C2T_for_the_current_year=. _ERROR_=1 _N_=1
NOTE: Division by zero detected at line 186 column 47.
NOTE: Division by zero detected at line 187 column 51.
TEAM=QATAR ACCOUNTS_OPENED_LAST_MONTH=0 C2T_till_date_for_last_month=0 Accounts_current_year=0
Accounts_C2T_current_year=0 New_Traders_today=0 New_Traders_current_month=0 C2T_for_the_month=.
C2T_for_the_current_year=. _ERROR_=1 _N_=7
NOTE: Mathematical operations could not be performed at the following places. The results of the
operations have been set to missing values.
Each place is given by: (Number of times) at (Line):(Column).
2 at 186:47 2 at 187:51
NOTE: There were 11 observations read from the data set VINOD.NRI_TEAM_WISE_CONVERSATION.
NOTE: The data set WORK.NRI_TEAM has 11 observations and 9 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.01 seconds

this is error occuring

Mathematical operations could not be performed at the following places. The results of the
operations have been set to missing values.

values missing in the dataset and calculations was not performed showing error and wd use