Hello everyone,    Im a sas beginner and I am trying to count the number of unique values across a range of columns (within the same row)    For example, I have 130 columns that each contain either missing values or the names of a country and sometimes the same country name repeats. I want to create a separate variable that counts the number of unique values within the range.    e.g.:       Col1      Col2       Col3         Col4      ..... Col131                  Count    U.S.        U.S.        .                                                                1     Korea     U.S.        China                                                        3     The example was for illustrative effect.   Thanks for your help!   ... View more

Hello everyone,    I have some code that is pretty much ideal for how I need to transform my data:    proc summary data=adtr.as5 nway; class year_id; output out=adtr.as6 idgroup(out[130] (lflag rdflag mflag jflag ap var5 var14 adn nation)=) / autoname; run;     However, I get:    ERROR: The parameter value 130 is not within the required range of 1 and 100. 1900 run;     I don't know how else to do this...and...I need to have the 130 id groups. If you could help me with this code or show me another way, that would be great. Bear in mind that I am by no means an advanced programmer, still pretty novice, so please don't take it too far over my head.    Thanks for your help in advance!  ... View more

Hello all,    I have a dataset in SAS, which was imported from excel (unfortunately a SAS download from the master database is not an option). Also, I would prefer to manipulate this data in SAS as opposed to excel. Anyhow...    I have cells with multiple codes within them... usually like so 384849495959.... They are usually in groups of 4, with atleast 2 separate groups in a cell, and potentially up to 10 or more groups.    When I break them up using the substring command. This seems to work well... However, SAS seems confused about the number groups beyond the first one. For example.    data adt.all2; set adt.all1; if ap =2 then psic1 = substrn(var3,1,4); if ap =2 then psic2 = substrn(var3,5,6); run;      Cell 1                    after code      newcell1                    newcell2 35554555             -------->             3555                           4555      I have to specific the psic2 length at 6 even though it is really 4 or it unecessarily cuts off the number i want in the cell..      From this, I can reformat newcell1 as a numeric cell, while newcell2 will give me problems. Ive tried the to multiply, as well as compress, left, put and input functions to try and get newcell2 into a 'numeric variable.' However, I get errors everytime. From my reading it seems as though this has something to do with the hexadecimal representation. I get that it likely has to do with that, but that doesnt really help me in resolving the problem so that I have a numeric variable in newcell2 to work with. And re-inputting data is not really an option.      Anyhow, thanks for your help - advice is certainly appreciated.  ... View more

Hello everyone, first time poster, and I would really appreciate your help. Hopefully in laymens terms, since Im not super advanced with SAS. Though I use it quite a bit, I have a hard time if the code is not narrated.      So I have two variables.... and I want to compare the number combinations (separated by a comma) in column 1 with the number combinations (separated by a comma) in column 2. Every time my 'code new' variable has a number combination that is not in 'code old,' i want to have a count created as a separate variable. Im hoping that the count variable tabulates the number of codes (if any) in the 'code new' variable that are not in the 'code old' variable. Furthermore, each observation may have differing amounts of number cominations to be compared. Let me illustrate with an example      Code Old  (column 1)                              Code New (column 2)                                   Count 6222,6233,7645,6555                             6233,6555,6222,7645                                     0 7222, 7212, 7233, 7244,7555                 7244,7233,7222                                              0 5444, 5441                                              7244,5444                                                       1     So while I dont care if a code is in the 'code old' set, but not found in the 'code new' set. I DO want it to count if a number is in the  code new set that is not in the code old set...    I hope this sounds clear. While I feel like I could easily do it in excel, Im really struggling with it in SAS. And the dataset Im coding is too big for excel.    Thanks for your help in advance! Advice is appreciated.  ... View more