Have a dataset with a quarter variable like below: Quarter 202009 202003 202003 202006 Is there a way to convert this to a date? Ideally something like ddmmmyy Thanks ... View more

Hi, Is there a better way to concatenate all these variables that starting with a variable name var and a value attached?   Eg. var1 var2 var3 var4 var5   This is what I got now, but would pick up variables like var_ which not needed. var_conc= catx(',', of var:);   Thanks   ... View more

Hi - is there a way to group observations together, i.e. if fruit is variable and i want to group apple and orange as Group 1 to show in output report?   This is what I got now:   Example of data: Fruit Apple Orange Grapes Banana   proc report data=final; columns fruit n; define fruit/group; define n /'Count'; rbreak after / summarize; run;     ... View more

Current codes run fine but multiple rows appear. May be due to the brackets. proc sql ; create table Want as select t1.*,t2.ADATE from t1 left join t2 on (t1.userid = t2.userid) and (datepart(t2.ADATE) <= t1.BDATE) and ((t2.XDATE is null or datepart(t2.XDATE) > t1.BDATE)); quit; Thanks ... View more

Trying to create the table below, i.e. adding another condition in the codes where if there is same Event_date then only Count_done as 1.   PROC SQL; Create Table want1 as select want.*, source.result_date, case when standard_days ge result_date and Event_date le result_date then '1' else '0' end as Count_done from want left join source on want.ID = source.ID; Quit;   Current code produces this: ID Event_date Count_done 123456 17/07/2018 1 123456 17/07/2018 1 234567 12/07/2018 1   This is what I want: ID Event_date Count_done 123456 17/07/2018 1 123456 17/07/2018 0 234567 12/07/2018 1   Thanks in advance  ... View more