I need a quick help. Wish to generate a variable as sequence number by ID but with a condition (variable named difference is greater than 10 and by id and sequence of the date)  Thank you so much!   data have; input ID$ DATE$ DIFFERENCE$; datalines; A 4/22/19 . A 4/24/19 2 A 4/25/19 1 A 5/6/19 11 A 5/17/19 11 A 5/22/19 5 B 2/4/20 . B 2/12/20 8 B 3/4/20 21 B 3/10/20 6 RUN;   Data Wish something like below (i.e. create a variable named list which is a sequence number by ID but with the condition that the variable difference greater than 10 and by id's date order)   ID DATE difference list A 4/22/19 . . A 4/24/19 2 . A 4/25/19 1 . A 5/6/19 11 1 A 5/17/19 11 2 A 5/22/19 5 . B 2/4/20 . . B 2/12/20 8 . B 3/4/20 21 1 B 3/10/20 6 . ... View more

Hi Sas Users, I need a quick advice. How should I use the SAS code to replace the value of gender2 to gender variable if the information in gender variable is missing. Thank you! data have; format id $1. gender $1. gender2 $1.; input @1 ID @ 3 GENDER @ 6 GENDER2; DATALINES; 1 f . 2 . m 3 m . 4 . f ; run; ... View more

Hello SAS experts, I encountered 3 quick questions regarding distance/travel time  between two zip codes.   1. zipcitydistance is helpful to calculate the distances between two groups easily. However, I didn't find the code that could give me the travel time. Is there a convenient way to calculate the travel time between two zip codes?   2. Is there a limit sample to calculate the distance of two zip codes?  I got some error like below when running big datasets. WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed. NOTE: The DATA step has been abnormally terminated. NOTE: Mathematical operations could not be performed at the following places. The results of the operations have been set to missing values.   3.  Why the results of the distance is different than I put the zip code in other website individually?    data have; input HQ_ZIP AFF_ZIP; datalines; 10001 90001 98101 32789 ; run; data want; set have; distance = zipcitydistance(HQ_ZIP, AFF_ZIP); run;   You can see the distance between zip 10001 and zip 9001 is 2454.1. But if I put those zip codes to  this website, https://www.zipcodesoft.com/distance-between-zip-codes I got something like close to 2448.   I don't know which to follow. Is there a simple way to calculate road distance of the two zip codes? Many thanks!   ... View more

Hello SAS experts,  I have already asked a similar question previously. My previous question is how to fill in missing year and create a dummy=0 by id. But if I would like to add one more criteria: for those who only have 1 record id, giving the number variable as "zero" if it didn't have any following record until the observed year.   For example, id=d, it only has 2016 record. I would like to have it has dummy variable until the end of the observed year (2020). Can anyone give me a hand? Many thanks in advance.      DATA HAVE; INPUT YEAR ID $ NUMBER; CARDS; 2017 a 1 2018 a 1 2020 a 1 2016 b 1 2020 b 1 2018 c 1 2020 c 1 2016 d 1 2018 e 1 ; RUN;   I wish my final data look like below. Many thanks for the advice in advance!   2017    a    1 2018    a    1 2019    a    0 2020    a    1 2016    b    1 2017    b    0 2018    b    0 2019    b    0 2020    b    1 2018    c    1 2019    c    0 2020    c    1 2016    d    1 2017    d    0 2018    d    0 2019   d    0  2020  d     0 2018   e   1 2019   e   0 2019   e   0 2020  e    0    ... View more