6 data work.total;
7 if Price=. then Price=0;
10 Total=sum(Price + commission) + 1000;
NOTE: Missing values were generated as a result of performing an operation on missing values.
Each place is given by: (Number of times) at (Line):(Column).
1 at 10:10 1 at 10:20 1 at 10:34
NOTE: The data set WORK.TOTAL has 1 observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.01 seconds
The SUM function returns the sum of non missing arguments. Note here that the third statement in the data step, Price=.; will assign a missing value (overwriting all previous values of Price). Thus, the final value of Price + commission will also be a missing value. The SUM function will have one missing argument resulting in a missing value. With the program above, the following data set created:
The one and only FREE resource for general SAS online training as well as study guides for the SAS Base Certification. My goal is to create the SAS Certification prep guide that I never found but always wanted. This should also be a place to come if you are new to the language but are simply looking for online SAS training.