Hi All, I never had a dataset like this:   ID     Name    Group1     Group1_ID1   Group1_D2   Group2     Group2_ID1   Group2_D2  Group3    Group3_ID1   Group3_D2    101   Mike     English      Eng2               Eng1             Biology     Bio1                          102   Julia     English      Eng1               Eng2             Biology     Bio1               Bio2              Chemistry Che1             Che2              103   Luc      English      Eng3                Eng1             Biology     Bio1              Bio2    I always worked with dataset like the following. Can someone tell me the code how to convert the above dataset like below. My original dataset has 35 groups, so I need a code that is efficient.   ID     English  Biology   Chemistry 101  Eng2      Bio1        101  Eng1                    Che2  102  Eng1      Bio1 102  Eng2      Bio2 102                              Che1 102                              Che2 103  Eng3      Bio1 103  Eng1      Bio2     Thank you.   ... View more

Hi All, Is there a way to set maximum length of variable name in dataset?   I have the following variable:   Name1_1_sdfgasd      Name_1_2_sdfsklj    Name_1_3_asdfasd  (in this example first 7 character is unique)   I want them as:    Name1_1    Name_1_2   Name_1_3     Thanks. ... View more

Hi All, I have some variables in my dataset that doesn't have any data at all. can someone tell me how do I ignore them during the import stage or any other data step? Thanks.   PROC IMPORT DATAFILE="C:\DATA\havexlsx" DBMS=xlsx replace OUT=Apple.want; SHEET='sheet1'; RUN; ... View more