It is what COALESCE functions do. As this column seems to hold what looks like a date but as a character string, the particular function might be COALESCEC() ... View more

No need for a macro at all: proc sql; create table id_year as select have.id, year.year from have left join year on have.startyr le year.year le have.endyr ; create table want as select year, count(id) as count from id_year group by year ; quit; ... View more

A csv file DOES NOT HAVE CELLS. PERIOD. A csv file has rows, and in these rows you find delimiters. These delimiters separate columns. I repeat: there is nothing like a "first cell" in a csv file. That's only what you see if you use the execrable, useless (in this context) Excel to open a csv file that does not have semicolons as delimiters. Use a text editor, nothing else.   My code proves that a file with the layout you posted is easy to read into a dataset directly. If it does not work for you, post a sample of your file as is (not what you see in Excel!!), if necessary, attach it to the post. ... View more

New = raw+ 7 *24*3600 ; A SAS datetime value is an integer number of seconds. There are 3600 seconds in each of the 24 hours in a day ... View more

perhaps TAG = ^^mod( col2, 1 ) ; where TAG should be 1 when there are decimals, and 0 when col2 is integer or missing ... View more

Hi:   It's not a good idea to post your new question in a post from 2009. And your question is not really related to the original topic of this post. If you have a new question, it's probably a better idea to make a new posting. It may be easier to create the Contents or Index and change the label after you open the file with Excel. The change you want may have to be done with a TAGSET template change, I do not believe you can make this change with a style. This type of question would best be handled with Tech Support. I am not sure whether they recommend trying to modify tagset templates anymore. The TAGSETS.EXCELXP tagset is complex and in changing one thing, you could break another. I would recommend working with Tech Support on this question. Cynthia ... View more

Thanks for the lengthy reply. Personally, I am not confusing anything. My &maxlength. was 6 which resulted in 6 new variables in my case. I was having an issue with the default length of the 6 variables, which was truncating the strings I assigned to them. The way I read OP's question, it seemed he wanted to store different lengths in his array variables so I provided my solution. If OP was referring to something else, he's have to jump to some other answer. ... View more

Something about proc export, which uses ODS under the hood (so I understand) writes to the log in such a way that it bypasses whatever it was in the log break routine that has failed when killing code. Again, this only happens in some cases - sometime if you kill code it dies gracefully and the log is unimpacted. When it does stop updating, there is something about interupting the call to ODS in an export statement that manages to restart the log write. ... View more