I'm sorry this is possibly a silly question, but I've always had IT people to set this up for me.    I'm trying to connect SAS to an ODBC server.  I have both a user DSN and system DSN working.   I can access the tables in Oracle SQL Developer.  However, and I don't know if this is relevant, but in the navigating pane to the left, where there is a sort of 'drop down file structure', the tables are located:  server_name/other_users/libraries/table(s).  As far as SAS code to access those tables, this is as far as I've gotten:    libname my_library odbc user=username password="password" datasrc=server_name;   This creates a library, but with no tables.    I don't know what other commands or info I am missing, but recognize many people used a schema and I do not know what that is.  Can anyone please help?    Thanks in advance!     ... View more

The tests are for different questions.   Depending on the type of chi-square test, you are probably only testing if there are significant proportional differences across the eight (2x4) categories simultaneously.  So you might get significance, for example, if any 2 combinations of categories is has a smaller N than each of the the other six combinations of categories.   Proc glimmix with the multinomial option will test if your binary predictor is significantly better at predicting each of three of your outcome categories relative to a fourth outcome (reference) category.  So here the question is if your binary predictor is associated with a significantly higher or lower probability of being being in one, two, or three of your outcome categories compared to its probability of being in the fourth reference outcome category. ... View more

I'm working with a datetime variable, but I want to reduce it to at least a day/month/year variable, or preferably monthyear, so that I can then select only distinct cases of the reduced format.  Basically, I want to recode the dates into season/year variables for many observations.  However, the datepart() function doesn't seem to be working for me.    The code I'm using is this, where raisedate is the original date variable:    data want; data have; datetime = raisedate; format datetime dateampm.; datejulian = raisedate; format datejulian julian.; date = datepart(raisedate); run;   Produces this:    id raisedate datetime datejulian datepart 1 21AUG2014 01JAN60:05:32:36 AM 14233 0 2 27APR2017 01JAN60:05:48:56 AM 17117 0 3 21AUG2014 01JAN60:05:32:36 AM 14233 0 4 21AUG2014 01JAN60:05:32:36 AM 14233 0 5 21AUG2014 01JAN60:05:32:36 AM 14233 0 6 21AUG2014 01JAN60:05:32:36 AM 14233 0 7 21AUG2014 01JAN60:05:32:36 AM 14233 0 8 21AUG2014 01JAN60:05:32:36 AM 14233 0 9 12MAR2019 01JAN60:06:00:20 AM 19071 0 10 26APR2019 01JAN60:06:01:05 AM 19116 0   So, for some reason I can reformat the date time, but the datepart() function isn't working.  Perhaps related to this issue, is that if I select distinct on the raisedate variable (i.e. without an id variable), I still get multiple indistinct entries, such as from above, even with the various formats broken out:    21AUG2014 01JAN60:05:32:36 AM 14233 0 21AUG2014 01JAN60:05:32:36 AM 14233 0 21AUG2014 01JAN60:05:32:36 AM 14233 0 21AUG2014 01JAN60:05:32:36 AM 14233 0 21AUG2014 01JAN60:05:32:36 AM 14233 0 21AUG2014 01JAN60:05:32:36 AM 14233 0   Clearly, they are not obviously distinct depending on format.  I've ran into issues with lack of rounding hidden from user view before in SAS, but I'm not sure if that's the issue here, or how I would "round" a date to resolve it.    Any recommendations for what to do?  Many thanks! ... View more