Thank you so much @Ksharp !!! This is exactly what I was trying to do!! Thank you once again! ... View more

As Freelance said, another way is here: libname x 'c:\temp\'; options fmtsearch=(x); data x; input x; format x x.; cards; 1 2 ; run; ... View more

Given data like this data have; format id 8. date date9.; informat date date.; input id date; cards; 1 01jan21 1 10jan21 2 5feb21 2 5feb21 ;run; you can use code like this data want; set have; by id; datediff=dif(date); if first.id the datediff=.; run; The code will work if your dates are SAS date values, as shown in the example.   - although I am not quite sure why your example data show the difference to the next record for the first record in each group.   If that is really what you want, it can be done like this: data want; set want; by id; if first.id and not last.id then do; _N_=_N_+1; set want(keep=datediff) point=_N_; end; run;   ... View more

/* You could set "NA" be missing before counting it. */ data have; input ID ( Fruit Color Vehicle ) ($) Year; cards; 1 Apple Blue Car 2001 1 Apple NA Car 2001 2 Banana Red Van 2000 2 Banana Blue Car 2000 ; data have; set have; array x{*} $ _character_; do i=1 to dim(x); if x{i}="NA" then call missing(x{i}); end; drop i; run; proc transpose data=have(obs=0) out=temp; var _all_; run; proc sql noprint; select cat('count(distinct ',_name_,') as ',_name_) into :count separated by ' ,' from temp; create table temp2 as select id as _id,&count. from have group by id; quit; proc transpose data=temp2 out=want(where=(col1 ne 1)); by _id; run; ... View more

Alternative option with hash tables: data have; input ID Fruit : $ Colour : $; cards; 1001 Apple Purple 1 1003 Banana Black 0 1001 Apple Purple 1 1005 Mango Blue 0 1005 Mango Pink 0 1002 Apple Red 0 1006 Cherry Yellow 0 1001 Pear Purple 1 ; run; proc print; run; data want; length F $ 8 ; drop F; declare hash H(); H.defineKey("ID"); H.defineData("F","Flag"); H.defineDone(); do until(EOF1); set have end=EOF1; if 0=H.find() then do; if F NE Fruit then Flag+1; end; else Flag=-1; _N_=H.replace(); end; do until(EOF2); set have end=EOF2; _N_=H.find(); Flag=Flag>0; output; end; stop; run; proc print; run; Bart ... View more

Thank you so much!! This worked !! ... View more

Although the code @Kurt_Bremser has supplied works for the example data provided. You also need to be aware that it ONLY works assuming your input data earliest observation has date="05APR2021"d  If you were to run this code against another dataset that which has a different value earliest value for date, e.g. 01APR2021 then week 1 is going to be 01APR2021- 07APR2021. If you want have consistent behavior where week 1 is always 05APR2021-11APR2021 then you are going to want to remove the PROC SQL step and hard code your starting date (&begin)  INTCK Function data have ; format date date7. ; do i=3 to 100 by 3 ; date="04APR2021"d+i ; output have ; end ; run ; proc sort data=have ; by date ; run ; data want; set have; week=intck("week","05APR2021"d,date,'c') + 1; run; ... View more

Consider this example using INTNX.   Data Original; infile datalines ; Input ID :4. Date :date9.; format date date9.; datalines; 1001 22FEB2021 8997 05APR2021 5654 30SEP2022 3000 07MAR2022 1002 31OCT2021 7984 28FEB2021 ; run; Data Weeks; Retain Date1 0; set original ; if _n_=1 then Date1='21FEB2021'd; /* Use INTNX to count weeks between 21FEB2021 and dates in the table*/ Weeks=intck('week', date1,Date, 'continuous'); format date1 date9.; run; ... View more

I think the problem is with the precedence of operators. AND has higher precedence than OR, just like * has higher precedence than +. So your expression actually evaluates to (port="" and land ^=:"Unknown") or land ^=:"Other" or land ^=:"Rail" You will have to use a parathesis to get what you want: port="" and (land ^=:"Unknown" or land ^=:"Other" or land ^=:"Rail") or use the in: operator, as suggested by @Tom  ... View more

Thank you so much!! This solution worked perfectly! ... View more