Hello, I have text files where the filename changes according to the date and its record number.  For example, "unit1-20141021-0001.txt" and "unit1-2014-1020-0003.txt" I want to create a SAS dataset with all of these files, however I'm not sure the easiest way to pick up all the files without typing out each filename as the "datafile" in the proc import statement. This is what I have: proc import out=WORK.MYDATA datafile= "C:\unit_info\unit1-20141021-0000.txt" DBMS = CSV Replace; Getnames= No; Datarow=20; run; Any help with this would be appreciated. Thanks Lori ... View more

Hello, I have a query that selects a single day's data using the macro &date. Create table work.temptpc select t1.cc, t1.turn_dt, t1.delay_hrs from imcs.pay_tpc_prd_a t1 where turn_date = "&date"d My question is I now would like the query to also grab (filter) our fiscal year data from imcs.pay_tpc_prd_a from the date selected using macro &date.  Our fiscal year is April 1 - March 31. Example:  If the date selected was September 1, 2013, the fiscal year would be April 1, 2013 - March 31, 2014. Thanks for your help in advance, Lori ... View more

I am trying to skip a line after a "break after" statement using proc report.  This is a stored process that will run on the SAS Stored Process Server.  I would like to skip a line after summing up totals by prob_num.  Here is my code: options orientation=landscape center number; ods pdf file=_WEBOUT notoc; proc report data=WORK.SORTSortedQUERY_FOR_PAY_MONTHLY_; title justify=left "Monthly Bonus Calculation" justify=center "&bonus_month - &bonus_yr" justify=right "HP14"; footnote "Generated by the SAS System on %TRIM(%QSYSFUNC(DATE(),MMDDYY8.)) at %TRIM(%SYSFUNC(TIME(),TIMEAMPM12.))"; column prob_num cc pos clock_num reg_hrs1 reg_amt1 ot_hrs1 ot_amt1 sun_hrs1 sun_amt1 worked_holiday_hrs1 worked_holiday_amt1 unworked_holiday_hrs1 unworked_holiday_amt1 tot_hrs tot_amt; define prob_num / group 'Prob' ; define cc / display 'CC' ; define pos / display 'Pos' ; define clock_num / group 'Clock No'; define reg_hrs1 / sum 'Reg Hrs' ; define reg_amt1 / sum 'Reg Amt' ; define ot_hrs1 / sum 'OT Hrs' ; define ot_amt1 / sum 'OT Amt' ; define sun_hrs1 / sum 'Sun Hrs' ; define sun_amt1 / sum 'Sun Amt' ; define worked_holiday_hrs1 / sum 'Worked Hol Hrs' ; define worked_holiday_amt1 / sum 'Worked Hol Amt' ; define unworked_holiday_hrs1 / sum 'Unworked Hol Hrs' ; define unworked_holiday_amt1 / sum 'Unworked Hol Amt' ; define tot_hrs / sum 'Tot Hrs' ; define tot_amt / sum 'Tot Amt' ; break after clock_num / summarize style=[font_weight=bold] ; break after prob_num / summarize style=[font_weight=bold] skip; rbreak after / summarize style=[font_weight=bold] ; run; ods _all_ close; I place the "skip" in the break after statement, but it does not skip a line.   Am I missing something? Thanks! ... View more

I have attached the code that I am working with.  I was wondering if its possible to fit all data on one page using proc report?  For example, I am working with two columns (cc, labor hours) and grouping/ paging it by the Shop #.  What happens is, if there are a lot of CC's with labor hours, it moves to another page and because it is only two columns I would like it to finish listing the data on the same page. Would like to see this: Shop 301 CC     Labor Hours                 CC     Labor Hours 053     4.0                             065     13.0   239     20.0                           244      8.0     314     2.0 506     16.0 516     4.0 **End of Page** Instead of this: Shop 301 CC     Labor Hours 053     4.0 239     20.0 314     2.0 506     16.0 516     4.0 065     13.0 244     8.0 Thanks for your help Lori ... View more