I have also changed to use iso8601dt.   data Aculore_date_format_qn_ex1; input doj date9. @11 dob date9. @21 datejulian julian5. @27 dateiso datetime18.; format doj date9. dateiso is8601dt.; dob=dhms(dob,00,00,00); datejulian=datejul(datejulian); format datejulian date9. dob datetime18.; cards; 01jan2022 01jan1987 22365 01jan2022:12:05:00 ; run; proc print data=Aculore_date_format_qn_ex1; run;   Output: Obs doj dob datejulian dateiso1 01JAN2022 01JAN87:00:00:00 10JAN2023 2022-01-01T12:05:00 ... View more

Thanks Kurt, I have corrected julian date. ... View more

Hi ballardw, I have tried to use dhms for dob and got it. I tried to correct other variables also as below: But, I am not sure if datejulian output is correct or not. It gives 10Jan2023 whether I use julian5. (with value 22365) or julian7. (with value 2022365. Can you please explain why it is giving 10Jan2023 and also, the corrections I have carried out are correct or not?   data date_format_ex1; input doj date9. @11 dob date9. @21 datejulian julian5. @27 dateiso datetime18.; format doj date9. dateiso datetime18.; dob=dhms(dob,00,00,00); datejulian=datejul(datejulian); format datejulian date9. dob datetime18.; cards; 01jan2022 01jan1987 22365 01jan2022:12:05:00 ; run; proc print data=date_format_ex1; run;   Output:  Obs doj dob datejulian dateiso1 01JAN2022 01JAN87:00:00:00 10JAN2023 01JAN22:12:05:00 ... View more

Hi Tom,          The suggestion of Paige Miller to use ODS PDF and proc print to create the dataset 'totals' and the suggestion "Just a simple point to consider.  If you want to write out the MEAN (or any other statistic) of a variable you have to first calculate the value and save it somewhere." provided by you earlier helped me to understand that I have to first create the data set like 'totals' and then use ODS PDF.                 Thank you. ... View more

Thank you ballardw. ... View more

Hi Paige Miller,                      Actually, what I was thinking that instead of creating an out dataset 'totals', write the SUM and Mean to a file using FILE statement. But, after clarifications to my query by you and Tom, I understand that I have to create out data set 'totals' and use ODS PDF to write it to an external pdf file. Hence, your advise to use the ODS PDF file write 'total's data set to a file is a solution for my query.                         Thank you very much.  ... View more

Hi Tom,          I am trying to write the  SUM(Petunia SnapDragon Marigold)= Petunia_Sum SnapDragon_Sum Marigold_Sum; MEAN(Petunia SnapDragon Marigold)=Petunia_Mean SnapDragon_Mean Marigold_Mean;   to the FILE "Means_SUMMARY_REPORT.rep", as I do not want to create output data set "totals" but getting the following errors: 575 proc means data=sales1; 576 by CustomerID; 577 var Petunia SnapDragon Marigold; 578 /*Write the following to the Means_SUMMARY_REPORT.rep file*/ 579 SUM(Petunia SnapDragon Marigold)= Petunia_Sum SnapDragon_Sum Marigold_Sum; --- 180 580 MEAN(Petunia SnapDragon Marigold)=Petunia_Mean SnapDragon_Mean Marigold_Mean; ---- 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 581 CODE that I am trying is: data sales1; infile 'H:\SAS Training\MyPractice\datafiles\Flowers_proc_means.txt'; input CustomerID $ @9 SaleDate MMDDYY10. Petunia SnapDragon Marigold; FILE 'H:\SAS Training\MyPractice\outputfiles\Means_SUMMARY_REPORT.rep' PRINT OLD; run; proc sort data=sales1; by CustomerID; proc means data=sales1; by CustomerID; var Petunia SnapDragon Marigold; /*Write the following to the Means_SUMMARY_REPORT.rep file*/ SUM(Petunia SnapDragon Marigold)= Petunia_Sum SnapDragon_Sum Marigold_Sum; MEAN(Petunia SnapDragon Marigold)=Petunia_Mean SnapDragon_Mean Marigold_Mean; run;   I am attaching the Flowers_proc_means.txt file. But, as you have mentioned "Just a simple point to consider.  If you want to write out the MEAN (or any other statistic) of a variable you have to first calculate the value and save it somewhere", I think, the only way to write to an external file is to create some output data set like "totals" storing the SUM and MEAN statistics and as Paige Miller has suggested use ODS to write it to a pdf file.   Thank you ... View more

Hi Paige Miller,                     This works, thank you. However, I think I didn't mention clearly what I am trying to do in the proc means. I am trying to write  SUM(Petunia SnapDragon Marigold)= Petunia_Sum SnapDragon_Sum Marigold_Sum MEAN(Petunia SnapDragon Marigold)=Petunia_Mean SnapDragon_Mean Marigold_Mean; and I don't want to create an output data set 'totals' but instead I want to write this to a file using FILE or ODS. I mean, I don't want to create any output data set like totals. But, want to write  SUM(Petunia SnapDragon Marigold)= Petunia_Sum SnapDragon_Sum Marigold_Sum MEAN(Petunia SnapDragon Marigold)=Petunia_Mean SnapDragon_Mean Marigold_Mean; to a file in proc means step.                      Or, to write such kind of output, is it the only way that I have to first create a data set like 'totals' and then write to a pdf file using the code given by you and there is no other way of achieving this using FILE statement in proc means?                  Sorry, if I am asking a silly question.      Thank you ... View more

Hi Paige Miller,                     Thank you very much for your advise. The The output of my code where the output is written to data set 'totals' contains the output of as shown below: SUM(Petunia SnapDragon Marigold)= Petunia_Sum SnapDragon_Sum Marigold_Sum MEAN(Petunia SnapDragon Marigold)=Petunia_Mean SnapDragon_Mean Marigold_Mean;   Obs CustomerID _TYPE_ _FREQ_ Petunia_Sum SnapDragon_Sum Marigold_Sum Petunia_Mean SnapDragon_Mean Marigold_Mean123 756-01 0 3 305 350 285 102 117 95 834-01 0 2 170 220 160 85 110 80 901-02 0 2 110 160 135 55 80 68 How to get the same output in pdf file? Can you please advise?   Thank you       ... View more

Thank you very much Tom.  ... View more

Thank you very much Cynthia for a very detailed explanation. As I am new to SAS, I could not understand the symputx function and put(_n_,2.0) calls in the IF condition. I have tried searching google, but somehow I could not get clear clarification on these functions.   if lastone = 1 then do; call symputx('stop', put(_n_, 2.0), 'G'); call symputx('first', put(_n_-10+1, 2.0), 'G'); end;   Can you please explain about symputx and put functions also?   Thanks  ... View more

Thank you very much Quentin. Both suggestions using length and the alternative code are helpful.   ... View more

Hi Cynthia, thank you very much for providing alternative methods. But, I didn't understand the method where symputx is used. Can you please, help me understand this?   Thanks ... View more