Note that while spreadsheets have a lot of problems to begin with as @Tom mentions, when they contain PICTURES they are completely useless as we can't even see which are numeric values or character, what might be calculated, and in the case of conditional behavior like your inserting a line can't see what conditions might be used in the spread sheet. As a minimum provide raw values as text, preferably pasted into a text box opened with the </> icon. If you are going to show pictures you can use the camera icon to insert pictures that appear in line in the message.   Your example shows "change of number" and "end of month" that do not include your inserted line. So you need to clearly state why or why not that occurs. Number = 2314185036 and Trans_dte=31Mar2025 for example.   The behavior I think you are requesting may be possible with Proc Report once you  have a SAS data set. Maybe. Need more details of the data and the rules involved. For example looking at that example I am not sure what you are subtracting. Where is the "table" that you get the "unearned bal" from? That would be a critical part of ever accomplishing this. Linking values from that table to the data used for this is likely to be a non-trivial exercise.   Your statement "Now when the next month arrives, the calculation must do the same but instead subtract the new unearned_bal for the month from the first line." brings up question like how does the "next month arrive"? Is it a separate file, what type? This is going to lead to data management questions like creating data sets (warning: Spreadsheets cause half or more of the data related questions on this forum), combining the data sets, selecting records. And does the table with the "unearned_bal" also change? ... View more

@skumar46 wrote: Sir, I appreciate you taking time to response. I am basic sas user and trying to learn with the help of chatgpt & deepseek neither i couldnt find solution there nor i am able to catch you. I would request you to review my codes in intitial enquiry and then just provide your complete code which should be workable by pasting in sas on demand then i will be able to check and share with you the logs as such i am not able to co-related your points. Pls paste here code/(s) starting from 1st line of code and run; word. Strongly suggest you add a lot of description to what you are attempting. For example, why are you using the loop counter Sim_id as the MEAN of a normal distribution? Why are you trimming the values? Why did you overwrite the original values of the RAND calls with those min/max function results?   And I repeat, that since you are using an input data set that you provide an example of that set as working data step code.   Do also note that SAS offers a free introductory programming course. I cringe at the idea of trying to learn from Chatgpt generated code considering some of that code that has appeared on this forum. One example had something like 6 syntax violations in the first 8 lines. ... View more

It is a good idea to include the LOG with the code and ALL the messages generated by a procedure. There are often clues provided in other messages.   Best to provide and example of the data as a working data step that behaves the same as your full data set. Note that sometimes the process of making one of these example sets and testing to see that the behavior is the same gives clues to a solution. ... View more

@eiger wrote: I'm running SAS 9.4 on Windows. I have a loop that subsets the data, then runs proc surveymeans for the subset of data. The original code is shown below. You should read the section in the online help in the syntax section of the BY statement about subsetting the data in the survey procs, such as you are doing, does not yield valid subpopulation analysis. With Surveymeans the appropriate approach would be to add the subsetting variable(s) to the DOMAIN statement and then select the values as needed for your reports. You can have more than one variable on the Domain statement. The order of the variables does affect the order of the output data sets so may want to experiment.   Note that adding your IMPLIC variable to the Domain statement would also mean no Macro loop is needed. The syntax to get levels of Implic with each level of Igroup would be : Domain Igroup * Implic ;     ... View more

You would need to provide the INPUT data set Portfolio_sim to mean anything.   Since you are using SIM_id as the MEAN of the NORMAL distribution you will have most of your values of the result of the RAND calls close to 2, 3, 4 etc. So pretty much 9 out of 10 of those mean that min(random_PD, 1) are returning 1 so the max(0,1) are returning the 1. And only half of the Sim_id=1 even have a chance of returning a value less than 1.   And then you overwrite the values of the random results so you cannot see that your original values are mostly way larger than 1. Modify these to create new variables to see why you get mostly 1's as results. /* Constrain to valid ranges */ random_PD = max(0, min(random_PD, 1)); random_LGD = max(0, min(random_LGD, 1)); Do you know what percentage of results of a call such as rand("NORMAL", Sim_PD, 0.01) will have a result withing +/- 0.02 difference from Sim_PD? Until you understand what the standard deviation is doing to those calls to rand('Normal') (do note the default for Normal is an SD=1) you should be very careful specifying it.   Or better yet, describe what sort of result you expect to be returning as I thing @PaigeMiller is on track. ... View more

WHY is your log size so large?   Are getting lots of warnings such as invalid data messages from a data step? Are you specifically writing stuff to the log? A macro loop that generates 100,000 calls to a procedure?   Did you open the log externally as suggested? Can you discuss the contents? Several of the above types of log entries can be reduced or indicate that your code needs adjustment. ... View more

