topic assign actual order in SAS Programming

assign actual order

thanikondharish — Thu, 06 Sep 2018 14:21:28 GMT

ID	planned	code	type
111	1	SCREEN	SCREENING
111	2	IV	TREATMENT 1
111	3	ORAL	TREATMENT 2
111	4	FOLLOWUP	FOLLOW-UP
112	1	SCREEN	SCREENING
112	2	IV	TREATMENT 1
112	3	ORAL	TREATMENT 2
112	4	FOLLOWUP	FOLLOW-UP

i have data like see above there is a planned order to particular treatment

but actual it doesn't happen so how to assign order like see below data

ID	planned	code	actual	type
111	1	SCREEN	1	SCREENING
111	2	IV	2	TREATMENT 1
111	3	ORAL	3	TREATMENT 2
111	4	FOLLOWUP	4	FOLLOW-UP
112	1	SCREEN	1	SCREENING
112	2	IV	3	TREATMENT 1
112	3	ORAL	2	TREATMENT 2
112	4	FOLLOWUP	4	FOLLOW-UP

Re: assign actual order

RW9 — Thu, 06 Sep 2018 14:31:24 GMT

Post test data in the form of a datastep! AS for your question,there is not enough information. Why should IV be 3 in the second ID and not 2, no information provided as to why. We cannot provide accurate answers if you don't provide the information.

Re: assign actual order

Reeza — Thu, 06 Sep 2018 14:45:33 GMT

How do we (or SAS) know something is out of order?

I would expect to see dates or something in that data set.

@thanikondharish wrote:

ID

planned

code

type

111

1

SCREEN

SCREENING

111

2

IV

TREATMENT 1

111

3

ORAL

TREATMENT 2

111

4

FOLLOWUP

FOLLOW-UP

112

1

SCREEN

SCREENING

112

2

IV

TREATMENT 1

112

3

ORAL

TREATMENT 2

112

4

FOLLOWUP

FOLLOW-UP

i have data like see above there is a planned order to particular treatment

but actual it doesn't happen so how to assign order like see below data

ID

planned

code

actual

type

111

1

SCREEN

1

SCREENING

111

2

IV

2

TREATMENT 1

111

3

ORAL

3

TREATMENT 2

111

4

FOLLOWUP

4

FOLLOW-UP

112

1

SCREEN

1

SCREENING

112

2

IV

3

TREATMENT 1

112

3

ORAL

2

TREATMENT 2

112

4

FOLLOWUP

4

FOLLOW-UP