About DrNO811

DrNO811 · ‎02-06-2014

I was attempting to use the query builder to get a two column summary table that showed the first column as the Age Group for my observations, and the second column being the number of times each age group shows up in the data. Here was the code the query builder created: PROC SQL; CREATE TABLE WORK.QUERY_FOR_CUMULATIVE_W_AGEGROUP AS SELECT t1.AgeGroup, (Count(t1.AgeGroup)) AS COUNT_of_AgeGroup FROM WORK.CUMULATIVE_W_AGEGROUP t1 GROUP BY t1.AgeGroup; QUIT; But when I run this code, the counts aren't correct. I can't figure out what it is trying to count, but they add up to 1,000. I have over 2 million rows, and I checked the table it calls, and every row has an entry, so I'm not sure why the count is off. I was able to get at the information using the summary table tools, but this technique is going to be important for me to use in other calculations. Any thoughts on what's causing it not to work as expected?

DrNO811 · ‎02-06-2014

Is there a way to do that using the "INFILE" function to pull in a .txt file rather than using cards? The format of the data is very similar to the sample you show in the cards, but it's hundreds of pages long.

DrNO811 · ‎02-05-2014

There is some variation, but it's predictable, such as "5" is always the first character in a line that include a header, but "5" is also the first character in the line that includes the date. I think for purposes of this example, assuming that all lines with data have a blank, and all lines without data (including the headers and the date that I want to include in the table) have the character "5" as the first character in their row in the text file.

DrNO811 · ‎02-05-2014

Unfortunately, I can't share the actual data since it's proprietary, but I dummied up the example above with similar field types to be able to answer my question. The time field above is in MMMM:SS format similar to how a runner's time might look if they didn't use an hour field. In case it's relevant, the actual field I'm using is in HHHH:MM format. All other fields that I am using in the input are text except for the date field I want to include.

DrNO811 · ‎02-05-2014

I should've also mentioned: Every row that is not a data row has a number in the first character of each row to denote that it's a header row. I figured that piece could be helpful for the logic needed to sort this mess out. I appreciate any ideas you might have!

DrNO811 · ‎02-05-2014

I'm new to SAS programming, and have been struggling to figure out how to write the code to import a .txt file into a useful format. The .txt file has hundreds of pages and each page reprints the header information. The date of the text file is in the header, and I would like to put that in the data table. I've done some searches and found bits of code that would help with some parts, but haven't been able to put it all together. Could anyone show me some code that could turn something that looks like this: TITLE SUBTITLE DATE: 02/01/2014 NAME RUNNERID TIME Bob Smith 48739 0300:48 Nick Jones 48372 0289:57 ... into this: DATE NAME RUNNERID TIME 02/01/2014 Bob Smith 48739 0300:48 02/01/2014 Nick Jones 48372 0289:57 ... Keeping in mind that there are many pages of this with the Title repeated at the top, and I only need the raw data with the date column added?

SAS Enterprise Guide 4.3 Query Builder: Simple Count

Re: New to SAS programming; help with data import

Re: New to SAS programming; help with data import

Re: New to SAS programming; help with data import

Re: New to SAS programming; help with data import

New to SAS programming; help with data import