topic Re: I want the original data and a format version in SAS Programming

I want the original data and a format version

Kman1234 — Wed, 01 Apr 2020 13:14:04 GMT

I have run the following code below to make gender display male and female and if its 1 display yes and 0 = no

what i want to do is in one table add a extra column that would display the original value of the formatted data.Every time i try adding the coloumn

OrgGender and OrgMarried it gives me error messages.

PROC FORMAT;
VALUE FMTMARRIED 0="No"
1="Yes";
VALUE $FMTGENDER "F" = "Female"
"M" = "Male";
RUN;
PROC PRINT DATA="/folders/myfolders/CourseWork/SURVEY";
VAR SUBJECT MARRIED GENDER;
FORMAT MARRIED FMTMARRIED. GENDER $FMTGENDER.;
RUN;

Re: I want the original data and a format version

PaigeMiller — Wed, 01 Apr 2020 13:20:52 GMT

@Kman1234 wrote:

I have run the following code below to make gender display male and female and if its 1 display yes and 0 = no

what i want to do is in one table add a extra column that would display the original value of the formatted data.Every time i try adding the coloumn

OrgGender and OrgMarried it gives me error messages.

You want to add this extra column in the data set, or in PROC PRINT? I think it has to be done in the data set, and then you can PROC PRINT it.

Re: I want the original data and a format version

Kman1234 — Wed, 01 Apr 2020 13:21:54 GMT

So i can not add to columns as i create the proc print?

Re: I want the original data and a format version

Kurt_Bremser — Wed, 01 Apr 2020 13:24:17 GMT

PROC REPORT is more flexible; you can define an alias for a variable and use this without the format.

Re: I want the original data and a format version

PaigeMiller — Wed, 01 Apr 2020 13:28:13 GMT

@Kman1234 wrote:
So i can not add to columns as i create the proc print?

Correct. @Kurt_Bremser correctly points out that PROC REPORT will allow this without first creating a new column in the data set.