I'm not coding it as I'm using the task funtion so I don't have anything to show you. I don't understand what the divisions / regions relate to though. I think that I'd need something to explain what they are so that I can create something in my dataset based on postcodes.
... View more
Hi, Can anyone help me understand how to create a heat map of the UK please? I've tried using Tasks/ Graphs / Map Chart and using the SAS.maps.uk as my Data Source but I don't know how to link this to my data to show how many customers we have in each region. I expected to find a common field such as Postcode. I've tried several different options but just end up confusing myself each time so thought I'd ask for help..... Thanks.
... View more
Hi, I've formatted my dates to display at MONYY7. (Aug2016) . I expected the data to group together when I ran a proc means sum and grouped be the formatted variable but it doesn't. Is there a way to make it do so please?
... View more
Thanks but I can't do this as my data spans more than 100 years. I think the only option is to format the data in Excel to show 4 digits as per KurtBremser response.
... View more
Thanks, I agree! I can get around it like that but was hoping there was an alternative solution so that I didn't have to reformat the data every month.
... View more
My data is imported from a csv file. In the csv file, I have a date field showing dates in the format, 22/05/39. When I click on the cell I can see that the date is in reference to the year 2039 but when I import it to SAS, it shows as 1939. Can anyone help me with a way around this please? Thanks.
... View more