@linlin87 wrote: Dear SAS New User, Please can help with this problem, it trying to detect and enumerate drops in relative humidity (RH) by geographical location. The drop needs enumerating for later analysis. Defining drop in RH follows rules: 1) to be a drop in RH it must have 3 consecutive datapoint in humidity below a threshold (less than or equal 30%). 2) The drop in humidity finishes stop if there are 3 consecutive points above threshold (31% and above). 3) Then on the next started drop (within that location), it labels drop as +1.  I would say that you need to reconsider your rules a bit. I suspect this has more that a bit of "boundary value problem" behavior, meaning that the boundaries of the "drop" and end intervals have not been clearly enough defined. For example you are saying "threshold (31% and above)" which leaves a gap between the less than or equal to 30. You shown data may not indicate any such but Relative Humidity  is a continuous measurement and values like 30.5 need to be accounted for in the programming. OR you need to explicitly state that you have only integer values.   Also you have no rules addressing missing values. What would you do if you have an hour with no value? Or what if sequential Datetime values are excessive, such as 2 hours between measures for the same location?   I'm not sure that your rules clearly define what the result should look like with values like 31 32 31 28 27 28 31 29 33 27 37 21 36 32 21 22     BTW I would not call this a "drop", but a "below threshold". Short hand names can create confusing statements in a narrative when it is hard to tell whether a "variable" or "data value" or external physical process might be meant. A value reduction from 32 to 31 would be considered a "drop" by most people if discussing numeric values where as value change from 28 to 29 would be considered an increase and not a "drop" in any form.   What about RH less than 0 or greater than 100? Theoretically shouldn't occur but I have seen instrument reading outside that range. I've also had instruments that missed reporting intervals because of failure or maintenance. So I am used to considering the time between measurements as important for any such change of values.     ... View more

@SASdevAnneMarie wrote: Hello Experts, I am wondering how to join with sas sql the tables without overwriting the variables. For example,  I would like to join this data, but in output I would like to have the Value_1=50, Value_2=50. Key Value PI23X 50 PI23X 50   Thank you foryour help ! In addition, it would be a good idea to show the code that is generating this "overwrite" of the variable. I am actually suspecting what  you are seeing is duplication of key with different values of "value".   It really isn't clear if "Value_1=50, Value_2=50" means that you have two variable on an observation with different values or not. ... View more

Please provide example data in the form of a working data step. Your data step has two issues. First the DATALINES statement needs a semicolon to end it, other wise the lines of data are part of the DATALINES statement and generate errors. Second is the use of "smart quotes" or curly quotes as highlighted below: 111 ‘EIEA’ 1 0 value The curly quotes are treated as characters not delimiters as the quote from the key board is. So the above generates values with the quotes in them. Third your input statement doesn't include instructions to read "value" as character so you get missing numeric values for the variable Percent. Even with dummy data the variable type and values should match.   Also to test your code, and possibly solve the problem, we need the definitions of the custom formats used for the variables Food_group, Nutrient and Select_var. ... View more

@PanShuyao wrote: I want to know some details about monotone regression multiple imputation. According to the Example provided in SAS Support Document, we can use the DETAILS option and the parameters estimated from the observed data are displayed. We can see that the parameters estimated with observed data using PROC MI are 0.98587(Length1) and -0.04249(Intercept). My understanding is that this result is based only on the observed data, similar to the results we usually obtain from linear regression. Compare the color highlighted section above with this from the OVERVIEW of Proc MI: Instead of filling in a single value for each missing value, multiple imputation replaces each missing value with a set of plausible values that represent the uncertainty about the right value to impute (Rubin 1976, 1987). The multiply imputed data sets are then analyzed by using standard procedures for complete data and combining the results from these analyses   So Proc MI will "use" cases that Genmod doesn't due to missing values. Did you compare the compare of observations used by the two procedures?   I don't know why you didn't include the Proc MI code you used so we could see what you actually ran.   There may also be implementations of code within each procedure that will result is slightly different values just because the code to perform similar tasks is written differently. ... View more

Try adding MAJOR=3 to the Axis definition. That forces the appearance of exactly 3 major tick marks. Order affects that the order values are displayed. Major affects the number of displayed tick marks (or Minor the the number of minor ticks between each pair of Major ticks).   Better for many reasons would be to switch to Proc SGPLOT unless you are stuck with a version of SAS 8 or earlier. ... View more

No data included so we can't test this code to see what it generates. In general some example data is almost always needed as the desired solution might require adding variables or restructuring the data.   What would a "right axis Pk Conc" be? As in which variable(s).   Can you provide an example of what the final graph might look like? ... View more