I recently got a new computer and I had to set up a new ODBC connection to SQL server so I can do sql queries in SAS.  The ODBC connection has been configured, tested and is working. However, I am getting the following message every time I try a program.   ERROR: The TXEVER engine cannot be found. ERROR: A Connection to the TxEVER DBMS is not currently supported, or is not installed at your site.   I haven't changed anything in the query or connection string (see below).  Any suggestions?     %let username = vfarinelli514 ; %let passwrd = XXXXXXX ; proc sql ; connect to odbc as TxEVER (datasrc=TxEVER user=&username password= &passwrd ); create table work.testtable as select * from connection to TxEVER (Select * from [database]);  quit; ... View more

Hello Everyone   Probably another simple question but I am stuck.    I have a data set that looks something like the following: id fabric color location price fiveormore 1 blue store   $   4.99 no 2 black warehouse  $   6.00 yes 3 red warehouse  $   2.00 no 4 blue store   $  10.00 yes 5 black store   $   7.50 yes 6 red warehouse  $  10.00 yes 7 blue store   $   5.00 yes 8 black warehouse  $   3.00 no 9 red store   $   1.00 no 10 blue store   $   5.00 yes What I am trying to tabulate the count of each color that are say $5.00 or more per location which I can do pretty easily but I need another column that is the percentage of the grand total of the color regardless of location.   Something like:   Store   Warehouse   color count % count % Blue 3 75.0 0 0 Black 1 33.3 1 33.3 Red 0 0 1 33.3       I have done something like below but, obviously, it is not really giving me what I want.   PROC FORMAT; picture pctf (round) other='09.9'; RUN;   proc tabulate data = birth.lowbirthweight17; class color location; table county, location*(n=' ' pctn<color>*f=pctf.); where fiveormore = 'Yes';  run;   I just can't quite figure out how to do it.  Any help would be greatly appreciated.     ... View more

Good Morning   I am new to SAS but have quite a bit of experience with SQL (Oracle and SQL Server).   I have two datasets that I am trying to merge together, but one has a couple of additional variables.   The first something like id name street city state 1 aaa 111 cityname xx 2 bbb 222 cityname xx 3 ccc 333 cityname xx 4 ddd 444 cityname xx   The second something like: id name street apt city county state 5 eee 555 #313 cityname countyname xx 6 fff 666   cityname countyname xx 7 ggg 777 #a cityname countyname xx 8 hh 888   cityname countyname xx   And this is what I want: id name street apt city county state 1 aaa 111   cityname   xx 2 bbb 222   cityname   xx 3 ccc 333   cityname   xx 4 ddd 444   cityname   xx 5 eee 555 #313 cityname countyname xx 6 fff 666   cityname countyname xx 7 ggg 777 #a cityname countyname xx   I can do it in proc sql (union accounting for the creating the new variables in the first table) but I was wondering if there is a simpler way with native SAS code.   I have read a lot but can't find a solution.  This may be sort of duh 101 stuff so my apologies for my ignorance in advance. 😁    Thanks! ... View more