About sleretrano

sleretrano · ‎01-16-2017

Thank you for your time. Yes, assume that there always is a "proper" path. I'm not sure I understand your question, The ordering, by descending priority is: ID, Time, Path. Can you please provide the code to your suggestion?

sleretrano · ‎01-16-2017

I'm using SAS EG 5.1 on Windows 7. I have the following sample input. I wish to order this input in such a way that whenever different observations match on ID and on Time, the final state of a given observation matches the initial state of the next observation. The output should look like this: I'm at a loss on how to do this. Any help? Here's the code that generates the input table. Data Test; Infile datalines delimiter=','; Input ID Initial_Stafe $ Final_State $ Time; Datalines; 123,AA,BB,201701020923 123,BB,CC,201701020930 156,AA,AA,201701020910 163,AC,BC,201701031010 163,DD,CC,201701031010 163,BC,DD,201701031010 163,CC,BB,201701031010 170,BB,.,201701040930 ;

sleretrano · ‎10-28-2016

I'm sorry, I actually don't get that message. I did at some point get a similar one, but it's not the same and I don't get the rows with "NUMR" and "ZONE" behind. The similar message I got was because I formated a character variable as a number variable.

sleretrano · ‎10-28-2016

Nevermind, I had misread your reply. Let me get back to you.

sleretrano · ‎10-28-2016

I'm using SAS EG 5.1. The origin is UNIX, that's correct. I don't know what you mean with " last character shown by CHAR ZONE and NUMR", can you explain it to me, please?

sleretrano · ‎10-28-2016

I don't understand why you point out that it's not a semicolon delimited file, what is the relevance of that? I'm aware that some vars have characters, I can fix those. My issue is with the last variable. It doesn't work for me. I tried termstr=CR, termstr=CRLF and termstr=LF, nothing worked.

sleretrano · ‎10-28-2016

I do! Know how to fix it?

sleretrano · ‎10-28-2016

I'm trying to read from a UNIX file whose rows look like this: 42000001251100:137224761:123272858:+00000000000:+00000000000:+00000000000:+00000000000:+00000000000:+00000000000:+00000000000:+00000000000:+00000000000:+00000000000:DW7 :P:CP :+002296660:+00000005300:+00000598760:+00000132500:+00000132500:+00000000000:+00000250000: :00010101:ENC:20120314:ENC:20120215:0:502:00010101:20100914:20111027:+00000007300:119 Notice that after the last field there isn't a ':' delimiter. I checked in a text editor and there's no "end of line" (i.e. CRLF, CR, LF). When I read from the file, everything works fine except for the last variable which always comes out empty. It's not a lrecl issue, I've checked. I managed to fix this by doing the following: lrecl=500000 DLM=':' missover DSD; Input Var1-Var35 @350 Var36; As the last variable (the thirty sixth one) starts at the position 350. However I was looking for a more elegant solution. Any ideas? This a follow up from this question: https://communities.sas.com/t5/SAS-Enterprise-Guide/Reading-from-Unix/td-p/307696

sleretrano · ‎10-28-2016

Yes, it worked. I've always heard spaces are a bad idea, but I've never had an issue with them, to be honest.

sleretrano · ‎10-28-2016

No idea of what you're talking about. Can you please refer me to some intro to that? Thank you for everything.

sleretrano · ‎10-28-2016

FILENAME Name pipe "zcat sas-data/SAD/SAD/IFRS 9/BASES/File_name.Z"; Data Test; infile Name lrecl=500000 DLM=':' missover DSD; Input Var1-Var36; Run; The input statement was missing. The above fixes it.

sleretrano · ‎10-28-2016

17 data _null_; 18 infile name; 19 input; 20 put _infile_; 21 if _n_ > 10 then stop; 22 run; NOTE: The infile NAME is: Pipe command="zcat "/sas-data/SAD/SAD/IFRS9/BASES/File_name.Z" 2>&1" gzip: /sas-data/SAD/SAD/IFRS9/BASES/File_name.Z: No such file or directory NOTE: 1 record was read from the infile NAME. The minimum record length was 74. The maximum record length was 74. I managed to make it work, though. I was missing the input option. Should I post what worked for me as an answer or what?

sleretrano · ‎10-28-2016

I physically changed the path to remove the space and I tried FILENAME Name pipe 'zcat "/sas-data/SAD/SAD/IFRS9/BASES/File_name.Z"', but it still doesn't work. This particular line of code does run, it also ran in my original try, but when reading from the file it comes out empty. Any ideas?

sleretrano · ‎10-27-2016

Using EG 5.1. I'm trying to read from a compressed Unix file using the following code FILENAME Name pipe "zcat sas-data/SAD/SAD/IFRS 9/BASES/File_name.Z"; Data Test; infile Name lrecl=500000 DLM=':' missover DSD; label; Run; But the output comes out looking like this: Unziping the file and opening it directly, it looks like this: 42000001251100:137224761:123272858:+00000000000:+00000000000:+00000000000:+00000000000:+00000000000:+00000000000:+00000000000:+00000000000:+00000000000:+00000000000:DW7 :P:CP :+002296660:+00000005300:+00000598760:+00000132500:+00000132500:+00000000000:+00000250000: :00010101:ENC:20120314:ENC:20120215:0:502:00010101:20100914:20111027:+00000007300:119 42000002992100:176705643:184314704:+00000188769:+00000000000:+00000000000:+00000000000:+00000000000:+00000000000:+00000000000:+00000000000:+00000000000:+00000000000:PW7 :D:CP :+002123330:+00000008000:+00001768510:+00000200000:+00000200000:+00000001389:+00001566513:60:99991231:ENC:20150323:ENC:20150223:0:502:00010101:20141008:20130531:+00000005197:113 42000003721100:134284160:134284151:+00000138210:+00000000000:+00000000000:+00000000000:+00000000000:+00000000000:+00000000000:+00000000000:+00000000000:+00000000000:PW7 :D:CP :+002296660:+00000009000:+00001297485:+00000225000:+00000225000:+00000000970:+00000739335:68:20140114:ENC:20140704:RET:20140702:0:502:00010101:20121211:00010101:+00000000000:113 How can I make this work?

sleretrano · ‎09-07-2016

It did work, thanks. I hadn't thought of trying the most simple thing.

Online Status	Offline
Date Last Visited	‎01-18-2017 05:35 AM

Re: Ordering with respect to a custom order

Ordering with respect to a custom order

Re: Trouble reading the last variable from a colon delimited

Re: Trouble reading the last variable from a colon delimited

Re: Trouble reading the last variable from a colon delimited

Re: Trouble reading the last variable from a colon delimited

Re: Trouble reading the last variable from a colon delimited

Trouble reading the last variable from a colon delimited

Re: Reading from Unix

Re: Reading from Unix

Re: Changing default options on Describe>Summary Statistics

Re: Display variable properly (BESTw.d)

Re: Reading from Unix

Re: Changing default options on Describe>Summary Statistics

Re: Ordering with respect to a custom order

Ordering with respect to a custom order

Re: Trouble reading the last variable from a colon delimited

Re: Trouble reading the last variable from a colon delimited

Re: Trouble reading the last variable from a colon delimited

Re: Trouble reading the last variable from a colon delimited

Re: Trouble reading the last variable from a colon delimited

Trouble reading the last variable from a colon delimited

Re: Reading from Unix

Re: Reading from Unix

Re: Reading from Unix

Re: Reading from Unix

Re: Reading from Unix

Reading from Unix

Re: Turn macro variable into a number