topic Re: format in SAS Programming

format

souji — Sat, 11 Jan 2020 13:29:11 GMT

Hi, am I doing anything wrong here since Ship_data is not coming same as like (02FEB2009) in output. please correct my code

data work.put123;

length Order_Id 6 Customer $15 Ship_date 8;

input @1 Order_Id 5. @7 Customer $12. @20 Ship_date date9.;

format Ship_date yymmddd10.;

datalines;

9341 Josh Martin 02FEB2009

9874 Rachel Lords 14MAR2009

10233 Takashi Sato 07JUL2009

;

run;

Re: format

ed_sas_member — Sat, 11 Jan 2020 13:36:43 GMT

Hi @souji

You just need to use the date9. Format instead of the yymmddd10. format:

format Ship_date date9.;

Re: format

souji — Sat, 11 Jan 2020 14:27:54 GMT

Thank you

Re: format

PeterClemmensen — Sat, 11 Jan 2020 14:57:38 GMT

Simply apply the Date9 format instead

data work.put123;
length Order_Id 6 Customer $15 Ship_date 8;
input @1 Order_Id 5. @7 Customer $12. @20 Ship_date date9.;
format Ship_date date9.;
datalines;
9341  Josh Martin  02FEB2009
9874  Rachel Lords 14MAR2009
10233 Takashi Sato 07JUL2009
;
run;