Agree with everyone above. Even something as simple as capital letter for each first and last name would help. Anything to determine the start position of each name element (including middle initials if there are any).   So if you altered the data in any way to make them all lowercase, then maybe you have the information you need, otherwise, you will need to request a new file with the appropriate delimiters. ... View more

Sure, you can use SAS variable lists to refer to a list of variable names, as long as they are similarly named, e.g. var1:var255   https://support.sas.com/documentation/cdl/en/lrcon/62955/HTML/default/viewer.htm#a000695105.htm   ... View more

The original post already includes the code. Upon re-reading, he does say the date variable is already associated with the SAS date format mmddyy10., therefore, the raw data is already a standard SAS date number. If you'd rather have the number than remove the format using this type of code.   data final_2; set final; format d; run;    The FORMAT statement without a format will remove a previously assigned format.   https://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000178212.htm ... View more

It appears that your data variable 'd' is already in a numeric SAS date. Run the CONTENTS procedure to see if a permanent format is already assigned to variable 'd'. If so, then the actual date will show on the printed output but the underlying data is still the numeric SAS date, i.e. the number of days since January 1, 1960.   The log note simply documents that INPUT function performed numeric to character conversion.  ... View more

Completely agree. Can't see what a DO loop may accomplish. The %put _local_ line of SAS code will give you the information you asked for in the log file.   Maybe you can tell us a little more about why you had considered/asked to have this done using a DO loop. ... View more

Good observation. Again, I don't use PROC SQL often, but the GROUP BY clause has to come before the HAVING clause.   http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a002473678.htm   SELECT <DISTINCT> object-item <, ...object-item>     <INTO macro-variable-specification < , ... macro-variable-specification>>   FROM from-list   <WHERE sql-expression>   <GROUP BY group-by-item < , ... group-by-item>>   <HAVING sql-expression>   <ORDER BY order-by-item < , ... order-by-item>>; ... View more

I rarely use SQL, therefore this might be an elementary question but I assume you are using your code with a PROC SQL statement, is that correct. SAS has implemented SQL using PROC SQL and as far as I understand, the syntax should be the same. ... View more

Hi Milenko, To answer your question, the SORT procedure (written as PROC SORT) in the SAS editor window sorts your observations based on any number of variables in your data set. For example, you mentioned dates, you can sort the data by dates, using a BY statement, and keep the first record with a given date in your data set and copy the duplicate records into a new data set using the DUPOUT= option mentioned above. Here is an example:   proc sort data=file dupout=dup nodupkey; by var1; run; Note that you can sort a data set by any number of BY variables (second line), not just the date, but other variables in your data set. Hope that helps, Maik. ... View more

Right, that's my question as well: how do you know which emails to group together in one record if there is only one column/variable containing the emails? Xia, it looks like you are interpreting the post as emails under a given letter, for example, all the emails following value "a" belong together, no emails under "b", one email under "c", and so on. Is that right? ... View more

And since I am posting responses, I might as well fix another error in my example above which was initially meant simply as an illustration to support my question but I don't want there to be incorrect code examples. Obviously, we need a TRUNCOVER and either a LENGTH statement before the INPUT statement or change the input stile to modified input which I have choses. Here it is again (although I can't do anything about the envelope icons, please ignore those): data test1; infile datalines truncover; input id: $1. email1: $14. email2: $14.; datalines; a email1@xxx.com email2@xxx.com b email1@xxx.com email2@xxx.com c email1@xxx.com c email2@xxx.com d email1@xxx.com e email1@xxx.com email2@xxx.com ; ... View more

By the way, those little envelope icons were not meant to be in the sample/example datalines code above, those got somehow added to the reply. ... View more

Hi, What identifies that the emails belong together, when there is more than one line, and how are the emails attributed to accounts/people/records? Does your data set look similar to the following or somehow different?   data test1; input id $ email1 $ email2 $ (etc.); datalines; a email1@xxx.com email2@xxx.com b email1@xxx.com email2@xxx.com c email1@xxx.com c email2@xxx.com d email1@xxx.com e email1@xxx.com email2@xxx.com ; ... View more