Hey Reeza, Have you any solution for this., the format looks like 11,11,11,111.00 ... View more

You can use the comma format directly. format variable comma12.2; ... View more

for the first part of the question use the direct input function date2= input(date, anydtdte12.); OR date2= input(date, mmddyy10.) format date2 mmddyy10.; This will convert the char variable to numeric with the date format. And please clarify the second part of the question. ... View more

So as I understand If there are three statuses on the same day then you want the last status of the month. for each ID. then your ouput will be like. 1 20141210  S 2 20150118  A as there are no three statuses for the ID 3 it wouldnt be included., Or even if there are no three statuses on the same day you want the last status of the user? ... View more

Do you want the last status from each ID on the same day ? or do you want to sort the sequence. ? ... View more

could you make your question more clear? ... View more

LAG function is something which refers to the previous row. for ex: Name    Age A           20 B          50 C         40 New= age-lag(age) this gives you Name    Age    New A           20      . B          50      30 C         40      10 And DIF is ,you can directly write the function DIF(age) you get the difference. With Lag you can do any calculation with the previous row. and also with the previous row of any variable with the present row, ... View more

If you want to calculate with the previoud row.. then it is better to use LAG funtion. or DIF ... View more

If you want to use proc export you can do this way., Proc export data= dataset outfile="location and file name.xlsx" dbms=xlsx replace; sheet='sheetname';run; Giving a different sheetname for every new export statement is importnat so it doesnot override the previous one. repeat this procedure for any  number of datasets.. ! ... View more

I feel it is better to use proc tabulate like this.. Proc tabulate data=temporary; class ageclass; var age; table ageclass, age*(n mean*f=bestd6.2 ); run; Using the formar bestd6.2 This should work. ! ... View more