I have a user asking to reformat a $ value when it is a credit it is showing as $-1,175.55 user wants ($1,175.55) I am using : style(column)= [tagattr='format:$#,###,##0.00']; = $-1,175.55   The users want the value to look like ($1,175.55)   Is there a tagattr style that will give me that?   Thanks, Elliott ... View more

I am creating a SAS dataset that I need in a specific format to be written out using proc export to create a tab delimited text file.  The output has the first row missing the variable values and only contains the hard coded values and the last row is empty so the output is missing the last row of the dataset.  I do not know why this is happening.  Is there somthing I am missing is there an option I need to add or is my dataset creation incorrect?   Any assistance you can offer will be greatly appreciated.   Thanks, Elliott   here is my code: data my_data (keep= Task_ID Process_ID Team_ID Received_Date Received_Time Case_Notes Task_Due_date Process_Due_date Allocation_Staff_ID PendDate CompletedTime Reference_1 Reference_2 Reference_3 Reference_4 Reference_5 Reference_6 Reference_7 Reference_8 Additional_Field_1 Additional_Field_2 Additional_Field_3 Additional_Field_4 Additional_Field_5 Additional_Field_6 Additional_Field_7 Additional_Field_8 Additional_Field_9 Additional_Field_10 Additional_Field_11 Additional_Field_12 Additional_Field_13 Additional_Field_14 Additional_Field_15 Additional_Field_16 Additional_Field_17 Additional_Field_18 Additional_Field_19 Additional_Field_20 Additional_Field_21 Additional_Field_22 Additional_Field_23 Additional_Field_24 Additional_Field_25 Additional_Field_26 Additional_Field_27 Additional_Field_28 Additional_Field_29 Additional_Field_30 Additional_Field_31 Additional_Field_32);   retain Task_ID Process_ID Team_ID Received_Date Received_Time Case_Notes Task_Due_date Process_Due_date Allocation_Staff_ID PendDate CompletedTime Reference_1 Reference_2 Reference_3 Reference_4 Reference_5 Reference_6 Reference_7 Reference_8 Additional_Field_1 Additional_Field_2 Additional_Field_3 Additional_Field_4 Additional_Field_5 Additional_Field_6 Additional_Field_7 Additional_Field_8 Additional_Field_9 Additional_Field_10 Additional_Field_11 Additional_Field_12 Additional_Field_13 Additional_Field_14 Additional_Field_15 Additional_Field_16 Additional_Field_17 Additional_Field_18 Additional_Field_19 Additional_Field_20 Additional_Field_21 Additional_Field_22 Additional_Field_23 Additional_Field_24 Additional_Field_25 Additional_Field_26 Additional_Field_27 Additional_Field_28 Additional_Field_29 Additional_Field_30 Additional_Field_31 Additional_Field_32 ;   format Task_ID $16. Process_ID $16. Team_ID Received_Date Received_Time Case_Notes Task_Due_date Process_Due_date Allocation_Staff_ID PendDate CompletedTime Additional_Field_1 Additional_Field_2 Additional_Field_3 Additional_Field_4 Additional_Field_5 Additional_Field_6 Additional_Field_7 Additional_Field_8 Additional_Field_9 Additional_Field_10 Additional_Field_11 Additional_Field_12 Additional_Field_13 Additional_Field_14 Additional_Field_15 Additional_Field_16 Additional_Field_17 Additional_Field_18 Additional_Field_19 Additional_Field_20 Additional_Field_21 Additional_Field_22 Additional_Field_23 Additional_Field_24 Additional_Field_25 Additional_Field_26 Additional_Field_27 Additional_Field_28 Additional_Field_29 Additional_Field_30 Additional_Field_31 Additional_Field_32 $10. Reference_1 $18. Reference_2 $10. Reference_3 $50. Reference_4 $10. Reference_5 $10. Reference_6 $10. Reference_7 $10. Reference_8 $16. ;   Task_ID ='Error_Detail'; Process_ID ='Error_Detail'; Team_ID ='Team 372 ' ; Received_Date =' '; Received_Time =' '; Case_Notes =' '; Task_Due_date =' '; Process_Due_date =' '; Allocation_Staff_ID =' '; PendDate =''; CompletedTime =''; Reference_1 = ACCT_NBR; Reference_2 = ' ' ; Reference_3 = sub_client; Reference_4 = LANG_CD_W; Reference_5 = LANG_CD_V; Reference_6 = language_ind; Reference_7 = ERR_LANG_IND; Reference_8 = 'Error_Detail'; Additional_Field_1 =' '; Additional_Field_2 =' '; Additional_Field_3 =' '; Additional_Field_4 =' '; Additional_Field_5 =' '; Additional_Field_6 =' '; Additional_Field_7 =' '; Additional_Field_8 =' '; Additional_Field_9 =' '; Additional_Field_10 =' '; Additional_Field_11 =' '; Additional_Field_12 =' '; Additional_Field_13 =' '; Additional_Field_14 =' '; Additional_Field_15 =' '; Additional_Field_16 =' '; Additional_Field_17 =' '; Additional_Field_18 =' '; Additional_Field_19 =' '; Additional_Field_20 =' '; Additional_Field_21 =' '; Additional_Field_22 =' '; Additional_Field_23 =' '; Additional_Field_24 =' '; Additional_Field_25 =' '; Additional_Field_26 =' '; Additional_Field_27 =' '; Additional_Field_28 =' '; Additional_Field_29 =' '; Additional_Field_30 =' '; Additional_Field_31 =' '; Additional_Field_32 =' ';   set data_pop; run;   proc export data=my_data outfile="/my_path/my_directory/my_file.txt" dbms=tab replace; run; ... View more

