About user40

user40 · ‎05-15-2023

No, I don't know.

user40 · ‎05-11-2023

I cannot see that it would work for me. Have you another solution that are more faster?

user40 · ‎05-11-2023

It did not work for me

user40 · ‎05-11-2023

I want to combined two or more time periods into one, contigent upon a) same ID , b) same values of (hours) or other variables indicator if they have. If there is a gap between two periods of more than two days then this should still be two periods. Ses the second row for ID 2 below. Data have: ID Startdate Enddate Hours 1 20230101 20230108 8 1 20230109 20230131 8 1 20230201 20230228 4 2 20230101 20230108 8 2 20230112 20230131 8 2 20230201 20230228 4 Data want: ID Startdate Enddate Hours 1 20230101 20230131 8 1 20230201 20230228 4 2 20230101 20230108 8 2 20230112 20230131 8 2 20230201 20230228 4

user40 · ‎05-11-2023

The solution below is not correct, so there we only delete the row that are extended in regard that sum the duration of ID 1. Can someone explain what the correct solution is?

user40 · ‎05-11-2023

Hello Did do not work. I cannot remove the overlap row in this solution. How can I combined row one and two in this example? this need should only be from 1. januar 2023 until 31. january 2023 with 8 hours service. But if you run this code it would just delete last row. Can anyone check this?

user40 · ‎05-04-2023

Hello. I want to change format in an existing variable that have length $9. but i Need the informat format to be longer than this to include all of the text of the variable name. How can I change informat length for an existing variable in SAS?

user40 · ‎11-10-2022

Hello. Can you give me an example for this?

user40 · ‎11-10-2022

How do I do that?

user40 · ‎11-10-2022

I got this error message on sas: "ERROR: some character data was lost during transcoding in the dataset amis.hddata" what is wrong in my dataset and how can I fix this?

user40 · ‎11-03-2022

variable name of stay is daydiff that are shown in the picture. If there are stays that are overlapping then I want to take out max daydiff of the ID. If there are stays after each other then i need to sum the variable daydiff. In addition, I need to take sum stays when the registered more than one day after each other and take max stays for the other record.

user40 · ‎11-03-2022

for example this example in the picture down here: Here is ID =P000027284 information that I want to take maximum of stay, ID=P005253910 is two registration that I want to have on two rows, sum for the sequence 1 to 3 and max difference on sequence 4. In addition, sum the stay for ID=P000012625., You can see the data that I have on my server over here. I cannot send code. Must I use lag function for seq, tjtildato_refdager and other variables?

user40 · ‎11-03-2022

I want to find out which rows that are the same date in the previous rows and not same date. If all have the same date then i can use the max function to find maximal days of stay, if not the date are equals within the same ID and index_date, then i should take sum of days to find how many days there are in the health service. How can I do that? lag function only use the first rows and check for other rows, but this should stop when ID number changes.

user40 · ‎11-03-2022

Hi I want to check variable for previous rows and asking how to do that. I should check if the previous rows are the same or the information is a new information for the same ID?

user40 · ‎11-02-2022

data test; input lopenummer , indiff, min maks, daydiff ID1, 6495, 6130, 6860, 614 ID2 7739, 7374, 8104, 19 ID3, 9478, 9113, 9843, 85 ID3, 9478, 9113, 9843, 39 ID3, 9478, 9113, 9843, 502; run; proc sql; create table want as select lopenummer, indiff, min , maks, daydiff from test order by lopenummer , indiff; quit; Now then?

Online Status	Offline
Date Last Visited	‎05-15-2023 11:10 AM

Re: how do i collapse data periods given more conditions

Re: how do i collapse data periods given more conditions

Re: how do i collapse data periods given more conditions

how do i collapse data periods given more conditions

Re: How do I collapse date periods, gived some conditions

Re: How do I collapse date periods, gived some conditions

change informat in string variable in sas

Re: Problem to find out an error message in SAS

Re: Problem to find out an error message in SAS

Error message in SAS: "Some character data was lost during transcoding...

Re: how do i collapse data periods given more conditions

Re: how do i collapse data periods given more conditions

Re: how do i collapse data periods given more conditions

how do i collapse data periods given more conditions

Re: How do I collapse date periods, gived some conditions

Re: How do I collapse date periods, gived some conditions

change informat in string variable in sas

Re: Problem to find out an error message in SAS

Re: Problem to find out an error message in SAS

Error message in SAS: "Some character data was lost during transcoding...

Re: How to check variable for other row in sas

Re: How to check variable for other row in sas

Re: How to check variable for other row in sas

How to check variable for other row in sas

Re: Sum variable on different rows within id