"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

Extract the list of variable names from SASHELP.VCOLUMN   Example: proc sql; select name from sashelp.vcolumn where libname='SASHELP' and memname='BASEBALL'; quit;     or if you just want variable names that begin with NA     proc sql; select name from sashelp.vcolumn where libname='SASHELP' and memname='BASEBALL' and upcase(name) eqt 'NA'; quit;   This should be easy to turn into a macro, if that's what you want. ... View more