topic Re: Date Formatting in SAS Programming

Date Formatting

malikah_sph — Fri, 08 Jul 2016 19:07:27 GMT

I need to format dates from the format of 15 Mar 2000 to the format of 03-15-2000 instead. I have tried the following code thus far:

data agemod;
set Tmp1;
rename Please_enter_your_date_of_birth_ = dob;
format dob yymmdd10.;
informat dob yymmdd10.;
run;

However it is not working. Can anyone provide assistance?

Re: Date Formatting

ballardw — Fri, 08 Jul 2016 19:16:06 GMT

Run proc contents on the TMP1 dataset or look at the column view in the SAS Explorer window to determine it's typle. It is very likely that the variable is actually text (character).

If that is the case then this should work:

data agemod;
   set Tmp1;
   dob= input( Please_enter_your_date_of_birth_,anydtdte32.);
   format dob yymmdd10.;
   drop Please_enter_your_date_of_birth_;
run;

Re: Date Formatting

malikah_sph — Fri, 08 Jul 2016 19:24:19 GMT

Thank you for your help but the code is still not working :(. I have run proc contents and dob actually comes up as numeric so that's not the problem.

Re: Date Formatting

jklaverstijn — Fri, 08 Jul 2016 19:29:58 GMT

it will help if you provide a sample of your data, the proc comtents output from before and the log of your attempts. Snd what are your current unexpected results?

- Jan.

Re: Date Formatting

ballardw — Fri, 08 Jul 2016 19:40:37 GMT

Describe "Not working": NO results, unexpected results (give example of actual results and desired), errors (include with code and errors)

Re: Date Formatting

malikah_sph — Fri, 08 Jul 2016 19:43:35 GMT

There were no errors in the log but when I look at the data set, the column dob is empty. It just has dots and no actual data.

Re: Date Formatting

ballardw — Fri, 08 Jul 2016 19:57:40 GMT

Run proc contents on your TMP1 data set and post the result here.

It may not here to Proc Print a few rows from TMP1 if you can share the data here:

Proc print data=tmp1 (obs=10);

run;

should print the first 10 rows.

Re: Date Formatting

malikah_sph — Fri, 08 Jul 2016 20:06:08 GMT

Here is a data sample:

SAS Output

Obs Record_ID Agreement_to_participate_____By_ Today_s_date_ I_agree_to_allow_my_contact_info inst inst1 inst2 inst3 inst4 inst5 inst6 inst7 inst8 inst9 inst10 inst11 inst12 inst13 inst14 inst15 inst16 inst17 inst18 inst19 inst20 inst21 inst22 inst23 inst24 inst25 inst26 inst27 inst28 inst29 inst30 inst31 inst32 inst33 New_Subject_ID What_is_your_sex_ What_sex_were_you_assigned_at_bi How_do_you_describe_yourself_ Have_you_undergone_treatment_for What_type_of_sex_reassignment_tr Did_you_begin_sex_reassignment_t Please_enter_your_date_of_birth_ Are_you_of_Hispanic_Latino_desce Please_select_one_or_more_catego Please_select_one_or_more_categ0 Please_select_one_or_more_categ1 Please_select_one_or_more_categ2 Please_select_one_or_more_categ3 Please_select_one_or_more_categ4 Select_the_highest_level_of_scho Select_your_total_HOUSEHOLD_inco Please_select_your_current_marit Please_select_your_current_emplo In_which_state_do_you_live_ Please_select_the_type_of_cancer When_you_were_diagnosed_with_bre When_were_you_diagnosed_with_thi What_type_of_treatment_s__have_y What_type_of_treatment_s__have_0 What_type_of_treatment_s__have_1 What_type_of_treatment_s__have_2 What_type_of_treatment_s__have_3 What_other_treatment_s__did_you_ Have_you_received_or_will_you_be Pain Fatigue Sleep_disturbance Memory_and_concentration Nausea_vomiting Poor_appetite Trouble_swallowing Dental_or_mouth_problems Weight_changes Balance_walking_mobility Loss_of_strength Tingling_or_numbness_in_feet___h Swelling_in_legs_or_arms__lymphe Osteoporosis_bone_health Hair_and_skin_issues Body_changes Bowel_or_bladder_changes Hot_flashes Sexual_issues Fertility_issues Managing_household_activities Caring_for_family_members Talking_about_cancer_with_family Returning_to_work Health_insurance Financial_concerns Debt_from_medical_bills Defining_a_new_sense_of_normal Managing_difficult_emotions__ang Coping_with_grief_and_loss Living_with_uncertainty Fear_of_recurrence Managing_stress Isolation_feeling_alone Intimacy_issues Looking_for_the_bright_side__gra Having_a_sense_of_well_being Changing_relationship_with_spous Finding_support_services Connecting_to_counseling_service Genetic_counseling__worry_about_ How_confident_are_you_that_you_c How_confident_are_you_that_you_0 How_confident_are_you_that_you_1 How_confident_are_you_that_you_2 How_confident_are_you_that_you_3 How_confident_are_you_that_you_4 How_confident_are_you_that_you_5 How_confident_are_you_that_you_6 Primary_care Oncology Other_specialties Mental_health Hospital_inpatient Hospital_outpatient Hospital_emergency_room Urgent_care Other__please_specify_ What_other_provider_or_places_of There_are_many_reasons_people_de There_are_many_reasons_people_d0 There_are_many_reasons_people_d1 There_are_many_reasons_people_d2 There_are_many_reasons_people_d3 There_are_many_reasons_people_d4 There_are_many_reasons_people_d5 There_are_many_reasons_people_d6 There_are_many_reasons_people_d7 There_are_many_reasons_people_d8 There_are_many_reasons_people_d9 There_are_many_reasons_people_10 There_are_many_reasons_people_11 There_are_many_reasons_people_12 There_are_many_reasons_people_13 There_are_many_reasons_people_14 There_are_many_reasons_people_15 What_is_the_other_reason_you_del Complete_ instn mod instc 1 2 3 4 5 6 7 8 9

1044

Yes

22APR2016

Yes

Wenatchee Valley (Confluence)

Katherine Kemble, DNP, FNP-C, AOCNP, ARNP

Male

06OCT1945

Checked

Unchecked

4-year college graduate

$75,000 to $99,999

Married

Retired

Prostate

Don't know

13OCT2016

Checked

Unchecked

Checked

Unchecked

No, I have not or will not be receiving hormone therapy for this cancer.

0 No Concerns

5 Extreme Concerns

0 No Concerns

0 (no concerns)

5 (extreme concerns)

None

2-3 times

None

1 time

None

Unchecked

Checked

Unchecked

Complete

1043

Yes

11MAY2016

Yes

Canton Mercy Medical Center

Joan Edwards, RN, OCN

Male

25DEC1954

Checked

Unchecked

High school graduate or GED

Less than $25,000

Divorced

Not working

Colorectal (including **bleep**)

Don't know

15JUL2016

Unchecked

Checked

Unchecked

No, I have not or will not be receiving hormone therapy for this cancer.

0 No Concerns

0 (no concerns)

5 (extreme concerns)

0 (no concerns)

2-3 times

Checked

Unchecked

Complete

1042

Yes

05MAY2016

Yes

Canton Mercy Medical Center

Jane Westfall, RN, BSN, OSN

Female

07AUG1975

Checked

Unchecked

Some college or 2-year degree

$100,000 or more

Married

Working- as a paid employee

Breast

Stage 0

15NOV2016

Checked

Unchecked

Checked

Tamoxifen

Yes, I am receiving hormone therapy.

0 No Concerns

0 (no concerns)

5 Totally confident

None

2-3 times

8 or more times

None

1 time

None

Checked

Unchecked

Complete

1041

Yes

02MAY2016

Yes

New England Cancer Specialists

Dixie Knoll, FNP

Female

17JUL1972

Checked

Unchecked

Some college or 2-year degree

$25,000 to $49,999

Divorced

Working- as a paid employee

Breast

Stage 1

15MAY2016

Checked

Unchecked

Checked

Unchecked

Yes, I am receiving hormone therapy.

0 No Concerns

5 Extreme Concerns

0 No Concerns

0 (no concerns)

5 (extreme concerns)

0 (no concerns)

5 Totally confident

None

6-7 times

None

Checked

Unchecked

Complete

1040

Yes

03MAY2016

Yes

New England Cancer Specialists

Dixie Knoll, FNP

Female

04OCT1984

Checked

Unchecked

High school graduate or GED

Don't know

Married

Working- as a paid employee

Breast

Stage 2

15JUN2016

Checked

Unchecked

No, I have not or will not be receiving hormone therapy for this cancer.

0 No Concerns

0 (no concerns)

None

1 time

None

Checked

Unchecked

Complete

1039

Yes

26APR2016

Yes

Canton Mercy Medical Center

Jane Westfall, RN, BSN, OSN

Female

14JUN1942

Checked

Unchecked

High school graduate or GED

Less than $25,000

Divorced

Retired

Breast

Stage 1

15JUL2016

Checked

Unchecked

Yes, I am receiving hormone therapy.

0 No Concerns

0 (no concerns)

5 Totally confident

None

2-3 times

None

Checked

Unchecked

Complete

1038

Yes

26APR2016

Yes

Essentia Institute of Rural Health

Jessica Nybakken, CNP

Female

19OCT1945

Checked

Unchecked

Some college or 2-year degree

Don't know

Married

Retired

Breast

Stage 1

15AUG2016

Checked

Unchecked

Checked

Unchecked

Yes, I completed hormone therapy.

0 No Concerns

0 (no concerns)

5 Totally confident

None

2-3 times

None

Unchecked

Complete

1037

Yes

26APR2016

Yes

Essentia Institute of Rural Health

Jessica Nybakken, CNP

Female

05AUG1944

Checked

Unchecked

Some college or 2-year degree

Less than $25,000

Widowed

Retired

Breast

Stage 1

15OCT2016

Checked

Unchecked

Checked

Unchecked

Yes, I am receiving hormone therapy.

0 No Concerns

0 (no concerns)

5 Totally confident

1 time

2-3 times

None

2-3 times

Surgeon

Checked

Unchecked

Complete

1036

Yes

26APR2016

Yes

Canton Mercy Medical Center

Jane Westfall, RN, BSN, OSN

Female

14JAN1981

Checked

Unchecked

Some college or 2-year degree

$100,000 or more

Married

Working- as a paid employee

Breast

Stage 2

15MAY2016

Checked

Unchecked

Yes, I am receiving hormone therapy.

0 No Concerns

0 (no concerns)

5 Totally confident

None

1 time

None

Checked

Unchecked

Complete

Re: Date Formatting

ballardw — Fri, 08 Jul 2016 20:33:57 GMT

And proc contents? Still betting that the date is actually a character variable.

By the way, you may want to rethink how you are reading the source data. That looks like proc import results from (likely) Excel.

The variables with names like There_are_many_reasons_people_d0 give that away.

Re: Date Formatting

Astounding — Fri, 08 Jul 2016 22:50:50 GMT

If that's not working, I would try:

dob = input(compress(Please_Enter_Your_Date_of_Birth), date9.);

Also, the format that matches your original request would be:

format dob mmddyyd10.;

Re: Date Formatting

Tom — Sat, 09 Jul 2016 01:59:01 GMT

Your posted code should not work at all as you cannot have two variables both named DOB. When you use a RENAME statement the variable does not have the new name until it is written. Within the current data step you need to keep using the current name of the variable.

If you want to apply a new FORMAT to an existing variable ( Please_enter_your_date_of_birth_ ) and also rename it to DOB then your code should look like this.

data agemod;
  set Tmp1;
  rename Please_enter_your_date_of_birth_ = dob;
  format Please_enter_your_date_of_birth_ yymmdd10.;
run;