I tried to connect SAS Management Console via cygwin with the below command, but I couldn't connect. Looks like my pc ( BASD-LT-PBK0RTX ) is refusing the connection It was working up to a few weeks ago, then it hasn't worked since /data/SAS_93/SASManagementConsole/9.3/ >./sasmc connect BASD-LT-PBK0RTX port 6000: Connection refused /data/SAS_93/SASManagementConsole/9.3/ > Any likely cause for the error to troubleshoot? Thanks. ... View more

I've used below code to import CSV file, but am getting error as shown below despite using macro statements %SYSMSTORECLEAR; . Any help is really appreciated. I'm using SAS EG 5.1. %SYSMSTORECLEAR; dm 'list;clear;log;clear;';     %PUT %SYSFUNC(GETOPTION(SASAUTOS)); filename _all_ clear;                                                                                                                         libname  _all_ clear;                                                                                                                                                                                                                                                                       proc delete data=work._all_;                                                                                                                 run;                                                                                                                                                                                                                                                                                       filename inf "/data/rawdata_cu/SA/SHOPPER_3-28-2014_cass.csv" lrecl=32767 termstr=crlf;  proc import datafile=inf out=rawdata dbms=csv replace;                                                                                            guessingrows=10000000;                                                                                                                   run; Log: 14         GOPTIONS ACCESSIBLE; 15          %SYSMSTORECLEAR; 16         dm 'list;clear;log;clear;'; 17          %PUT %SYSFUNC(GETOPTION(SASAUTOS)); ( "SASEnvironment/SASMacro" '!SASROOT/sasautos' ) 18         filename _all_ clear; NOTE: Fileref INF has been deassigned. ERROR: At least one file associated with fileref FILDES08 is still in use. ERROR: Error in the FILENAME statement. 19         libname  _all_ clear; NOTE: Libref IN has been deassigned. 21         proc delete data=work._all_; 22         run; NOTE: PROCEDURE DELETE used (Total process time):       real time           0.00 seconds       cpu time            0.00 seconds       24         filename inf "/data/rawdata_cu/SA/SHOPPER_3-28-2014_cass.csv" lrecl=32767 termstr=crlf; 25         libname  in  "/data/PROD_CODES/CCU"; NOTE: Libref IN was successfully assigned as follows:       Engine:        V9       Physical Name: /data/PROD_CODES/CyprusCU        ... View more

I need help on proc tranpose. My data is as below. cust     account         balance Smith  checking        $1,000.00 Smith  Savings        $4,000.00 Smith  mortgage      $150,000.00 Smith  credit_card    $500.00 Jones  checking       $973.78 Jones  savings         $2,613 Jones  Mortgage      . Jones  credit_card   $140.48 I need to convert as below. I did tried, but trouble displaying the varaibles as below.So I request someone to suggest me here. cust   checking   saving         mortgage       credit_card smith $1,000.00  $4,000.00  $150,000.00  $500.00 Jones $973.78   $2,613         .                   $140.48 On a seperate note, I need to find a correlation between each account (between checking and saving, mortgage and credit card etc) to find out which is sold more. In that case, is that possible to apply proc corr between the accounts? ... View more

I do services for banking and I need help to find the correlation between two variables. Interestingly I need to do with character variables and below are the sample data. Our task is to sell loan products. Eg: many occasions people who brought mortgage loan is likely to buy auto loan. Similarly I need to identify the loan products which has correlation. product_dsc    loan_amt AUTO LOAN       26,698.65 AUTO LOAN       15,000.00 AUTO LOAN     15,200.00 Used Auto        7,194.00 Personal loan   1,000.00 Used Auto     23,000.00 Used Auto    12,400.00 Any help would be really appreciated. ... View more