Search results for query: *

My report prints out 11 pages, when there is really only one. Only the 1st page has the header. I did as dhookum suggested for jckokko and looked at my report source, but that just told me the query the fields in the report were based upon. Are there any other suggestions or can you clarify...

OK, I feel silly. In my excitement I forget that I had a variable created closed_dt2 and it was just working. I'll have to play with this somemore to select the correct format because neither mmddyy8. nor mmddyy10. work but it's a good start!

Well I'll be damned. It worked! Thanks! It gave me 3 variables for closed_dt (closed_dt, closed_dtc and closed_dt2) which I didn't realize would happen but that's cool. All of the errors I was having are not gone. This worked really well! Thanks!

Hi Klaz, I greatly appreciate the advice, but I'm a little confused. When I import the file into SAS before I've done any coding SAS thinks the CLOSED_DT is a char variable. What would the code be to change the variable from a string to a number? When I try to do it directly using properties...

Hi, I've been having a hard time with my new computer system that's why I have all the posts. Anyway, I'm importing a .dbf using the import wizard and some of my date variables are being changed from datetime to character. This confuses sas when I run datasteps for coding. I attempted to...

Hi Klaz, I have my SAS through the CDC so they have a liscence that expires in 2050. And yes it is pretty cool. You were right it is the excel 4 worksheet. I exported it as a 2000 and the variable length worked alright. Thanks for the help!!

Hi klaz, thanks for the help. I did check my licenses and they don't expire until 2050 so I don't think that's it. It was a good idea though. I'm running V8.02 here are some examples of the code I'm running. LIBNAME SASSYPH 'H:\SAS Data Code'; %include 'H:\SAS Data Code\Morbidity...

When I run the datastep on a newly imported dataset the variable names are being truncated to 8 characters. The datastep requires the use of the full variable names and has always worked in the past without truncating the orginal variable names, but I'm on a new machine now. I attempted to use...

Hi, I have been unable to import any data into sas for a bit now. I've tried straight import code and the import wizard. Both have worked in the past. I get an error stating "Connection Failed. See log for details". This is in the log so there are no other details. Has anyone...

Hi all, I have two propotions that come from my data from year 1: a1/(a1+b1) and from year 2: a2/(a2+b2). I want to show that the proportion from year 2 is larger than the proportion from year 2 using a chisq. I would like to just put type in the numeric proportions in my statement because I...

Hey all. I'm doing some regular frequency distributions and my log gives me a warning right after a title statement. WARNING: Apparent symbolic reference S not resolved Anyone have any ideas what that means? The help was as usual no help. The proc seems to be working properly so it's not...

I'm a new access user. I'm working with a query someone else designed. Can anyone tell me what this would mean?: Expr1: [PLACES].ZIP One of the tables linked in the query is PLACES but it's not zipped. There are no parameters in that section of the query. When I attempt to run it access...