I need to concatenate a SAS date and number to match a concatenated field in excel.   Example; In excel, my date  is 01/31/2017 and the number I want to concatentate with it is 100.  When I concatenate these 2 fields, I get 42766100.   How would I concatenate the same 2 values in SAS to return 42766100?  The date is datetime in sas but I don't need the time part. I have tried all the cat, catx, catq, cats functions to no success.  I also tried adding 21916 to my date field but that didn't work either.  I'm stuck. 😞 ... View more

  I have the following proc summary.  How do I make a grand total at the end of the rows? proc summary data=inv3 nway; class dt rep supe cur_pd; output out=inventory_counts (drop=_type_ rename=(_freq_= TL_INVENTORY)); run; ... View more

Need some help with proc summary.   My data is attached with how it currently looks and what I'm hoping it to look like.      Here's the code I have;   rsubmit; proc summary data=worked2 nway; var talk_secs acw_secs total_secs total_mins; class yr mth dt rep supervisor tactic; output out = daily_counts(drop=_type_ rename=(_freq_=tl_count) sum=talk_secs acw_secs total_secs total_mins); run; proc sort data=daily_counts out=daily_counts; by dt; proc print data=daily_counts (obs=10); run;endrsubmit; ... View more

I need some help on exporting a data set to excel.   My data looks like this;   date                colour       total    02/01/2016     blue             2 02/01/2016     yellow          5   In my excel workbook, my report will be using vlookups to determine the number of blue vs. yellow on Feb.1st.  Therefore, I will be making a concatenated field of the date & colour.  I would like to make this concatenated field the first column (column A) in my data sheet and don't want to have to create the column daily.  How do I export the above 3 columns by skipping column A on my data sheet?  I would like to replace everything in the data sheet daily with the exception of column A.   ... View more

When I post a question it is showing my full name as the author.  How do I get it to show my username?  I can't seem to find the option in preferences. ... View more