Hi i am creating a new variable based on an existing variable using the code below: if recency < 6 and then status= '0-6 months'; if recency >=6 and recency <12 then status='6-12 months'; run; However the problem i am having is that in the output table, the new column 'status' truncates parts of the data so instead of showing 6-12months, it will display 6-1 . What statement or how can i   specify the width of the new column so it can display all the data. ... View more

Hi , i have a large dataset that includes a variable which is a record of last date of deposit for clients. So you may have Client                         Last_dep_date A                                  27/12/2007 B                                  04/08/2007 C                                  02/04/2008 ......with the earliest year being 2007 and the latest year being 2010. (Concentrating on the year only) The task is to allocate a score based on the YEAR of Last_dep_date. So that a score of 4 is allocated to 2010 and a score of 1 is allocated to 2007 . What statements can i use and how do i compose the query. Many thanks   ... View more

Hi, i have a large data set that has details of when a client first made a deposit and the last date of deposit. For instance Clent A has first_date_deposit as 15/07/2003 and last_date_deposit as 24/02/2010.(this is the date format in the dataset)  I want to create a new variable that will display the total number of months that has elapsed between the first date of deposit and last date of deposit. Any suggestions? ... View more

Hi, I have a column - city within a dataset that displays the city a client lives. But some cities are recorded in upper case , some in lower case and some in mixed case so when i try to run the frequency on cities, the same city is counted twice if recorded in different cases for example, london may be recorded as : LONDON london Londnon lonDON so what statement can i use to change all the example to just one city in Uppercase i.e LONDON within the data set? Thanks ... View more