I am trying to import excel file to SAS using Proc Import. There are 3 columns in Excel file.One of the column have different values separated by random delimiters like comma or space or 'and' or double space..seems very random.   Given Excel file data   ID            Values                                   Date 1             2017138                          2/16/2018 2             2017456 2017778           2/16/2018 3             2017458 and 309878      2/16/2018 4             20178  2078654              2/15/2018     Output needed:   ID             Values                         Date 1              2017138                    2/16/2018 2              2017456                    2/16/2018 2              2017778                    2/16/2018 3               2017458                    2/16/2018 3              309878                      2/16/2018   I want like above output,treat the values for ID 2 into two separate observations, Is it possible to create output (multiple observation) like this from a single record during proc import or in Data step/Data step after importing?   Thanks for checking! ... View more

I have a big report that have 90 columns (I have used proc sql- Combined many datasets finally).  Is there any way, to move the 60 th and 61st column to the end. I don't want to list all the columns in the Select Column. Wanted to move only few columns to the end and rest should stay same. ... View more

  I am trying to get the output like below in Proc SQL instead of using first. and last.variable If any ID consists Y or N,  I only need Y all the time.    ID     Product 1         Y 1         N 2         N 3         N 4        Y 4         N   Output: ID      Product 1         Y 2         N 3          N 4         Y     Thanks for looking   ... View more

Hello,   I was using the XMLAGG function in Oracle and it throws me an error. Would like to try the same in SAS. Need a new column with all the values separated by comma.    Please  note: The product data is huge and hence I got the error in Oracle like ERROR: ORACLE execute error: ORA-19011: Character string buffer too small.     Data:   ID      Product      1        x                  1        y                  2        s                 2        j 2        k   Output:   Id   NewColumn 1     x,y 2     s,j,k     Thank you for looking! ... View more