Hi, I would like to calculate difference between START - END for each name. Assuming: table is already sorted by name date, START is always first, has to be at least one START per name but always there is a sequence START END START..   Table have like this: DATA HAVE; LENGTH name $10. var1 $5.; INPUT name $ date :date9. var1 $; format date date9. ; DATALINES; aaa 10JUN2020 START aaa 15JUN2020 END bbb 10JUL2020 START bbb 20JUL2020 END bbb 25JUL2020 START bbb 01SEP2020 END ccc 20JUN2020 START ddd 15JUL2020 START ddd 30JUL2020 END ddd 02SEP2020 START ; RUN; want like this: I know how to do it within the group but got lost with START END piece   Huge thanks in advance ... View more

Hi, I have a table which variable names are created by macros as per example. %LET VAR1 = JAN07; %LET VAR2 = JAN06; DATA HAVE; INPUT NAME $ &var1 &var2; DATALINES; aaaaa 100 50 bbbbb 110 60 ccccc 20 15 ddddd 300 290 eeeee 80 79 fffff 115 130 ; RUN; How can I conditionally output from this? I have tried like this but seems like I'm missing something: %MACRO MAC(); data WANT; SET HAVE; %IF &var2 LT 100 AND %SYSFUNC(abs(%EVAL(&VAR2 - &VAR1))) GE 5 %then %DO; output ; %END; %else %if &var2 GE 100 AND (%SYSFUNC(abs(%EVAL(&VAR2 - &VAR1))))/&VAR2 GE 0.05 %then %DO; output; %END; run; %MEND MAC; %MAC() ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was: JAN06 - JAN07 ERROR: The function ABS referenced by the %SYSFUNC or %QSYSFUNC macro function has too few arguments. ERROR: The macro MAC will stop executing.     ... View more

Hi, I am looking for a nicer way how to save date in the format MONDD. (like DEC29). I don't see this format build in and currently I am using concatenation of monname3. and day2. Is there a simplier way for that for example by creating a bespoke format? Thank you in advance, Cheers ... View more

Hi, Could you please help me to rearrange the build of this table? It can have from 0 rows to anything but hardly this will be the case of more than 20. I am already using macro variable &noobs_have elsewhere. I want the table to be like on the pic below   data have; input day : $9. Date : $16. delta; cards; 22OCT2020 22OCT20:15:19:10 0 22OCT2020 22OCT20:15:25:20 370 23OCT2020 23OCT20:00:19:54 2 23OCT2020 23OCT20:00:20:02 8 ; run; data _NULL_; if 0 then set have nobs=n; call symputx('noobs_have',n); stop; run;       Thank you in advance for any help   Cheers ... View more

Hi, I have data delimited with a comma, where dates are formatted in 23/06/2020 format. I want to add them to a sas table. Below is an example, could you please guide how should I do it to have the column 'date' formatted as date? it can be either ddmmyys10. or date9.   DATA want; LENGTH character $60. ; INFILE DATALINES DLM=','; INPUT character $ date ddmmyys10.; DATALINES; aaa,20/06/2020 b bb,21/06/2020 cc c,22/06/2020 ; RUN; ... View more

Hi, Just wondering if there is any better way of having kind of custom group order that the code below. I have format: proc format ; value valband 0 = '0' 0<-30 = '0-30' 30<-90 = '30-90' 90<-215 = '90-215' 215<-430= '215-430' 430-high = 'over 430'; run ; But when I do group by in proc sql I see the order: 0 0-30 215-430 30-90 etc. obviously I would like to have it ordered by value. I found a solution with additional ranking created by case when, is this the only/easiest way of doing this? order by case when val_bin = '0' then 1 when val_bin = '0-30' then 2 when val_bin = '30-90' then 3 when val_bin = '90-215' then 4 when val_bin = '215-430' then 5 when val_bin = 'over 430' then 6 end ... View more

Hi, I am new to SAS programming, is there an easy way how can I rearrange the table below to get the build shown on the right? ... View more