Use the prefix= option in Proc Transpose like this   data have; input ID $ Location $; datalines; 101 UK 101 France 101 Other 102 UK 102 Spain 103 Other 104 UK 104 Other 105 Other ; proc transpose data = have out = temp(drop = _:) prefix = m_; by ID; id Location; var Location; run; data want; set temp; array a m_:; count = 0; do over a; a = ifc(a ne '', 'Y', a); if a = 'Y' then count + 1; end; run; ... View more

Try this   data have; input ID Location $; datalines; 101 UK 101 France 101 Other 102 UK 102 Spain 103 Other 104 UK 104 Other 105 Other ; proc transpose data = have out = temp(drop = _:); by ID; id Location; var Location; run; data want; set temp; array a _character_; count = 0; do over a; a = ifc(a ne '', 'Y', a); if a = 'Y' then count + 1; end; run; ... View more

"It is possible to have more than 10 rows of such a record with unique "END_NUM" value for the same POLICE_ID and POLICE_YEAR."   I don't understand this. Please provide sample data that resembles your request.   Why is POLICE_EXP = 14-APR-24 in the second obs ? ... View more

It doesn't exist out-the-box, but you can roll out your own using Proc Format   proc format; picture dtfmt other = '%m_%D_%Y' (datatype=date); run; %let runDate=%sysfunc(putn(%sysfunc(date()), dtfmt.)); %put &=runDate.; ... View more

Because nr_Numeric_Missing_Values itself is initialized as a numeric variable. Therefore, it is captured by the _NUMERIC_ list. The calculation of the number of missing values in the NMISS Function occurs before the value is assigned to the variable. Therefore, you get a result +1 of what you expect in each observation.    This gives you the result you want   data my_data; input team $ points assists rebounds; cards; A 10 2 . A 17 5 . A 17 . . A 18 3 4 A 15 0 5 B . 4 5 B 29 0 8 B . 2 9 C 12 1 9 . 30 1 . ; run; data want; set my_data; nr_Numeric_Missing_Values = nmiss(points, assists, rebounds); Run; ... View more

What is the error message? What does &statelist contain? ... View more

Can basket contain other strings than Product1, Product2 and Product3? ... View more

Try this   data want; set have; by CustID; if first.CustID then serial = 1; if Ind then serial + 1; run; ... View more

I edited the DB1 data a bit. I assume you want Visit_date to have the date9 format (not Visit).    Here is how I interpret your logic: For each observation in DB you want to evaluate each Visit_date in DB1 . If Visit_date is within the range of Range1 and Range2 for any observation in DB1, set Visit = 1. If not, set Visit = 0.   data DB; input ID :$20. Admission :date09. Discharge :date09. Range1 :date09. Range2 :date09.; format Admission date9. Discharge date9. Range1 date9. Range2 date9.; cards; 0001 13JAN2017 25JAN2017 30DEC2016 24FEB2017 0001 22FEB2017 07MAR2017 08FEB2017 06APR2017 0001 27APR2017 16MAY2017 13APR2017 15JUN2017 0001 30JAN2019 04MAR2019 16JAN2019 03APR2019 0002 28DEC2014 03JAN2015 14DEC2014 02FEB2015 0002 03MAR2015 12MAR2015 20FEB2015 02APR2015 ; data DB1; input ID :$20. Visit_date :date09.; format Visit_date date09.; cards; 0001 26JAN2017 0001 10FEB2017 0002 22FEB2015 ; data DB2(drop = Visit_date); if _N_ = 1 then do; dcl hash h(dataset : 'DB1', multidata : 'Y'); h.definekey('ID'); h.definedata('Visit_date'); h.definedone(); end; set DB; Visit_date = .; Visit = 0; do while (h.do_over() = 0); if Range1 <= Visit_date <= Range2 then Visit = 1; end; run;   Result:   ID Admission Discharge Range1 Range2 Visit 0001 13JAN2017 25JAN2017 30DEC2016 24FEB2017 1 0001 22FEB2017 07MAR2017 08FEB2017 06APR2017 1 0001 27APR2017 16MAY2017 13APR2017 15JUN2017 0 0001 30JAN2019 04MAR2019 16JAN2019 03APR2019 0 0002 28DEC2014 03JAN2015 14DEC2014 02FEB2015 0 0002 03MAR2015 12MAR2015 20FEB2015 02APR2015 1   ... View more

How long can str be and how large can N be? ... View more