cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Beto16
‎11-02-2016
  • 80 Posts
  • 3 Likes Given
  • 0 Solutions
  • 1 Likes Received

Date between statement error

by Obsidian | Level 7 in SAS Programming
‎10-31-2016 06:14 PM
‎10-31-2016 06:14 PM
I have a data step Data _null; Z=-1; Call symputx ('y' ,z); Run; %put &y; Data _null_; Length DOWN $10; X=weekday (today ()&y); If x=1 then DOW = 'Sunday'; If x=2 then DOW = 'M If x =3 then DOW = 'Tuesday'; If x=1 then DOW = 'Wednesday'; If x=1 then DOW = 'thursday'; If x=1 then DOW = 'friday'; If x=1 then DOW = 'Saturday '; Call symput('DOW','DOW'); Run; %put &DOW; DATA _NULL_; START_DATE=TODAY ()&Y; IF WEEKDAY (START_DATE)=1 THEN START_DATE =START_DATE-1; CALL SYMPUT ('DT', " ' "||PUT (START_DATE,date.)||" '"); Run; In my andstatenent and al1.start_time = &dt1. Error log CLI PREPARE ERROR. TERADATA A CHARACTER STRING FAILED TO CONVERSION TO NUMERIC VALUE. The dt1. Resolves to 30oct16 ... View more

Re: How to get every instance of a word ?

by Obsidian | Level 7 in SAS Programming
‎10-22-2016 11:17 PM
‎10-22-2016 11:17 PM
The data is in one cell BUT data is format like this Raw data. Date. Id Raw data. 10/01/16. 1ZR67 RAW DATA 10/06/16. 1ZR68 ... View more

Re: How to get every instance of a word ?

by Obsidian | Level 7 in SAS Programming
‎10-22-2016 11:07 PM
‎10-22-2016 11:07 PM
The file comes in as a check csv. I open thru excel .. Row 1 row":1,"bagbarcode ":"RS5748008","Atmbarcode ":"CA0797220129","$$HASHKEY":"object:14"},{"row":1,"bagbarcode ":"RS5748009","Atmbarcode ":"TX797220129","$$HASHKEY":"object:14"},row":1,"bagbarcode ":"RS5748015","Atmbarcode ":"WV0797220129","$$HASHKEY":"object:14"},{"row":1,"bagbarcode ":"RS5748029","Atmbarcode ":"SA97220129","$$HASHKEY":"object:14"},row":1,"bagbarcode ":"RS5748028","Atmbarcode ":"CA0797220129","$$HASHKEY":"object:14"},{"row":1,"bagbarcode ":"RS57480259","Atmbarcode ":"JQ797220129","$$HASHKEY":"object:14"},row":1,"bagbarcode ":"RS5748039","Atmbarcode ":"NY0797220129","$$HASHKEY":"object:14"},{"row":1,"bagbarcode ":"RS5748038","Atmbarcode ":"QU97220129","$$HASHKEY":"object:14"},row":1,"bagbarcode ":"RS5748048","Atmbarcode ":"UT0797220129","$$HASHKEY":"object:14"},{"row":1,"bagbarcode ":"RS5748048","Atmbarcode ":"DA97220129","$$HASHKEY":"object:14"},row":1,"bagbarcode ":"RS5748058","Atmbarcode ":"DF797220129","$$HASHKEY":"object:14"},{"row":1,"bagbarcode ":"RS5748016","Atmbarcode ":"JX797220129","$$HASHKEY":"object:14"},row":1,"bagbarcode ":"RS57480017","Atmbarcode ":"QA0797220118","$$HASHKEY":"object:14"},{"row":1,"bagbarcode ":"RS5748019","Atmbarcode ":"FL797220129","$$HASHKEY":"object:14"}, row":1,"bagbarcode ":"RS5748012","Atmbarcode ":"LA0797220129","$$HASHKEY":"object:14"},{"row":1,"bagbarcode ":"RS5748011","Atmbarcode ":"WA797220129","$$HASHKEY":"object:14"} This is an example of my raw data .. I would need help with setting up a scan with loop ..thank you ... View more

Re: How to get every instance of a word ?

by Obsidian | Level 7 in SAS Programming
‎10-22-2016 02:01 PM
‎10-22-2016 02:01 PM
the data looks [{"row":1,"bagbarcode ":"RS5748008","Atmbarcode ":"CA0797220129","$$HASHKEY":"object:14"},{"row":1,"bagbarcode ":"RS5748009","Atmbarcode ":"TX797220129","$$HASHKEY":"object:14"}] this is in one cell sometimes there can be 10 entries in that cell I need data to look Output A. B TX797220129. RS5748008 CA797220129. RS5748009 ... View more

Re: How to get every instance of a word ?

by Obsidian | Level 7 in SAS Programming
‎10-21-2016 03:48 PM
‎10-21-2016 03:48 PM
Yes I did but the raw data change before I had 100 col to extract an now the data is in one cell which could have 10 to 20 I'd I would need to extract... the solution I was giving doesn't work anymore ... View more

Re: How to get every instance of a word ?

by Obsidian | Level 7 in SAS Programming
‎10-21-2016 03:09 PM
‎10-21-2016 03:09 PM
How do I refer a file? (Named test1) And the col where the data is located it's called x ? ... View more

How to get every instance of a word ?

