Identification variable naming scheme: case-control study

mlensing — Mon, 12 Jul 2021 17:55:16 GMT

Hi everyone,

I am working on a case-control study in which I need to create a survey ID variable for records. For every case in dataset1, I pull 3 controls randomly from a source dataset to create dataset2 (this is being done via proc survey select) resulting in a dataset of cases (dataset1) and a dataset of controls (dataset2). The survey ID variable naming scheme should be as follows:

Case1: 12345-1

Control1: 12345-1-1

Control2: 12345-1-2

Control3: 12345-1-3

Case 2: 12345-2

Control1: 12345-2-1

Control2: 12345-2-2

Control3: 12345-2-3

This naming scheme can be applied to each dataset separately or can be applied to the combined dataset of all records. A key detail is that the controls are simply frequency matches and NOT paired matches. How would you all code this?

Thanks!

Re: Identification variable naming scheme: case-control study

PaigeMiller — Mon, 12 Jul 2021 17:58:58 GMT

Keep the data set long, not wide. You don't want separate variables here, you want separate records.

Beyond that, a more concrete explanation of the data, or showing us a portion of what the data set would look like, would be a great help.

topic Re: Identification variable naming scheme: case-control study in SAS Programming

Identification variable naming scheme: case-control study

Re: Identification variable naming scheme: case-control study