I need to test some date logic I am using for creating date variables and we have specific scenarios if it is Sunday and the 1st day of the month.   If I want to test each day but I need to know how do I override the system values for weekday and day to test my logic?   here is what my logic looks like: data _null_; if weekday(date()) = 1 then do; /* weekday = sunday */ /* code should not run on sundays unless it is Sat EOM */                 if day(date()) ^= 1 then do; /* day of month not the 1st day of the month */ /* code should not run on sundays unless it is Sat EOM */                                 wod2 = date()-1;                                 wod1 = date()-2;                 end; /* Saturday EOM processing - Code should run on Sunday if it is the 1st day of the month - pick up Saturday file (-1) */                 else do;                                 wod2 = date()-1;                                 wod1 = date()-2;                 end; end;   /* if monday and the 2nd of the month, code should not run because there is no sunday file due to SAT EOM Batch */ if weekday(date()) = 2 then do;  /* weekday = Monday */                  if day(date()) ^= 2 then do;  /* day of month not the 2nd day of the month */ /* BAU Monday pull -1(Sunday) and -3(Friday) files */                                 wod2 = date()-1;                                 wod1 = date()-3;                 end;                   else do;  /* if is monday and the 2nd of the month, code should not run */                                 wod2 = date()-2;                                 wod1 = date()-3;                 end; end;   /* if tuesday and the 3rd of the month, after no run monday 2nd of month, code should pull for Monday(-1) and Sunday(-2) */ if weekday(date()) = 3 then do;  /* weekday = Tuesday */                  if day(date()) ^= 3 then do;  /* day of month not the 3rd day of the month - then just -1 */                                 wod2 = date()-1;                                 wod1 = date()-2;                 end;                   else do;  /* if is the 3rd then -1 and -3 */                                 wod2 = date()-1;                                 wod1 = date()-3;                 end; end; /* BAU Processing *//* any other day of the week will pull  dates previous days(-1) and (-2)*/ if weekday(date()) > 3 then do;                                 wod2 = date()-1;                                 wod1 = date()-2; end;   CALL SYMPUT ("wod2",put(wod2,YYMMDDN8.)); CALL SYMPUT ("wod1",put(wod1,YYMMDDN8.)); run;   %put &wod1; %put &wod2;   can you override those system values?   Thanks, Elliott ... View more

Hi,  I have a new sql server table data source that I need to query but several of the variables have hyphens in the variable names. I am using a SAS pass through query to access the SQL Server database/view. How do I get SAS to accept the non standard names?  I plan on renaming to change the hyphen to an underscore but right now I cannot even read them in. Any assistance will be greatly appreciated. Thanks, Elliott ... View more