Hi All, I have a table as follows  F1 F2 ACC_STATUS 1 ACC_STATUS 1 ACC_STATUS 1 ACC_STATUS 3 ACC_STATUS 1 ACC_STATUS_DESC Closed ACC_STATUS_DESC Active ACC_STATUS_DESC Active ACC_STATUS_DESC Active ACC_STATUS_DESC Active     and i need below output  ACC_STATUS ACC_STATUS_DESC 1 Closed 1 Active 1 Active 3 Active 1 Active ... View more

Hi I am trying to transpose below table from  however i receive this error "ERROR: The ID value "'30NOV2022'n" occurs twice in the same BY group."   Any Help !!   MISDATE CUSTNO AdvAmt 30-Nov-22 101000307 7 31-Dec-22 101000307 7 31-Jan-23 101000307 7 28-Feb-23 101000307 7 30-Nov-22 101000520 50 31-Dec-22 101000520 50 31-Jan-23 101000520 50 28-Feb-23 101000520 50 30-Nov-22 101000545 50 31-Dec-22 101000545 50 31-Jan-23 101000545 50 28-Feb-23 101000545 50 30-Nov-22 101000800 7   to   CUSTNO 30-Nov-22 31-Dec-22 31-Jan-23 28-Feb-23 101000307 7 7 7 7 101000520 50 50 50 50 101000545 50 50 50 50 101000800 7       ... View more

Hello, I imported an excel file with arabic records and SAS displayed data correctly  when i try to save this data set to my library it returns to symbols    Any Help!! ... View more

If i have a list of 5 variable and need to derive all possible combinations for these 50 variable where no two variables are highly correlated with one another,given that i have the correlation between every two variables ( every possible pir of variables) from these 5o variables For example i need output like highest number of combination (i.e 20-30 etc from these variables ) ... View more

How to remove a special character in beginning and last of specific variable    Example "...Tes.t..." and needs to be "Tes.t" as compress function removes all dots ... View more