The CSV file has many columns, and 2 of these columns' values are text (short paragraphs). I am using  delimiter = ',' It seems SAS recognizes any comma inside the paragraphs as a delimiter and reports an error. Is there a good way to properly import such files? ... View more

My code returns unexpected result as follows: x = index(lowcase(security_name), lowcase("alltel communications")); x2 = index(lowcase(security_name), lowcase(name_holding_clean)); Shouldn't x=x2? My guess is that it's related to the length of name_holding_clean, but not sure how to deal with it.   ... View more

I thought this was easy but got stuck. I have a dataset that is simply a list of strings. My macro needs to loop through this list, each time using one string from the list in a proc. What is an efficient way to make this work?   _______________________________________________________________________________________________________________________ Please see below for a minimum exampe. I have two datasets (their actual versions are much larger):   data have1; input string $6.; datalines; AB C DEF G H I ; run; data have2; input issuer_id 3. security_name $20.; datalines; 101 AB C security 05 101 Ab C security 012 103 DEF security 02 104 DEF bond 03 104 Def bond 11 109 G H I security 09 112 G H I bond 04 ; run; What I want to do: for each value of string in have1, among all observations in have2 where security_name contains the value, count the number of unique issuer_id: %macro count_id(in_string); proc sql; select count(unique issuer_id) as num_id from have2 (where = (index(lowcase(security_name), lowcase(&in_string)) >0)); quit; %mend; I want to put this count back to have1. The below is similar to suggestions by @Kurt_Bremser @RichardDeVen : data want; set have; count = dosubl('%count_id(string)'); run; However, the error message I got is "ERROR: Variable string is not on file WORK.HAVE2."   ... View more

I have a dataset that has multiple groups of observations. There is a variable, flag, which either takes value 1 or missing. I want to create a new variable to divide each group into subgroups based on the value of flag. Whenever flag = 1, start counting a new subgroup. Please see the code below as an example. data have; input group flag; datalines; 101 . 101 . 101 1 101 . 101 1 101 . 101 . 102 . 102 1 102 . 102 . ; data want; input group flag new_var; datalines; 101 . 1 101 . 1 101 1 2 101 . 2 101 1 3 101 . 3 101 . 3 102 . 1 102 1 2 102 . 2 102 . 2 ; ... View more