by Obsidian | Level 7 in SAS Programming
‎10-21-2016 12:09 PM
‎10-21-2016 12:09 PM
Hi have a data dump that has a special word in the comment field I need to extract every instance. Here is the script that I was using Data have; Infile 'C:\users\desktop \night4.csv' dlm ='09' X truncover; Input x $25000.; Length Bacode $25; N+1; Pid=prxparse ('/atmbarcode:\W*\w+/i'); s=1; E=length (x); Call prxnet (pid,s,e,x ,p,l); Do while (p>0); Bacode =substr (x,p,l); Output; Call prxnext (pid,s,e x,p,l); End; Keep n x bacode; Run; Here is the data it's 3 cols A "Atmbarcode ":"CA74822531", Atmbarcode ":"AZ74822531", Atmbarcode ":"WA74822531", ... Everytime there is a atmbarcode I need the 10 characters to be extract ... Out put X AZ74822531 WA74822531 CA74822531 Thanks ... View more

Using Prxparse to pull 2 words at same time

by Obsidian | Level 7 in SAS Programming
‎10-04-2016 01:57 AM
‎10-04-2016 01:57 AM
Hi I have this code Data have Infile 'C:\users\desktop \night.csv' dlm='09' X dsd truncover;; Input x $25000.; Length Bacode $25; N+1; Pid = prxparse ("/atmbarcode:\W*\w+i'); S=1; E=length (x); Call prxnext (pid,s,e,x,p,l); Do while (p>0), Bacode =substr(x,possibly l);output; Call prxnext (pid,s,e,xp,l); End; Keep n x bacode; It pulls in id number it works I need to extract a 2ndword at same time here it is Prxparse ('/RS [A-Z\d](15))|(?<=bagbarcode \W,POS-13,2),substr (x,POS-19,2)); RUN; HOW do I combine both prxparse to pull at same time? Thanks ... View more

Re: How to append 180 datasets to one datasets?

by Obsidian | Level 7 in SAS Programming
‎07-30-2016 08:11 PM
‎07-30-2016 08:11 PM
Oops I didn't see that's what I did my error ... View more

Re: How to append 180 datasets to one datasets?

by Obsidian | Level 7 in SAS Programming
‎07-30-2016 02:19 PM
‎07-30-2016 02:19 PM
Reeza. data want; set D:; run; this appended all the files that start with D it's what I was looking for ... View more

Re: use prxparse finding date

by Obsidian | Level 7 in SAS Programming
‎07-29-2016 09:25 AM
‎07-29-2016 09:25 AM
Hi Chris you help me with this code couple of weeks ago Thanks it works now the request is to find Date formatted "".2016-06-07T00:16:11,,  is it possible to run this part of code PRX=prxparse('/(1ZT[A-Z\d]{14}) an where it matches 1ZT Bring in everything in the 10 character to the left of 1ZT ? the date is always in front of the 1ZT your thoughts? data _null_; file "%sysfunc(pathname(WORK))\t.txt"; X='X. Bacode. N. Newvar ZT2487 '; put X; X='Blah,blah,blah, Atmbarcode :"TY272822. 2'; put X; X='Blah, blah,blah,blah, '; put X; X='1ZT2487A122111112,blah,blah, '; put X; run; data WANT; infile "%sysfunc(pathname(WORK))\t.txt" pad; input X $80.; PRX=prxparse('/(1ZT[A-Z\d]{14}) (?# capture 1ZT and 14 letters or digits) | (?# or) (?<=Atmbarcode\W{3}) (?# capture preceeded by Atmbarcode\W{3} ) (TY\d*) (?# capture TY and digits) /x'); call prxsubstr(PRX,X,POS,LEN); if POS then STR=substr(X,POS,LEN); putlog STR=; run;   STR= STR=TY272822 STR= ... View more

Re: use prxparse finding date

by Obsidian | Level 7 in SAS Programming
‎07-28-2016 09:53 PM
‎07-28-2016 09:53 PM
The "".2016-06-07T00:16:11,, is not in the same location in the comment box it varies ...would substr still work ? The prxchange actually comes close to what I need data test; Date10 = prxchange("s#(\d{4})-(\d{2})-(\d{2})T[0-9:]{8}#\2/\3/\1#o", 1, dateStr); put _all_; run; It doesn't bring date .. thanks for the help ... View more

Re: use prxparse finding date

by Obsidian | Level 7 in SAS Programming
‎07-28-2016 05:29 PM
‎07-28-2016 05:29 PM
Yes that is how all date entries look "".2016-06-07T00:16:11,, thanks for your assistance ... View more

Re: use prxparse finding date

by Obsidian | Level 7 in SAS Programming
‎07-28-2016 02:38 PM
‎07-28-2016 02:38 PM
Hi PgStats, the code works it ran without errors but didn't bring date. It brought in the 1st 199 character from the text box.. I noticed the date is formatted the same way in all my entries "".2016-06-07T00:16:11,, thanks for your assistance ... View more

use prxparse finding date

by Obsidian | Level 7 in SAS Programming
‎07-27-2016 06:10 PM
‎07-27-2016 06:10 PM
Hi I'm want to use paxparse to get the date from a csv file. The date is format 2016-06-26T20:44:16 I would want the output to look like this 06/27/2016 ...ThAnka for assistance ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎11-02-2016 03:45 PM
Likes given to
View All
Likes from
View All
Quick links