Does this not need a retain statement? ... View more

Thankyou ... View more

Hi Chris,   I'm afraid that didn't work. I have stripped my code back to create the worlds ugliest pdf.   Try running it with the Tools-->Options-->Results-->General-->Html checked and again with it unchecked.   data work.class; set sashelp.class(obs = 5); N = _n_; low = 0; mid = 1; high = 2; run; ods _all_ close; ods pdf(mypdf) file=&fileLoc. style=PEARL gtitle; proc sgplot data = work.class; text y = n x = mid text = name / textattrs = (size = 18pt color=red) backlight = 1 ; run; quit; ods pdf(mypdf) close; ... View more

Sure. There is a proc sgplot used to build some custom graphs. It is using text as one of the attributes and if EG html is check the text becomes really squished up and disassociated from the text backlighting which remains where it is supposed to bed and is not squished up. If I uncheck the html box and rerun the pdf this doesn't happen. I am not sure how or why html is affecting the pdf. ... View more

Hi Chris.   Thank you for your response. I am trying to write code that can run in multiple instances of EG or be sent to someone else and it will "just work".   I was hoping that there was a way of writing code that could set the options that I want. I have tried using ods _all_ close and it is not stopping the html EG option from affecting my pdf.   Any thoughts?   Thanks Daniel ... View more

I believe astounding is correct here. I didn't fully read the second datastep. ... View more

A datastep has an implicit loop in it. If it can detect another row in a table it will take in the values from the next row and repeat all of the instructions in the datastep again.   In your first example your implicit loop has been replaced with an explicit while loop. As that is the case we do not want it to use the implicit loop and must forcibly stop it.   In the second example we want it to read in the data line by line and are taking advantage of the implicit loop so we don't use a stop statement. ... View more

@andreas_ldsThat looks very nearly perfect. I would suggest the expression "/(.*\/)?([0-9]+)/" instead to avoid capturing the end slash if there is no data  after the slash (capture 11 instead of 11/). 132/11 132/33 33/11 11/ 33/ 33 11   @imdicksonI would suggest a website like https://regex101.com/ to test and learn regular expressions. ... View more

You have grouped the dataset by id and then all of the rows with the same id are further broken down by date. So first.id is always the start of a new id group and first.date is always the start of a new date within that idgroup.   It might be worth assigning variables to equal the first.id and first date to see how it is working exactly. Hope this makes sense. If it doesn't I'll try and create a suitable example when I'm at a computer. ... View more

On mobile at the moment so code is untested. Data work.want; Set test; By patientID; Retain dept_new; If first.patientID then dept_new = department_old; If department_old not in ('Radiology','lab') then dept_new = department_old; Run; ... View more