About jerry898969

jerry898969 · ‎06-17-2016

Thank you Chris. I'm going through the above solutions now. The reason I can't do that is that I will be joining them based on this value to another table that is coming from someone else and they only add the zero when the count is greater then 9. Thanks again. I'll reply back and accept the solution as soon as I get it resolved. Thank you

jerry898969 · ‎06-17-2016

Hello, I have a situation where I have data like this X_1 X_2 X_3 X_4 X_5 Z_1 Z_2 Z_3 Z_4 Z_5 Z_6 Z_7 Z_8 Z_9 Z_10 Z_11 Where the data has a value over 9 I need 1-9 to have a leading zero. Based on the above data I need this to happen X_1 X_2 X_3 X_4 X_5 Z_01 Z_02 Z_03 Z_04 Z_05 Z_06 Z_07 Z_08 Z_09 Z_10 Z_11 Here is the code I'm starting to work with. This column of data can have values with no '_' or and '_' with characters after. I only want to do this for values where there are numbers after the '_'. data x ; set temp ; start = scan(val, 1, '_') ; end = scan(val, 2, '_') ; if end ne '' and ANYALPHA(end) = 0 then output ; run ; Thank you for any help you can give me.

jerry898969 · ‎04-22-2016

Thank you both for your replies. FreelanceReinhard, your solution seems to have worked perfectly. I'm doing some testing on it now, but it looks good. Thank you

jerry898969 · ‎04-21-2016

It's not as consistant as I would like. I think I have to do it post processing. At least to start. Is there a way to check ahead to see if the next row is blank then I could output at that point? Thank you

jerry898969 · ‎04-21-2016

Thank you for the reply. I was doing this in my table after I brought the data in. I bring it in as it is in the text file. The pattern I found was that in some cases there are 1 or 2 lines that make up the line and each are followed by a blank row. I have used the retain statement and this code which seems to be working, but I'm having a hard time when to output the row once they are concatenated. data raw_ ; length temp $400; set raw(firstobs=8) ; retain temp ; if text eq '' then temp = '' ; if text ne '' then do ; if length(temp) = 1 then temp = text ; else do ; temp = catx(' ', temp, text) ; end ; end ; run ; Is it recommended to try and do this check on import? The reason I just bring in each line as it's own row is to allow me to use SAS to break the data up. This process will run multiple times with different data. Thank you.

jerry898969 · ‎04-21-2016

Hello, I have a text file that i'm importing into a sas table and that part works correctly. What I'm trying to do is create one line of data when the data is on 2 lines. For example The data I want starts on row 8. Everything below that is either 1 or 2 rows with a blank row inbetween the data. Feb 15, 2012. Testing how data is working. www.test.com Mar 16, 2013 Fake book entry. www.book.com Jan 02, 2011 Test title. Frank Testing www.titlestore.com What I need the data in my table to look like: Feb 15, 2012. Testing how data is working. www.test.com Mar 16, 2013 Fake book entry. www.book.com Jan 02, 2011 Test title. Frank Testing. www.titlestore.com Thank you

jerry898969 · ‎04-08-2016

Thank you Kurt, That is what I need. I need the modification timestamp from a directory listing. Thanks

jerry898969 · ‎04-06-2016

Thank you everyone. The date on the sad file will be used to compare to the same set of files in our archive and production data. We use the creation date to let us compare to make sure we have the latest file and if not we know we have to do a release.

jerry898969 · ‎04-06-2016

Hello, I'm trying to get the create and modified dates from a directory listing using filename and pipe. filename dump pipe "dir ""&&folder&i..\&&filename&i..*.*"" /b " ; This is the line that I'm doing to pull all the files that start with a specific file name. This returnes all the file names, but no other information. I know it has something to do with "/b" but I'm unable to find a good descripiton of the different modifiers. I'm guessing it will add the dates along with the name in one character field, correct?

jerry898969 · ‎03-31-2016

I'm doing that check in the data table before I use data_null_'s code. So it will eleminate any blank rows. Thanks for pointing that out.

jerry898969 · ‎03-31-2016

We have a site where users can put in code as if it was a where condition. I want to pull out all the special characters by ID and then I'm going to roll them up into a count to see how many special characters are used. Then I can investigate what special characters are causing issues and exclude them from being used. This is the steps my lead has asked me to take. Thank you to all who replied.

jerry898969 · ‎03-31-2016

Thanks data_null_. That worked perfect for me.

jerry898969 · ‎03-31-2016

Hello, I have a situation where I'm trying to track some user entered data. They can enter data into a field on my website. I have compressed all letters and numbers and now want to take the special characters and create a table with 1 row per character with the id. For example id=1 text='(+)' id=2 text='(=)(=)' I need to create a table that will have the following data&colon; id=1 specChar= '(' id=1 specChar= '+' id=1 specChar= ')' id=2 specChar= '(' id=2 specChar= '=' id=2 specChar= ')' id=2 specChar= '(' id=2 specChar= '=' id=2 specChar= ')' I was looking a using a loop with substr, but I can't figure out how the syntax would be.

jerry898969 · ‎09-18-2015

I like that approach better. I like that it is all in one data step. Thank you again

jerry898969 · ‎09-17-2015

Thank you ballardw. I'm using guessingrows=2147483647. This is the issue that is causing me the trouble Say I have the following data to import id,empid,officeid,bldg,keyid,elevtor "fsslk9493",2,,"West","", What I need is for the variables to have the following data types id = character(9) empid = numeric 8 officeid = numeric 8 bldg = character(4) keyid = character(1) elevtor = numeric 8 What is currently happening is the following: id = character(9) empid = numeric 8 officeid = character(1) bldg = character(4) keyid = character(1) elevtor = character(1) Thank you

Online Status	Offline
Date Last Visited	‎05-17-2021 12:05 PM

ODS PDF knowing how many rows before page break

Re: Proc GINSIDE Optimization

Re: Two-way freq doesn't show the variable names when displayed

Re: Two-way freq doesn't show the variable names when displayed

Two-way freq doesn't show the variable names when displayed

Re: Use different select value in proc sql based on variable

Use different select value in proc sql based on variable

Re: Right arrow character causes problems only when logging with proc ...

Right arrow character causes problems only when logging with proc prin...

Re: Break up string using count function and how to loop through it

Re: seach text file based on obs in data table

Re: create data rows depending on value in column

Re: create data rows depending on value in column

Re: Add leading zero based on the number of numbers for that value

Re: Add leading zero based on the number of numbers for that value

Creating Macro variables based on min max of id field

Creating Macro variables based on min max of id field

ODS PDF knowing how many rows before page break

Re: Two-way freq doesn't show the variable names when displayed

How to check if server is configured as a unicode server

Re: Add leading zero based on the number of numbers for that value

Add leading zero based on the number of numbers for that value

Re: Working with text file with blank rows between fields

Re: Working with text file with blank rows between fields

Re: Working with text file with blank rows between fields

Working with text file with blank rows between fields

Re: Getting create and modified dates from directory listing

Re: Getting create and modified dates from directory listing

Getting create and modified dates from directory listing

Re: How to create new row for each character in each row of my variabl...

Re: How to create new row for each character in each row of my variabl...

Re: How to create new row for each character in each row of my variabl...

How to create new row for each character in each row of my variable

Re: Import text file with string longer than 32767

Re: Import within Enterprise Guide giving incorrect data types