I am looking  to extract from a code in a field the last only three characters - am trying to do this in SAS® Data Studio - Prepare Data. Using data prep from SAS Viya 3.5   Code in the field can look something like this      265265414TGA And I want to extract/include only the last 3 characters TGA   I dont want to code this in if possible rather use the options available Any suggestions - thanks ... View more

In Data Plans and in 'New calculated item' I want to create a new category so I can display on its own the max date of a field (as in the latest submisison date is xx/xx/xxxx Max [_ForAll_] ('submission_date'n) I have tried the MAX operator but it states I wish to make this available in my SAS Viya report but make the changes above in Data Plans. I do not wish to use SAS code Any ideas   Thanks     ... View more

Hi - looking to convert an 'id' integer which has been taken in as a measure but wish to make it a category. Can anyone let me know what the empty fields in the image should be entered with. Thanks. ... View more