I have a table that derermines orders on off days it looks like this SUN THRU SAT is weekly sch N no orders Y yes order Id. Date s. m tue. wed thu fri sat A1. 02/14/19. N. Y. N. Y. Y. N. N B1. 02/14/19. N. Y. N. Y. N N. N As you can see A1 02/14/19 is done correctly And B1 was done on wrong sch date I would need the ones done on wrong sch day to Create a different dataset . Its should vary count from 3 to 300 .. thank you for the help ... View more

I have a proc transpose Proc sort = combine; By number; Run; Proc transpose data =combine out =combine2 ; By date number cost ; Var balance; Id service type; Run I get error message the id value occurs twice in the by group My table looks Number. Date. Balance. Cost. Service type 123. 01/04/19. 120. 23A. VENDOR 123. 01/05/19. 133. 23A. VENDOR 234. 02/02/19. 150. 24B. CUSTOMERS 245. 02/06/19. 210. 25B. CUSTOMERS I ... View more

I have a macro that should filter start and end date ..it suppose to bring yesterday but it brings everything its an oracle platform Data _null_; Format c date7. E date7.; C=datepart (datetime())); E=c-1; Call symput ('cdate2', "'"||vvalue(e)||"'d'"); Run; %put &cdate2.; Where datepart (created)>&cdate2 ... View more

I have a table i need to get max date. Proc sql; Create table test as Select Id. Balance. Max(Create ) as Date Fr;m tedt1 , Run; It brings everything. The create is a datetime20 format. The output is converted to 1859756644 ... View more

I would like to convert z format datetime20 to datetime19 ... View more

Here is my code proc export data=sashelp.class    table=class    dbms=access2007 replace;    database='c:\data\test.accdb'; run; libname myaccdb 'c:\data\test.accdb'; proc append base=myaccdb.class data=sashelp.class; run; libname myaccdb clear My question is i have a primary key thats get removed which will allow duplication. How can i keep my primary key? ... View more

I tried using prxmatch would it be easier to use index? I am looking for word text4, text 7, and text9. Sometimes they are misspell for example tex4 The index works if its one and spelled correctly Data test; Set test; Text_position( varaible,"text4"); Run; This works great i need to add the additional text7 and text9 ... View more

Im needing help to find 3 words in a text Here is what i have Data test; Set test; If prxmatch('m/brake|brakepads| pads /oi',textbox,>0; Run; When i run it the data gets removed ... View more