topic Re: Patient Demographic Table in SAS Programming

Patient Demographic Table

u49589061 — Wed, 14 Apr 2021 09:12:25 GMT

Hi everyone, I'm struggling to construct the three data tables below and I would really appreciate it if someone could help me. The variables highlighted in yellow are the ones listed in the data set. I also attached the data dictionary to this post.

Re: Patient Demographic Table

japelin — Wed, 14 Apr 2021 09:38:54 GMT

What is raw data?

Re: Patient Demographic Table

u49589061 — Wed, 14 Apr 2021 09:46:48 GMT

I am unable to attach the original data set to this post because the file size is too big. But the variables in the raw data set are highlighted in yellow.

Re: Patient Demographic Table

Kurt_Bremser — Wed, 14 Apr 2021 09:57:44 GMT

From where do you get the data (so we might be able to download an example ourselves)?

In which form do you get it (CSV or other text format, transport file, ...)?

Re: Patient Demographic Table

japelin — Wed, 14 Apr 2021 10:01:45 GMT

Please provide just some observations.

For example, a dataset of 10obs can be created as follows

data sample;
  set have(obs=10);
run;

You can also use datalines to describe the sample data.

Re: Patient Demographic Table

u49589061 — Wed, 14 Apr 2021 10:09:48 GMT

Re: Patient Demographic Table

u49589061 — Wed, 14 Apr 2021 10:24:35 GMT

Please let me know if this works.

Re: Patient Demographic Table

japelin — Wed, 14 Apr 2021 10:25:17 GMT

So what exactly do you want to do with this data?
Are you having trouble importing the data? Or converting it?

If you simply want to extract the variables, you can do that with the following...

data want;
  set have;
  keep AGEATINTERVIEW GENDER MARITALSTATUS;/* and other variables */
run;

Re: Patient Demographic Table

u49589061 — Wed, 14 Apr 2021 10:34:55 GMT

I want to construct the data table in the photo below, but I don't know how to in sas

Re: Patient Demographic Table

Kurt_Bremser — Wed, 14 Apr 2021 10:53:10 GMT

The .dta file is some kind of binary data file. From which application does it originate?

Re: Patient Demographic Table

japelin — Wed, 14 Apr 2021 11:50:36 GMT

@Kurt_Bremser This is probably stata data, which I could import with a simple import procedure.

proc import file="\projectdata020719.dta" out=have;
run;

Re: Patient Demographic Table

u49589061 — Wed, 14 Apr 2021 11:37:08 GMT

I know the basic processing of sas. I just don't know how to put get multiple subcategories in the first row of my table so that I can properly label my observations.

Re: Patient Demographic Table

Kurt_Bremser — Wed, 14 Apr 2021 11:43:36 GMT

The yellow cells in your Excel match the variable names in the dataset, so all you need is a KEEP statement.

If you need more than that, show an example of the "want" dataset(s).

Re: Patient Demographic Table

japelin — Thu, 15 Apr 2021 01:29:47 GMT

I created this sample program thinking that you simply want to divide the data into three data sets.

Can you show me an image of the finished product, even in Excel? (Variable name in the first line, data in the second and subsequent lines)

proc import file=".\projectdata020719.dta"
            out=have;
run;

data DM;
  set have;
  keep seqn ageatinterview gender maritalstatus education householdincome;
run; 

data RF(label='Risk factors and Medical fix');
  set have;
  keep seqn SMOKENOW EVERSMK100CIGS HICHOL_HX;
;
run; 
data CP(label='Clinical presentation');
  set have;
  keep seqn BPXSAR BMI MORTSTAT DIABETES_HX LIVER_HX THYROID_HX AVE_DAILY_PA;
  where AVE_DAILY_PA=1;
run;