topic Re: Sas format questions in Statistical Procedures

Sas format questions

saza — Sat, 29 Jan 2022 07:21:17 GMT

Create a format called YESNO where 1 = “Yes” and 2 = “No” and apply it to all variables in the dataset with that coding.
Create formats for SEX and RACEETHN and apply them to the associated variables.
Create an AGE variable that is patient age at hospitalization.
Categorize the new AGE variable into a variable called AGEGROUP with the following categories:

1 = 0-4

2 = 5-17

3 = 18-49

4 = 50-64

5 = ≥65

Create and apply a format for the new age category variable.
Run a PROC FREQ to describe the number of hospital deaths by age group. Report which group experienced the most deaths over the period of observation.

Re: Sas format questions

PaigeMiller — Sat, 29 Jan 2022 11:21:49 GMT

Show us what you have tried.

Re: Sas format questions

Rick_SAS — Sat, 29 Jan 2022 11:41:37 GMT

Here is a short introduction to using PROC FORMAT to define a format:

"Use PROC FORMAT to recode variables in SAS"

As shown in the article, you use the FORMAT statement to tell that SAS to display a variable's formatted values instead of its raw values.

To "apply" a format to more than one variable, list all the variables after the word FORMAT and then put the name of the format at the end of the line. For example, to apply the YESNO format to four variables, you would use

format HospDeath IntenCare MechVent Asthma YESNO.;

Notice that the FORMAT statement needs to be INSIDE a DATA step or PROC/RUN boundary. It is not a global statement.

Re: Sas format questions

saza — Sat, 29 Jan 2022 19:57:39 GMT

I tried to set 1 and 2 to yes or no In a new dates called "covid" but am getting errors.
data=covid;
set covidk.covid1k;
format 1 $YES;
format 2 $NO;
run;

Re: Sas format questions

PaigeMiller — Sat, 29 Jan 2022 21:10:33 GMT

So, there are plenty of examples out there in the world of correct use of formats. @Rick_SAS has pointed you to some. Here is another example, from the SAS documentation: http://documentation.sas.com/doc/en/pgmmvacdc/9.4/proc/n03qskwoints2an1ispy57plwrn9.htm

See if you can follow any of those examples.

Re: Sas format questions

Rick_SAS — Sat, 29 Jan 2022 21:20:24 GMT

In the article, 5 reasons to use PROC FORMAT to recode variables in SAS - The DO Loop, look for the PROC FORMAT step. That shows how to define a format. For example

proc format;
value YESNO
      0 = "Yes"
      1 = "No" 
      other = " ";
run;

proc freq data=covid1k;
format HospDeath IntenCare MechVent Asthma YESNO.;
tables HospDeath IntenCare MechVent Asthma;
run;

Re: Sas format questions

saza — Mon, 31 Jan 2022 03:49:14 GMT

Thank you for your feedback! I believe I was able to crack the code using your resources:

libname covid1k '/home/u59291263/folder for sas lab';
run;

data=covid;
set covidk.covid1k;
format 1 $YES;
format 2 $NO;
run;

data covid;
set covid1k.covid1k;
format SEX 1= $YES
2= $NO;
run;
data covid;
set covid1k.covid1k;
format RACETHN 1= $YES
2= $NO;
run;

proc format AGE;
value AGEGROUP
1 = "0-4"
2 = "5-17"
3 = "18-49"
4 = "50-64"
5 = "≥65";
run;

proc freq data = covid;
table HospDeath;
format HospDeath AGE.;
run;