According to my understanding of RETAIN, the code is doing what it is supposed to do. Since DUMMY is a retained variable, and for the second row where var1=. DUMMY does not get assigned a value in the code. So it RETAINs the value from the previous observation.   Over the years, I have seen a lot of people spend a lot of time trying to get columns in a specific order. And I think in 99.9% of the cases, there is no need to do this at all, and the time spent ordering the variables is essentially not productive in my mind. Maybe yours is the 0.1% of the time where a specific order is required — please explain why you think you must have a specific order. ... View more

If you have multiple groups on a plot, you can use the STYLEATTRS command in PROC SGPLOT to designate symbols for each group, and specify the desired symbols in the DATASYMBOLS= option. Example: proc sgplot data=sashelp.class; styleattrs datasymbols=(diamond circle) datacontrastcolors=(red green); scatter x=height y=weight / group=sex; run;   ... View more

"I have a standard start date and a numeric time (in two separate fields)" — what are the variable names? Please don't make us assume we know which variables you are referring to, because we could get it wrong. Better, you should specifically tell us. Also, are these variables numeric or character according to PROC CONTENTS?   "... and a standard end date and numeric time (in two separate fields)" again we need the same information as above.   Your data doesn't vary except in the leftmost column REFERENCE_DATE. Maybe a more realistic example would be helpful. And also, we need data provided in a form we can use, which is WORKING SAS data step code (examples and instructions). ... View more

Thank you. Try this:   data have1; set have; date=input(cmendtc,yymmdd10.); run; proc summary data=have1 nway; class subject; var endt; output out=maxx max=max_endt; run; data want; merge have maxx; by subject; if missing(endt) then endt1=max_endt; else endt1=endt; format endt1 date9.; run; ... View more

Please explain the logic by which 109 has values 25SEP2011 filled in (and not some other value) when CMENDTC is missing. Don't make us try to figure out what you want from an example — show us the example and TELL US the logic to get what you want. ... View more

I think I get it, but this really is a job that is perfectly and easily done in Excel. It probably could be done in SAS, but it would take a lot more effort. ... View more

The title of your post indicates you want to add some values. Please explain this in more detail. ... View more

Most of us will not download Excel (or other Microsoft Office) files because they can be security threats. Better to present the data using working SAS data step code (examples and instructions) or the less desirable action is to show us a screen capture of the Excel file using the "Insert Photos" icon (do not attach files)   In general, you can read Excel with PROC IMPORT, or LIBNAME with the Excel engine. ... View more

@LinusH wrote: I can't see that you can do this without losing data consistency. It seems now that you put values on the same row based on the input data order. What is the meaning of each row in the new table? Good point. It is hard to make sense of the new table, without additional explanation. ... View more

It is not "bloating this thread" to explain the background behind your problem. In most cases, it is a necessary ingredient that ought to be in the very first post on the topic. And in this case, @Rick_SAS has been asking for this background information.   In fact, when people focus entirely on the code problem they have and do not provide background, I think this is usually a poor way to get help. When we know the background and the code problem you are having, we can often provide alternative ways to get there rather than the approach the user is taking in writing code; often the alternatives are simpler to code and will run faster.  ... View more

Does this help?   https://communities.sas.com/t5/Statistical-Procedures/Filtering-Correlation-Matrix/m-p/645388#M30980 ... View more

Does not the answer from @Kurt_Bremser to use Maxim 4 apply here? ... View more

Google finds lots of discussions on this topic. ... View more