Hello   I need to translate this STATA code into SAS: bys cpr protokol (dt_registrering): gen index1 = _n if year(dt_vurdering)< $year   A subset of my dataset looks like this:   cpr       protokol      dt_registration        dt_assesment 100      fys               05feb2016             21jan2016 100      fys               27apr2017             17jan2017 100      fys               27apr2018             17jan2018 100      ergo            23feb2016              10jan2016 100      ergo            19jan2017               5jan2017 100      ergo            19jan2018               5jan2018 200     fys                23feb2016              10jan2016 200     fys                24apr2017              15jan2017 200     ergo             19mar2016              7jan2016 200     ergo             20mar2017               12jan2017   I want to make  a new variable that counts the number of assesments before year 2018 group by CPR and Protokol.   Something like this:   cpr       protokol      dt_registration        dt_assesment   index1 100      fys               05feb2016             21jan2016          1 100      fys               27apr2017             17jan2017          2 100      fys               27apr2018             17jan2018          . 100      ergo            23feb2016              10jan2016         1 100      ergo            19jan2017               5jan2017           2 100      ergo            19jan2018               5jan2018           . 200     fys                23feb2016              10jan2016         1 200     fys                24apr2017              15jan2017         2 200     ergo             19mar2016              7jan2016          1 200     ergo             20mar2017               12jan2017        2   Thank you   Kind regards Frank       ... View more

Hello   One simple question.   I want to calculate the sum of a variable in my long formatet dataset.     My dataset looks like this:   ID        gmfcs_dummy   1000    0 1000    1 1000    1 2000    0 2000    0 2000    0 3000    1 3000    1 3000    1   I want to calculate the sum of gmfcs_dummy so it sums up in rising order like this:   ID         gmfcs_dummy   gmfcs_dummy2 1000            1                       1 1000            1                       2 2000            0                       0 2000            0                       0 2000            0                       0 3000           1                        1 3000           1                        2 3000           1                        3   How can I do this?   Kind regards Frank ... View more

Hello   I have two datasets. Lets call them dataset1 and dataset2.   I want to create a third dataset who contains records not in both dataset based on my keyvar.   Thank you!   Kind regards Frank ... View more

Hi   I have a char var called "cpr". My problem is when i transforms it into a numeric variable it is dropping the the start number 0 for those obs who starts with zero and returns a 9 digit num var.   CPR = 0101079010   data want; set have; cpr2 = input(CPR,best12.); run;   returned value of cpr2 = 101079010.   I want that to look like the same CPR var with 10 digits but as a num var instead of a char.   Kind regards Frank ... View more

Hallo once again   I have an ID variable called “CPR” which must be 10 characters long.  Its a char var with numbers.    I want to drop those observations who doesn’t meet this criteria.    My code look like this:    date have;  set want;  if lengthn(cpr) <10 then drop; run;    can anyone help ?   kind regards Frank  ... View more

Hello   I'm new to SAS !   I have a 6 digit string variable which describes a date period e.g. 010111 equal too 01jan2011. My dataset also includes dates from the 20 century e.g. 010199 equal to 01jan1999.   How do I first of all convert my string variable into a sas date?   And how do I deal with the two digit year so I dont ends up with a year that looks like 2090?   Kind regards Frank         ... View more

Hallo   I'm dealing with a problem I hope you guys can help me with. I have a date var which is located as a character variable.   Date = '2010-07-12 12:20:51' I want to convert it into a sas date with time registrated. Probably on the format datetime16.   How can I do that?   Thanks for the help.   Kind regard Frank. ... View more