I am getting error when I try yo connect to SSMS in server. I have successful ODBC connection. However, I get the following error. It looks like error is coming from two words in user. How to fix it?   libname mydblib odbc user=apple orange  password=XXXXXXXXXXXX dsn=sqlserver; ______ 22 ERROR: Libref MYDBLIB is not assigned. ERROR: Error in the LIBNAME statement. ERROR 22-7: Invalid option name orange. ... View more

I keep getting this error. I am not sure how to fix this.   ERROR:  Windows error code: 59 in hc_normal_write for I:\......sas7bdat.lck, An unexpected network error occurred. ... View more

I am getting  error message when I tried to load data into oracle table. is there a way to fix in SAS or needs to be  fixed in Oracle?   log:  WARNING: The following ERROR/WARNING is being ignored (due to ERRLIMIT option):          ERROR: ORACLE execute error: ORA-01438: value larger than specified precision allowed          for this column.          The number of ERROR/WARNINGs occurred so far: 1. WARNING: The following ERROR/WARNING is being ignored (due to ERRLIMIT option):          ERROR: ORACLE execute error: ORA-01426: numeric overflow.          The number of ERROR/WARNINGs occurred so far: 285. WARNING: The following ERROR/WARNING is being ignored (due to ERRLIMIT option):          ERROR: ORACLE execute error: ORA-01438: value larger than specified precision allowed          for this column.          The number of ERROR/WARNINGs occurred so far: 286. ... View more

how can I fix if there are zeros in b? I want to change b=1 when b=0 and run this code when b>0.    Code:  if (a < 1000 OR (a/b <.1 & c < 5000000 & d IN (0,.)) OR (a/b < .1 & c < 10000000 & d IN (0,.)) OR (a < 500000 & c < 5000000 & d IN (0,.)) OR (a < 1000000 & c < 10000000 & d IN (0,.))) then e = 1;   Log:   NOTE: Division by zero detected at line 1393 column 29. NOTE: Division by zero detected at line 1394 column 29. ... View more

Can somebody help me to convert this code to Data Step or Proc SQL?    SAS code:    data cd; set ab (rename=(x_ID=ID x_num=num x_year=year)); history_path = 0; if _n_ = 1 then do; length x_ID $9 x_num $3 x_year $4; declare hash vertices(dataset: 'work.ab'); rc = vertices.definekey('x_ID', 'x_num', 'x_year'); rc = vertices.definedata('history'); rc = vertices.definedone(); call missing(x_ID, x_num, x_year, history); length last_ID $9 last_num $3; declare hash edges(dataset: 'work.ac', multidata: 'yes'); rc = edges.definekey('x_ID', 'x_num', 'x_year'); rc = edges.definedata('last_ID', 'last_num'); rc = edges.definedone(); call missing(last_ID, last_num); end; run;   ... View more

I have date format 16-Oct in excel. How can I import in date format in SAS?    For example: data a; infile "&input.&data." delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ; informat date yymmdd6. ; format date yymmdd6. ; input date; run; This code  gives missing values in date column.   Thanks. ... View more

I have master data of 12 months. I am caluclating value of one varible based on previous months values. I have calculated Feb values based on Jan values. Now, I want to calculate March value based on Jan and New Feb values; April value based on Jan, New Feb, New March values and so on...The new monthly value has to go in master dataset everytime. I have to use updated master file everytime.  Can you please help me to write the loop?  ... View more