Dear SAS users,   The macro variable "thisyear" cannot be resolved in the Filename statement.   %let thisyear = 2024; filename DIRLIST2 pipe 'dir "\\msnlgoudcp3102\nlgouddata\GLC\LZ-analyses\to be printed\&thisyear\vetzuur" /s'; data dirlist_LZ; length buffer $256 ; format file $200. GLC_where $3.; infile dirlist2 length=reclen ; input buffer $varying256. reclen; run; Could you please offer a solution how to solve?   Thank you,   Cornelis   ... View more

Hello SAS users,   I have a table where I want to mark every observation with events 'Opened' and 'Close'. Column Valve describes the position of a valve, where 1 = open and 0 = close. At 26FEB24:04:52 the valve is opened and column 'Status' must mark this with 'Opened' At 26FEB24:04:54, the valve is closed and must have the status 'Closed'. In fact, the valve is opened during 3 minutes.   Could you give me a clue how to program/add column Status with Opened/Closed taking into account that the valve will be opened for 1, 2, 3 and more minutes?   Thanks and looking forward,   Best Regards,   Cornelis     ... View more

Hello SAS users,   I have a data set where I want to group together. There are two input columns: Start and End (times).  Row 1 and 2 are connected with each other because Start (row 2) = End (row 1). The desired output must have a column 'Group' with value 2 where '2' refers to _N_ = 2.  The Start and End in row 3 cannot be grouped with the values in observation 4 and therefore have Group = 3. Row 4 - 7 can be grouped together, therefore Group = 7. I suppose that Retain may help, but it does not provide me the solution, so far.   Could you demonstrate the solution?   Best regards,   Cornelis         ... View more

Dear SAS users,   I have written a simple program for preparing a HTML webplot normal probability. Here is the SAS code: %macro plot; data pplot; %do k=1 %to 10; y = ranuni(5);output; %end; run; /*annotate to add a red circle in the probability plot*/ option mprint; data anno1; x=0.6; y=50; text='circle'; size=3; position='3'; color ='red'; style='arial'; xsys= '2'; ysys= '2'; function='symbol'; when = 'a'; output; run; /*Make a probability plot*/ goption reset = all device = jpg; ods graphics on / width=5in; ods graphics on / height=5in; ods noproctitle; filename odsout 'c:\temp'; ods html body="plot.html" path=odsout gpath=odsout; ods graphics on; proc univariate data=pplot noprint; probplot y / normal (mu=0.6481 sigma=0.2725) annotate=anno1 rotate; label y = 'Y random'; run; ods listing; ods html close; %mend plot; %plot; The problem is that the red circle is not visible in the annotate function, the webplot only shows a a normal probability plot: Could you please find a solution how to make annote workable?   Best regards,   Cornelis   ... View more