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?
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;
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.
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.
Describe "Not working": NO results, unexpected results (give example of actual results and desired), errors (include with code and errors)
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.
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.
Here is a data sample:
SAS Output
1044 | Yes | 22APR2016 | Yes | Wenatchee Valley (Confluence) | Katherine Kemble, DNP, FNP-C, AOCNP, ARNP | Male | 06OCT1945 | No | Checked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | 4-year college graduate | $75,000 to $99,999 | Married | Retired | Prostate | Don't know | 13OCT2016 | Checked | Unchecked | Checked | Unchecked | Unchecked | No, I have not or will not be receiving hormone therapy for this cancer. | 1 | 4 | . | 4 | 0 No Concerns | 0 No Concerns | 1 | 2 | 5 Extreme Concerns | 2 | 2 | 4 | 3 | 3 | 4 | 4 | 5 Extreme Concerns | 2 | 3 | 0 No Concerns | 2 | 3 | 0 (no concerns) | 0 (no concerns) | 4 | 1 | 3 | 5 (extreme concerns) | 2 | 4 | 4 | 4 | 3 | 3 | 4 | 3 | 3 | 3 | 3 | 2 | 2 | 3 | . | 3 | 3 | 3 | 3 | None | None | 2-3 times | None | None | 1 time | None | None | Unchecked | Unchecked | Unchecked | Unchecked | Checked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Complete | 28 | 1 | 2 | |||||||||||||||||||||||||||||||||||||||||||||
1043 | Yes | 11MAY2016 | Yes | Canton Mercy Medical Center | Joan Edwards, RN, OCN | Male | 25DEC1954 | No | Checked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | High school graduate or GED | Less than $25,000 | Divorced | Not working | OH | Colorectal (including **bleep**) | Don't know | 15JUL2016 | Unchecked | Checked | Checked | Unchecked | Unchecked | No, I have not or will not be receiving hormone therapy for this cancer. | . | . | . | . | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | 5 (extreme concerns) | 5 (extreme concerns) | . | 5 (extreme concerns) | . | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | . | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | 3 | 3 | 4 | 3 | 3 | 3 | 3 | . | 2-3 times | Checked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Complete | 7 | 3 | 2 | |||||||||||||||||||||||||||||||||||||||||||||||||||
1042 | Yes | 05MAY2016 | Yes | Canton Mercy Medical Center | Jane Westfall, RN, BSN, OSN | Female | 07AUG1975 | No | Checked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Some college or 2-year degree | $100,000 or more | Married | Working- as a paid employee | OH | Breast | Stage 0 | 15NOV2016 | Checked | Unchecked | Unchecked | Unchecked | Checked | Tamoxifen | Yes, I am receiving hormone therapy. | 2 | 2 | 3 | 1 | 1 | 0 No Concerns | 0 No Concerns | 0 No Concerns | 1 | 0 No Concerns | 3 | 0 No Concerns | 2 | 2 | 2 | 2 | 0 No Concerns | 4 | 1 | 0 No Concerns | 1 | 1 | 1 | 2 | 1 | . | 0 (no concerns) | 3 | 2 | 1 | 3 | 4 | 2 | 0 (no concerns) | 1 | 0 (no concerns) | 1 | 0 (no concerns) | 1 | 0 (no concerns) | 0 (no concerns) | 4 | 3 | 5 Totally confident | 3 | . | 5 Totally confident | 5 Totally confident | . | None | 2-3 times | 8 or more times | None | 1 time | None | None | None | Checked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Complete | 7 | 3 | 4 | |||||||||||||||||||||||||||||||||||||||||
1041 | Yes | 02MAY2016 | Yes | New England Cancer Specialists | Dixie Knoll, FNP | Female | 17JUL1972 | No | Checked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Some college or 2-year degree | $25,000 to $49,999 | Divorced | Working- as a paid employee | ME | Breast | Stage 1 | 15MAY2016 | Checked | Unchecked | Checked | Unchecked | Unchecked | Yes, I am receiving hormone therapy. | 2 | 4 | 4 | . | 3 | 0 No Concerns | 0 No Concerns | 0 No Concerns | 3 | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 No Concerns | 1 | 0 No Concerns | 0 No Concerns | 0 No Concerns | 5 Extreme Concerns | 0 No Concerns | 0 No Concerns | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | 3 | 3 | . | 0 (no concerns) | 0 (no concerns) | 5 (extreme concerns) | . | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | . | 4 | 5 Totally confident | 4 | 4 | 5 Totally confident | 5 Totally confident | . | None | 6-7 times | None | None | None | None | None | None | Checked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Complete | 15 | 2 | 2 | ||||||||||||||||||||||||||||||||||||||||||
1040 | Yes | 03MAY2016 | Yes | New England Cancer Specialists | Dixie Knoll, FNP | Female | 04OCT1984 | No | Checked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | High school graduate or GED | Don't know | Married | Working- as a paid employee | ME | Breast | Stage 2 | 15JUN2016 | Checked | Checked | Checked | Unchecked | Unchecked | No, I have not or will not be receiving hormone therapy for this cancer. | 2 | 3 | 3 | . | 0 No Concerns | 0 No Concerns | 1 | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 No Concerns | 1 | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 No Concerns | 2 | 0 No Concerns | 4 | 1 | 0 (no concerns) | 0 (no concerns) | 1 | 4 | 4 | 4 | 1 | 1 | 0 (no concerns) | 0 (no concerns) | 2 | 2 | 1 | 1 | 0 (no concerns) | 0 (no concerns) | 1 | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | 4 | 3 | 4 | 2 | 3 | 4 | 3 | 2 | None | 1 time | 1 time | None | None | None | None | None | None | Checked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Complete | 15 | 2 | 2 | |||||||||||||||||||||||||||||||||||||||||
1039 | Yes | 26APR2016 | Yes | Canton Mercy Medical Center | Jane Westfall, RN, BSN, OSN | Female | 14JUN1942 | No | Checked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | High school graduate or GED | Less than $25,000 | Divorced | Retired | OH | Breast | Stage 1 | 15JUL2016 | Checked | Unchecked | Unchecked | Unchecked | Unchecked | Yes, I am receiving hormone therapy. | . | 1 | . | 2 | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 No Concerns | 1 | 0 No Concerns | 2 | 1 | 0 No Concerns | 1 | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | . | 0 (no concerns) | . | 1 | 0 (no concerns) | 0 (no concerns) | 2 | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | 2 | . | . | 5 Totally confident | 3 | 3 | 5 Totally confident | 4 | 3 | None | 2-3 times | None | None | None | None | None | None | Checked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Complete | 7 | 3 | 4 | |||||||||||||||||||||||||||||||||||||||||||
1038 | Yes | 26APR2016 | Yes | Essentia Institute of Rural Health | Jessica Nybakken, CNP | Female | 19OCT1945 | No | Checked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Some college or 2-year degree | Don't know | Married | Retired | MN | Breast | Stage 1 | 15AUG2016 | Checked | Unchecked | Checked | Unchecked | Unchecked | Yes, I completed hormone therapy. | 1 | 1 | 4 | 1 | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 No Concerns | 3 | 0 No Concerns | 1 | 0 No Concerns | 4 | 0 No Concerns | 0 No Concerns | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | 2 | 2 | 2 | 1 | 0 (no concerns) | 0 (no concerns) | 1 | 1 | 0 (no concerns) | 1 | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | 2 | . | . | 5 Totally confident | 4 | 3 | 5 Totally confident | 5 Totally confident | 3 | None | 2-3 times | None | None | None | None | None | None | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Complete | 9 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||
1037 | Yes | 26APR2016 | Yes | Essentia Institute of Rural Health | Jessica Nybakken, CNP | Female | 05AUG1944 | No | Checked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Some college or 2-year degree | Less than $25,000 | Widowed | Retired | MN | Breast | Stage 1 | 15OCT2016 | Checked | Unchecked | Checked | Unchecked | Unchecked | Yes, I am receiving hormone therapy. | 2 | . | . | . | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 No Concerns | 1 | 0 No Concerns | 0 No Concerns | 1 | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 (no concerns) | 0 (no concerns) | 1 | 0 (no concerns) | 0 (no concerns) | 1 | 0 (no concerns) | . | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | 2 | 0 (no concerns) | 1 | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | 1 | 3 | 4 | 5 Totally confident | 2 | 2 | 5 Totally confident | 5 Totally confident | 4 | 1 time | 2-3 times | None | None | None | None | None | None | 2-3 times | Surgeon | Checked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Complete | 9 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||
1036 | Yes | 26APR2016 | Yes | Canton Mercy Medical Center | Jane Westfall, RN, BSN, OSN | Female | 14JAN1981 | No | Checked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Some college or 2-year degree | $100,000 or more | Married | Working- as a paid employee | OH | Breast | Stage 2 | 15MAY2016 | Checked | Unchecked | Unchecked | Unchecked | Unchecked | Yes, I am receiving hormone therapy. | . | . | . | . | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 No Concerns | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | . | 0 (no concerns) | . | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | . | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | 0 (no concerns) | 3 | . | . | 5 Totally confident | . | . | 5 Totally confident | 5 Totally confident | 4 | None | 1 time | 1 time | None | None | None | None | None | None | Checked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Unchecked | Complete | 7 | 3 | 4 |
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.
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.;
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.