Thanks PG.....That worked perfectly!!!.... ... View more

Hi PG....thank you for your response. I am not too sure if I would get the complete data from your suggestion. The reason I have to select distinct ID's first is that I only want data based on when the Surcharge is less that a certain percent of the cost which changed on a certain date (20150908) for this particular Num and SIN. Once I have a list of distinct ID's based on these condition, I need to go back to the same dataset and extract a complete dataset for only these ID's as they will have other records with different SIN. So really I want to end up with a complete dataset for all the records in the dataset for only these distinct ID's if the 2 conditions are met. Hopefully this clarifies things....Thanks ... View more

Hi MikeZdeb...Thanks once again for your help. I ran both codes and got the exact same results but had to make a slight modification to use a IF/THEN/ELSE as I was only getting output for the new_name to those products that were in double quptation marks and had increase the length of the new_name variable. Thanks once again!!!   DATA NHPPRODUCTS2; LENGTH new_name $180.; SET Products;  IF char(PRODUCT_NAME,1) eq '"' AND char(PRODUCT_NAME,length(PRODUCT_NAME)) eq '"' THEN   new_name = substr(PRODUCT_NAME,2,length(PRODUCT_NAME)-2);  ELSE new_name = PRODUCT_NAME; RUN; ... View more

Hi MikeZdeb.....When I tried and ran your code, it actually did remove the double quoatation marks that were the first and last character but it also removed the first and last digit/letter to those product names that were not in double quotation marks. Here is the data step that I used and the output that I did get;   DATA PRODUCTS;  SET Products; new_name = substr(product_name,2,length(product_name)-2); run;   PRODUCT_NAME new_name Red Bull Energy Drink                 ed Bull Energy Drin Vitamin D 400 Iu                          itamin D 400 I Echinacea And Goldenseal        chinacea And Goldensea Flax Seed Oil 1000 Mg               lax Seed Oil 1000 M Vitamin D                                    itamin Allicin Rich Garlic                        llicin Rich Garli Glucosamine Sulfate                  lucosamine Sulfat Vitamin C                                   itamin Glucosamine Chondroitin Complex lucosamine Chondroitin Comple Vitamin B6                                 itamin B Vitamin B2                                 itamin B Vitamin C Timed Release          itamin C Timed Releas Vitamin C 1000 Mg Timed Release itamin C 1000 Mg Timed Releas Milk Thistle                                ilk Thistl Now Wheat Germ Oil Softgels    ow Wheat Germ Oil Softgel "New Era Combination "S" Biochemic Tissue Salts" New Era Combination "S" Biochemic Tissue Salts "New Era Combination "I" Biochemic Tissue Salts" New Era Combination "I" Biochemic Tissue Salts "New Era Combination "J" Biochemic Tissue Salts" New Era Combination "J" Biochemic Tissue Salts "New Era Combination "K" Biochemic Tissue Salts" New Era Combination "K" Biochemic Tissue Salts "New Era Combination "L" Biochemic Tissue Salts" New Era Combination "L" Biochemic Tissue Salts   ... View more

Hi MikeZdeb.....Thanks for your help and suggestions. I did try it but it wouldn't work for me. But I did figure out a way to get what I wanted although maybe not the most efficeint way to achieve the end results. Here is what I ended up doing:   DATA PRODUCTS2;  SET Products;   NAME1 = SUBSTR(PRODUCT_NAME,1,1);   NAME2 = SUBSTR(PRODUCT_NAME,2,LENGTH(PRODUCT_NAME)-1);   NAME3 = SUBSTR(PRODUCT_NAME,1,LENGTH(PRODUCT_NAME)-1);   NAME4 = SUBSTRN(PRODUCT_NAME,MAX(1,LENGTH(PRODUCT_NAME)-0),1);   NAME5 = SUBSTR(NAME2,1,LENGTH(NAME2)-1); RUN; DATA PRODUCTS3;  SET PRODUCTS2; IF NAME1 ^= '"' AND NAME4 = '"' THEN  NEW_NAME = STRIP(NAME3)||STRIP(NAME4); ELSE IF NAME1 = '"' AND NAME4 ^= '"' THEN  NEW_NAME = STRIP(NAME1)||STRIP(NAME2); ELSE IF NAME1 = '"' AND NAME4 = '"' THEN  NEW_NAME = STRIP(NAME5); ELSE IF NAME1 ^= '"' AND NAME4 ^= '"' THEN  NEW_NAME = PRODUCT_NAME; ELSE NEW_NAME = ' '; RUN; ... View more

Hi PaigeMiller......I did give the DEQUOTE function a try.....it did remove the double quotation marks but it remove part of the product name....for the example I had submitted.....the product name ended up being New Era Combination ... View more

Hi Patrick.....thanks for you help. I did try including the Length Statement and I get the following warning mesaage:   WARNING: In a call to the CATX function, the buffer allocated for the result was not          long enough to contain the concatenation of all the arguments. The correct          result would contain 327 characters, but the actual result may either be          truncated to 262 character(s) or be completely blank, depending on the calling          environment. The following note indicates the left-most argument that caused          truncation.   I did try using the compress function and the error message was gone but I don't want to remove blanks. ... View more

Hi RW9....Thanks for your help. I tried it and I get a 1 for the first Numb ( as from the first If Statement) and all the rest are empty blanks... ... View more