format

[souji]

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;

[ed_sas_member]

Hi @souji 

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

format Ship_date date9.;

[souji]

Thank you

[PeterClemmensen]

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;