About terjeph

terjeph · ‎05-09-2023

This was an important comment. In fact I'm interested in situastions were there are gaps between the periods, like in row 4 and 5. How is this implemented in the code you suggested?

terjeph · ‎05-09-2023

I actually do care about gaps between the dates so record 4 and 5 should not collaps. Any suggestions?

terjeph · ‎05-03-2023

Thanks! Worked perfectly.

terjeph · ‎05-02-2023

I want to combine two or more time periods into one, contingent upon a) same ID and b) same value on another variable (hours). Data have: ID Start End Hours 1 20230101 20230108 8 1 20230109 20230131 8 1 20230201 20230228 4 2 20230101 20230108 8 2 20230110 20230131 8 2 20230201 20230228 4 Data want: ID Start End Hours 1 20230101 20230131 8 1 20230201 20230228 4 2 20230101 20230108 8 2 20230110 20230131 8 2 20230201 20230228 4

terjeph · ‎04-20-2021

This should work: DATA HAVE; INPUT Id Startdate Enddate DDMMYY8.; DATALINES; 1 15021994 06111994 2 15021995 31121995 2 01051996 . ;

terjeph · ‎04-20-2021

Delete the n before 8

terjeph · ‎04-20-2021

Please check now

terjeph · ‎04-19-2021

DATA HAVE; INPUT Id Startdate DDMMYY8. Enddate DDMMYY8.; DATALINES; 1 15021994 06111994 2 15021995 31121995 2 01051996 . ;

terjeph · ‎04-19-2021

I want to create a panel data based on a cross section data set and fill in observations per quarter. A variable called Present needs to be created. Present = 1 for the interval between (and included) Startdate and (included) Enddate, 0 otherwise. The observation period starts 1 Jan 1994 and ends 31 Dec 1996. The missing value in dataline 3 indicate that the state is still ongoing (truncation). DATA HAVE; INPUT Id Startdate DDMMYYYY8. Enddate DDMMYYYY8.; DATALINES; 1 15021994 06111994 2 15021995 31121995 2 01051996 . ; DATA WANT; ID yearqarter PRESENT 1 1994Q1 1 1 1994Q2 1 1 1994Q3 1 1 1994Q4 0 1 1995Q1 0 1 1995Q2 0 1 1995Q3 0 1 1995Q4 0 1 1996Q1 0 1 1996Q2 0 1 1996Q3 0 1 1996Q4 0 2 1994Q1 0 2 1994Q2 0 2 1994Q3 0 2 1994Q4 0 2 1995Q1 1 2 1995Q2 1 2 1995Q3 1 2 1995Q4 1 2 1996Q1 0 2 1996Q2 1 2 1996Q3 1 2 1996Q4 1

terjeph · ‎04-19-2021

I want to create a panel data based on a cross section data set and fill in observations per quarter. A variable Present needs to be created. Presents=1 if in the interval between Startdate and Enddate, 0 otherwise. The observation period starts 1 Jan 1994 and end 31 Dec 2015. Have: Id Startdate Enddate 1 15021994 06111994 2 15021995 31121995 2 01011996 3 01041998 01111998 Want: Id YYQ Present 1 1994Q1 1 1 1994Q2 1 1 1994Q3 1 1 1994Q4 0 1 1995Q1 0 1 1995Q2 0 and so on until 2015Q4 2 1994Q1 0 2 1994Q2 0 2 1994Q3 0 2 1994Q4 0 2 1995Q1 1 2 1995Q2 1 2 1995Q3 1 2 1995Q4 1 2 1996Q1 0 2 1996Q2 0 2 1996Q3 0 2 1996Q4 1 2 1997Q1 1 and so on until 2015Q4

terjeph · ‎04-05-2017

Thanks!

terjeph · ‎04-05-2017

Hi, I'd like to count the number of a specific value ('4') per individual in the second digit of a character variable (one per day) and store the count (new variable). The data set: pid date1 date2 date3 ... 1 142 121 141 2 111 12B 121 3 141 14A 121 Anyone?

terjeph · ‎01-05-2017

Thanks! worked well.

terjeph · ‎01-05-2017

I've got dates describing periodes (start end) and a variable describing waiting time (wt). However, the dates are partialle overlapping. This is nearly fixed in the attached program but I would like to have latest observation of wt to be placed in correctly. Anyone?

terjeph · ‎01-04-2017

Thanks! Worked well!

Online Status	Offline
Date Last Visited	‎06-06-2025 02:49 AM

Re: How do I select the last valid column from a data set

How do I select the last valid column from a data set

Re: Merging: How di I keep by-variables from both files

Re: Merging: How di I keep by-variables from both files

Merging: How di I keep by-variables from both files

Re: How do I transpose, fill in and maximize

How do I transpose, fill in and maximize

Re: Transpose and fill in

Transpose and fill in

Re: How to collapse time intervals contingent upon some arguments

Re: Count across variables (substring)

Re: overlapping date observations

Re: overlapping date observations

Re: Filling the missing dates in column

Re: How do I combine several time intervals into one?

Re: How do I combine several time intervals into one?

Re: How do I combine several time intervals into one?

How do I combine several time intervals into one?

Re: How do I create panel data from cross section and fill in

Re: How do I create panel data from cross section and fill in

Re: How do I create panel data from cross section and fill in

Re: How do I create panel data from cross section and fill in

Re: How do I create panel data from cross section and fill in

How do I create panel data from cross section and fill in

Re: Count across variables (substring)

Count across variables (substring)

Re: overlapping date observations

overlapping date observations

Re: Filling the missing dates in column