[求助]如何将字符型变量转换为日期型变量

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

我从CSMAR数据库下载了日期数据，但是导入到SAS后，全是字符型的，我想将该变量转换为日期型，请问应该如何做？谢谢

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享1 收藏0 回帖

关键词：字符型变量 变量转换 日期型 字符型 CSMAR

how does your data look like? suppose it is ddmmyy10.

new_var = input(old_var, ddmmyy10.);

I don't think it works using the SAS code above. Please see the following SAS code.

The hospitalization date is characteristic variable in the data set a as HOSPADMIT, such as '19991103'.

It means in the year '1999', 'NOV.', and date  '03' The hospitalization date should be transferred to '03NOV1999'

in the data set b as variable of HOSP_ADMIT_DT.

Please try it.

Data b;

Set a;

HOSP_ADMIT_YYYY = substr(HOSPADMIT, 1,4);

HOSP_ADMIT_MM = substr(HOSPADMIT, 5,2);

HOSP_ADMIT_DD = substr(HOSPADMIT, 7,2);

HOSP_ADMIT_DT = MDY(HOSP_ADMIT_MM, HOSP_ADMIT_DD, HOSP_ADMIT_YYYY);

format HOSP_ADMIT_DT date9.;

DROP HOSPADMIT HOSP_ADMIT_YYYY HOSP_ADMIT_MM HOSP_ADMIT_DD;

Run;

 

[此贴子已经被作者于2008-10-25 1:05:20编辑过]

in that case then

new_var = input(old_var, yymmdd8.);

I made an assumption at the first place. Yes, you are right, It will depend on how the format the old variable looks like.

In your code, the YYYY, MM and DD variables are still character variables. you have to use input function to transpose.

[此贴子已经被作者于2008-10-25 2:14:00编辑过]

Thank you for your reply. In that case, your code is right.

Your code uses the function of "INPUT". My code uses the function of "MDY". My understanding, in some cases, the INPUT function is easy to manipulate, to transfer one characteristic variable to numeric or date variable using argument option.

In some cases, if the date, month, and year are separated to different characteristic variables, the MDY function could combined them together and transfer it to date variable.

[此贴子已经被作者于2008-10-25 6:44:05编辑过]

感谢楼上二位

i have dealt with the problem all the time. and i think there is trick if you are not willing to deal with SAS code. that is, you can change the cell format for the date variable in the excel to '14/03/2001' which can be recognized by SAS and will be transferred to '14MAR2001' (date9.) in SAS.

楼主你好，请问你的问题解决了吗？我面临和你一样的问题，但楼上两位的解决办法好像不行啊？麻烦您指教下，谢谢~