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

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

1 ACCEPTED SOLUTION

Accepted Solutions
art297
Opal | Level 21

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

 

View solution in original post

3 REPLIES 3
art297
Opal | Level 21

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

 

WarrenKuhfeld
Rhodochrosite | Level 12

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

 

Try the DIVIDE function rather than '/'.

Reeza
Super User

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


 

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 4429 views
  • 0 likes
  • 4 in conversation