I think far easier is to convert the text which you describe as 0.50% to 2.70% to actual numbers and then checking becomes much much much much easier. And then likely no macro is needed. ... View more

I think you would get a faster and more authoritative answer by contacting SAS technical support. You can find international phone numbers at the link.   https://support.sas.com/en/technical-support.html         ... View more

@Quentin is on the right track. Use the RETAIN statement. Give it a try, show us what you have tried.   Also, it would be extremely helpful if you can show us the desired output for this particular patient. (And hint hint hint, you should ALWAYS show us the desired output in these complex situations, we shouldn't have to ask.) ... View more

@srinivasa_attot wrote:     Statement:  proc export data=sample outfile=/home/raju/filename.xls" dbms=xls replace; run;   Is this a typographical error? You need a double quote after outfile= to match the double-quote at the end of the file name. ... View more

scatter x=Date y=Result / jitter group=Site groupdisplay=cluster markerattrs=(size=9) ;   If you mean you want one value of site on the y-axis and another site should be on the y2-axis, I don't think this is possible here with the GROUP option.   On the other hand, if you create two separate variables, lets say SITE1 and SITE2, then you could have two different SCATTER statements, without GROUP=, and you can specify which of SITE1 and SITE2 goes on the y-axis and which goes on the y2-axis. So you need to re-arrange your data to meet this requirement.   Please from now on, paste code into a code box (as I have done). You do this by clicking on the "little running man" icon and pasting the code into the window that appears. Thank you. ... View more

@Tom wrote: You get that message when your code produces graphs that need to be embedded/linked in the HTML output.   Most often is happens when you have not set the GPATH location and it defaults to the current working directory, but that directory is readonly.  Most often for SAS sessions launched for use by Enterprise Guide or SAS/Studio since those typically start with the current working directory some place inside the SAS installation directories which normal SAS users cannot write to. Which is why I never see this error message, I always use GPATH when I create graphics. ... View more

This is the same thing I linked to in my original post, which you said was wrong, you said you can't use the training data set and test data set in the same PROC PLS. ... View more

@NewUsrStat wrote: Thank you very much for your help. The reason why I have to replicate rows is because the dataset contains other variables with different values and for the subsequent analysis I have to apply different types of filters. Unfortunately, this does not answer my question about what analyses/plots/tables are you trying to create. ... View more

In my opinion, this is not a good idea, and it makes future programming difficult. See Maxim 19. Also, why do you need an output of three identical rows?   Maybe a different re-arrangement of the data would work better. Please tell us what analyses/plots/tables you would create once you have the data re-arranged as you want? ... View more

I got tired of receiving error messages from SAS telling me that a particular folder was not authorized to receive output, as in "WARNING: GPATH or PATH is not a writable directory. It will be ignored. ERROR: Cannot write image to SGprint. Please ensure that proper disk permissions are set.".   I have never received this error. What am I missing, can't you just direct the output via ODS HTML or ODS LISTING to a writable directory in your original SAS program (which is what I do)?  ... View more

@SASdevAnneMarie wrote: Thank you, but precisely, in Proc PLS we cannot use the train and test sets together in Proc. Yes, you can use the test and train data set together, in certain situations. Obviously you are not in that situation. ... View more

@Ksharp links to my exact solution for this problem. You would use the test data set in PROC SCORE, rather than the training data set, as I did in that example. PROC SCORE gives the predicted values using the PLS model. The final step where I create data set named COMPARE is not needed for the case where you want to score a test data set. The model is stored in data set COEFFS and COEFFS_T. ... View more

@Rick_SAS gives the explanation of how to predict a test data set here: https://blogs.sas.com/content/iml/2014/02/17/the-missing-value-trick-for-scoring-a-regression-model.html ... View more

Please show us the full code for PROC PLS. Paste the code into the window that appears when you click on the 'little running man' icon. (From now on, when a PROC isn't working right, please show us the full code for that PROC automatically, don't wait for us to ask)   Are there warnings or errors in the log?     ... View more

What "combined means" are you talking about? Your description doesn't include any numeric variables. Please explain further. ... View more