It looks like you have duplicate values for the ID variable, seq_no, in your input dataset. You should be able to resolve this issue by using the nodupkey option on your PROC SORT step, as follows:   proc sort data = diags nodupkey; by clm_no; run; ... View more

Yes, it is possible to change the color of your axes when using Proc Template with Layout Lattice. To accomplish this you will need to use the LAYOUT AXIS statement in the same way as with Proc GChart. For example, to change the color of the left axis to purple, you would use the following code:   layout axis=left color=purple; ... View more

Yes, you can use the DROP and KEEP options in PROC MEANS in SAS. Here is an example of how you can use them: proc means data=mydata noprint; var x y z; drop xmean ymean zmean; keep xstd ystd zstd; run; ... View more

The DO loop you wrote is incorrect. To reverse a string, you can use the SAS function REVERSE(). You can use it, like this: rev_string = reverse(Name); ... View more

The main problem in the SAS code is that the HTML output is not being created, because the ODS HTML FILE statement is attempting to create a file in a path, which contains the token 'C:\Users\LIAODO~1\AppData\Local\Temp\' which is not a directory. Consequently, the HTML file cannot be written and the error is generated. The statement should use a directory path that is valid on the system. ... View more

There are several ways to reduce the misclassification rate when using a neural network node in SAS Enterprise Miner, including: 1. Increase the number of layers and nodes in the neural network. 2. Increase the amount of training data or reduce overfitting. 3. Perform feature selection or scaling of features. 4. Add regularization to the neural network architecture to reduce overfitting. 5. Adjust learning parameters such as the learning rate. 6. Experiment with different activation functions. 7. Increase or decrease the number of iterations used to train the model. 8. Use different optimizers such as Adam optimizer. 9. Try ensemble methods such as bagging or boosting. ... View more

In order to have the title of the report print in one line, you will need to alter the code that creates the header. You will need to adjust the declaration of the header style so that the header takes up the full line width, and add a line break after the title:   `call execute('style(header)=[just=left font_face="Times New Roman" font_size=11pt asis=on font_weight=bold with=100%];'); call execute('title j=l h=11pt 'Moderate/Severe COPD Exacerbation Requiring Systemic Corticosteroids or Antibiotics or Hospitalisation or LRTI in the 4 Weeks Prior to Study Entry or During Run-in Period (EC 2)'); call execute('split;');` ... View more

You can do this by creating a 'lag' column for each of the columns in your dataset and then use the 'pred_rate' equation to calculate the predicted rate. Here is how to do this: 1. Create the lag columns for each of the columns in the dataset. The lag column should contain the values from the previous period_dt. 2. Use the pred_rate equation to calculate the predicted rate for each period_dt. 3. Use the predicted rate for the next period_dt in the pred_rate equation instead of the actual rate. 4. Repeat steps 2 and 3 for all period_dt in the dataset. For example, for period_dt 1-Mar-19, the equation would be: pred_rate= rate_lag1 -0.68944167689726*rate_diff_lag1-0.4791311284*rate_diff_lag2; where, rate= volume/fee; rate_lag1 = lag(rate); rate_lag2=lag2(rate); rate_diff = rate - rate_lag1; rate_diff_lag1 = lag(rate_diff); rate_diff_lag2=lag2(rate_diff); For the next period 1-June-19, the equation will be: pred_rate= pred_rate_lag1 -0.68944167689726*pred_rate_diff_lag1-0.4791311284*pred_rate_diff_lag2; where, pred_rate = predicted rate, pred_rate_lag1 = lag(pred_rate); pred_rate_lag2 = lag2(pred_rate); pred_rate_diff = pred_rate - pred_rate_lag1; pred_rate_diff_lag1 = lag(pred_rate_diff); pred_rate_diff_lag2 = lag2(pred_rate_diff); You can then repeat this process for all the period_dt in the dataset. If i get it right. ... View more

Thanks! ... View more

Where the 'update_table' table matches the 'master_table' key by key, overwrites all (non-key) fields with the field values ​​in 'update_table'. (Both tables have the same fields.). Thanks! ... View more

Thanks!  If I want to update table' b' locally instead of 'want' table and there is an index on the 'b' table, will it be dropped or retained? So after the data there will be the ' b' table and after the set there will be also the 'b' table.   ... View more