I have used below codes and got the counts correctly as i required, but i need to show the corresponding visits also to the data.   I do not understand what you want. Please explain in more detail, or better yet, show us. Also, you seem to have changed the original question from counting by weeks to counting by USUBJID, please explain that as well. ... View more

proc freq data=have; tables avisit; run; ... View more

I cannot imagine what this data set would look like if SORD is split into 2 columns but the other column stay as they are. Please show us.   Also, please take a step back and describe the real problem that this is related to, without reference to SAS or Excel or transforming this data. Most likely, your boss or professor wants you to solve a real problem, they didn't say transform this matrix, they asked you to solve a real problem. What is that real problem?   Also, we prefer data presented as working SAS data step code (examples and instructions). We can't really work with data in screen captures. ... View more

Please tell us what you would do with these comma separated lists by department, so that we may be able to come up with another method that doesn't involve SQL. ... View more

There is the ORDER= option of the PROC GLIMMIX statement, but I believe that affects the order of all CLASS variables.   How about this example   proc glimmix data=sashelp.class; class sex(ref=first); model height=sex/solution; run;   Of course the problem of interpreting coefficients for CLASS variables from the SOLUTION option, generally can be replaced by the easier-to-interpret (in my opinion) LSMEANS output;   Sex Least Squares Means Standard Sex Estimate Error DF t Value Pr > |t| M 63.9100 1.5735 17 40.62 <.0001 F 60.5889 1.6586 17 36.53 <.0001   ... View more

@Ronein wrote: For each set ( for example 2211 2210 2209 2208 2207 2206) need to calculate for each argument average 6 months back so for 2211 calculate average of 2211-2206 and for 2210 calculate average of 2210-2205 and so on. Please note yymm structure. This is a moving average. As I said, you want to do this in PROC EXPAND. SAS has already programmed this for you. No need for macros. In fact, before you start coding some statistical calculation via macros, you really should check to see if SAS has a PROC that will do this. And if you don't know or can't find one, you can simply ask here in these forums if there is a SAS PROC that does the statistical calculation you want.   PS: You want to calculate the moving average for variables that contain some sort of monthly average. But you don't show variables, you show NUMBERs in your problem description. These are numbers because they are not valid variable names. Please make the data or variable names clear from now on.   So back to my other point. Please tell us what you are doing, and why you are doing it, instead of just focusing on code. And please don't make us ask for this critical information repeatedly. ... View more

You are asking the same question as https://communities.sas.com/t5/SAS-Data-Science/Gini-credit-risk-model/m-p/954433#M10965 Please do not double post questions.   PS: There is an answer at your other thread. ... View more

We have already shown you how to loop over months, https://communities.sas.com/t5/SAS-Programming/calculate-macro-variables-in-structure-YYMM/m-p/951717#M372005. Which makes me wonder why you didn't try that.   This looks like you want a moving average (or moving sum) of six months. If so, then you don't want macros at all, you want PROC EXPAND. https://blogs.sas.com/content/iml/2016/01/27/moving-average-in-sas.html Of course, you don't explain anything, you just jump into the code without explanation. So, please explain the purpose of this macro, without reference to code. Don't make us guess. Don't waste our time by making us figure out what you really are doing, when you already know what you really are doing and could tell us. ... View more

data want; set have; by custid; if first.custid or balance>=0 then consec=0; if balance<0 then consec+1; run; Then use PROC SUMMARY to find the max of CONSEC by CUSTID. ... View more

You can drag the .sas file into the program editor or enhanced editor in the SAS 9.4 window.   But typically, I do not do this, I use the SAS 9.4 interface to open files. File->Open ... View more

Something like this:   if id=4 and rand('uniform')<0.3 then id=2; else if id=3 and rand('uniform')<0.1 then id=2; ... View more

Please provide example data as working SAS data step code (examples and instructions) and not as screen captures, not as Excel files, not as any other file attachment, not as copy/paste from Excel.     ... View more

The error you posted above looks like you are not trying to open the same data set. PROC PLS created OUTSIM.M08F_VS801A1_D01_PEST but your error message shows you are trying to open _TEMP16.M08F_VS801A1_D01_PEST.   We're trying to help you, but you have to help us as well. From now on, when we request the log, we want the log provided as we requested, which is not as a file attachment, but as stated above "copy the log as text and paste it into the window that appears when you click on the </> icon". We don't want hundreds of lines of the log before PROC PLS, we want the log between the line that says PROC PLS and the last line of the log for PROC PLS which is the NOTEs after the PROC PLS code. ... View more