Hello,   I am working on a dataset (see below). The dataset list the components of a product and other relevant information.    Dataset                                                                                                FirmID   ProductID  BeginYear   MarketYear   Components                    10001     AB259T      1996             1998              B30 | A                         10001     AB259T      1996             1998              V55 | U                         10001    AA386G      1999             2001              T92 | B                          10001    AA386G      1999             2001              R26 | L                          10001    AA386G      1999             2001              V55 | U 10002    CT746B       2007            2009              U38 | P 10002    CT746B       2007            2009              X48 | O 10002    CT746B       2007            2009              K93 | E 10002    RU239F       2008            2010              O28 | L 10002    RU239F       2008            2010              A47 | W 10003    TY569I         2008            2010              Q15 | P 10003    GC992M      2009            2011              W91 | O 10003    GC992M      2009            2011              Q15 | P    All the components of each firm consist of a component base. This component base is updated annually as firms introduce more products. For example, the component base for Firm 10001 in 1996 only includes two components ( B30 | A and V55 | U) and it has four components in 1999 ( B30 | A, V55 | U, T92 | B and R26 | L).    I would like to know how many incremental products and radical products each firm has for each year.   If all the components of a new product do not overlap with the existing component base, it will be considered as radical products. For example, RU239F is a radical product for firm 10002 because none of its components overlaps with its existing component base.   If one of the components of a new product overlaps with the existing component base, it will be considered as incremental products. For example, AA386G is an incremental product for firm 10001 because one of its components (V55 | U) already exists in its component base. So as GC992M for firm 10003.   Can anyone tell me what code do I need to use? Thanks. ... View more

Hi    I used the code below.     Idcode is the label for cite_come so that column showed "idcode". I tried to remove the label but there is a note saying "Variable idcode is uninitialized". How can I solve this issue? Thanks. proc sql; create table want as select a.*, b.idcode as cite_com from have1 as a, have2 as b where a.Var1=b.Var2; quit; data want; set want; label idcode = ' '; run; .  ... View more

Hi,   I am running SAS on a supercomputer (Linux system) and an error message was shown in the log file.   ERROR: An I/O error has occurred on file WORK.CC.DATA. ERROR: UNIX errno = 122   I searched this error message and most of the UNIX errno = 24 rather than 122. What is the difference?    The number of observations is 10,000. I tried to decrease it to 5,000 and even 2,5000 but it did not work. How can I fix this issue? Thanks. ... View more

Hello,   I have two files and I want to add the missing value from file 2 to file 1.   For example, File 1 has ALL IDs but incompleted variable 1 (character variable). File 2 has completed Variable1 and their corresponding IDs.   When ID = 1 or 3, variable1 is incomplete as highlighted in File 2. ID = 2 does not show in File 2, which means when ID = 2, Variable1 is completed. I would like to merge these two files as File 3 shows.   File 1                        ID          Variable1 1                A10 1                B20 2                G11 2                G12 2                R13 3                E25 3                E38 3                F69   File 2 ID          Variable1 1                A10 1                B20 1                C30 3                E25 3                E38 3                F69 3                D87   File 3 ID          Variable1 1                A10 1                B20 1                C30 2                G11 2                G12 2                R13 3                E25 3                E38 3                F69 3                D87   what code do I need to use? Thanks. ... View more

I have two data sets as following below.   Data set 1 is a list of company names.   Name Apple Google Amazon   Data set 2 has the following variables.   ID           Year1       USname             nameO                                  Country    Year2 01           1992          Apple                 Apple | Ford                             US          1993      02           1993         Alphabet            Toyato | Amazon                       US          1995 03           1994       Amazon.com       Amazon                                     US          1996 04           1995         Alphabet            Google                                      US           1997 05           1996          IBM                     IBM                                         US            1998   Name in data set 1 is the same with nameO in data set 2 (Google) or Name in data set1 is partly same with nameO in data set 2 (Apple).   What I want is to match these two data sets as long as NameO is partly same with Name.   Expected ID           Year1       USname             nameO                                  Country    Year2           name 01           1992          Apple                 Apple | Ford                             US          1993            Apple 02           1993         Alphabet            Toyato | Amazon                       US          1995           Amazon 03           1994       Amazon.com       Amazon                                     US          1996          Amazon 04           1995         Alphabet            Google                                      US           1997          Google   @Ksharp offered the following codes to me. It is helpful.   proc sql; select * from b inner join a on b.nameO contains strip(a.name); quit;  However, I found another problem.    I found that Names using the upper case such as "APPLE" in data A cannot be matched with NameO using lower cases in data b such as "apple" or "Apple".   Is there any way to ignore the lower case or upper case? Thanks. ... View more