Hi!   I am a new user to SAS and was wondering how I go about transposing my dataset. It currently looks like the following:   continent        industry       total A                    0509            37 B                    0509            78 C                    0509            12 A                    1315             85 B                    1315             26 C                    1315             73   and I need it to look something like this:                                            continent industry     variable           A         B          C 0509          total                37        78       12 1315          total                85         26       73   Should I use proc transpose? Apologies if this is very simple, I am very new to SAS !! 🙂   Thank you! ... View more

Hi!   I am a new user of SAS and needed some help merging columns.   I have a dataset in which there are two columns and I would like them to be merged to produce one column however it will contain character and numerical values.   Section         Division                               I would like it to look like this ->                    Industry A                  1                                                                                                                A1 B                  2                                                                                                                B2 B                  3                                                                                                                B3 C                 4                                                                                                                 C4 D                 5                                                                                                                 D5   just wondering how I would go about merging these two columns?   Thanks!   Jaina   ... View more