How can i read a flat file using pass through facility(not odbc)? Could any one help me in this regard. Regards, Sidhu ... View more

I had installed SAS Web Report Studio 2.1. I am able to view the login page of the sas web report studio url, but when I try to enter(login) by giving the credentials(tried with the sasadm, saswbadm,sastrust still not working) it is giving the error "error in the system configuration". Could you please tell me how to get rid of the error? Regards, Sidhu ... View more

I had installed SAS Web Report Studio 2.1. I am able to view the login page of the sas web report studio url, but when I try to enter(login) by giving the credentials(tried with the sasadm, saswbadm,sastrust still not working) it is giving the error "error in the system configuration". Could you please tell me how to get rid of the error? Regards, Sidhu ... View more

Can anyone help me out in getting the differences of Proc Means & Proc Summary other than the output difference? ... View more

Can anyone tell me what exactly is the difference between Proc Report and Proc Tabulate? ... View more

I am having a library, in that there are five datasets with five variables each and having only one observation.Out of five variables one variable is numeric. I want the data from all five datasets with a numeric variable. How can I do this using datastep or a macro without knowing whether a variable is numeric? Thanks in advance. Regards, Sidhu ... View more

SAS System Viewer 9.1 was able to open datasets that were created by V8 engine (SAS 8.2), but is unable to open datasets that are created with V9 engine (SAS 9.1.3). Does this need SAS System Viewer to be upgraded ? or Something else needs to be done ? ... View more

In SAS Intrnet application, we are encountering this error. Servers are getting crashed after processing only single request. Pool service was working very well till 29 Jan 2008, but suddenly this is happening. No sessions now and with each request a new server is started. Loadmgr log shows the error frequently: SET STATE patpool_v101 APPLICATION SERVER CRASH ... View more

SAS 9.1 import wizard is having problem with excel file imports, it works ok for .txt files. I was using the same files to work in SAS in Oct this year , it worked well. Now, I tried using both the import wizard and command line approach, same result. This is the sas log message which I get - 1 PROC IMPORT OUT= WORK.fam 2 DATAFILE= "C:\Documents and Settings\RU46493\Desktop\PD\LRRK2_11085.xls" 3 DBMS=EXCEL REPLACE; 4 SHEET="'G2019S-all$'"; 5 GETNAMES=YES; 6 MIXED=NO; 7 SCANTEXT=YES; 8 USEDATE=YES; 9 SCANTIME=YES; 10 RUN; ERROR: Connect:
ERROR: Error in the LIBNAME statement. Connection Failed. See log for details. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 1.54 seconds cpu time 0.17 seconds Also for some reason, after I reinstalled SAS ( thinking it might sort the problem )it has gone to - Expiration: 31DEC2005. Grace Period: 45 days (ending 14FEB2006). Warning Period: 45 days (ending 31MAR2006) ... View more

In a database called eTrack for the clinical study the last name has been entered as: last name = Castaño last name = Peña However, when i extract the dataset the name outputs as 'Casta?o' and 'Pe?a' in the sas dataset. ... View more

Can anyone tell me how to identify the outliers using sas and to calculate the measures of central tendency,measures of dipersion,normal distribution and hypothesis testing? ... View more

Hi, I have a Dataset A with the following ID SID CID IID INM A1 0 1 001 X A1 0 2 002 X A1 0 4 004 X A1 0 3 003 X I have another Dataset B with the following ID SID CID A1 421 4 A1 422 4 A1 121 1 A1 122 1 A1 123 1 A1 321 3 A1 221 2 I want to merge the Dataset A and Dataset B by CID and get the following output and the output order should be in the order of Dataset A.Look at the following output ID SID CID IID INM A1 121 1 001 X A1 122 1 001 X A1 123 1 001 X A1 221 2 002 X A1 421 4 004 X A1 422 4 004 X A1 321 3 003 X Can anyone help me in getting the above output using merge statement in SAS. Regards, Siddhartha ... View more

I had merged the two datasets using the by variable and before merging I had sorted the datasets uisng proc sort: Can anyone tell me the code so that observations should be in the previous order as in the base datasets,using the merge statement. ... View more

Hi, Iam having the below requirement. Can anyone help me how to write the code for the below logic using SAS. A macro will be written which will scramble the digits. Following are the replacements for each digit 1 is replaced as 3 2 is replaced as 5 3 is replaced as 1 4 is replaced as 6 5 is replaced as 4 6 is replaced as 8 7 is replaced as 0 8 is replaced as 9 9 is replaced as 2 0 is replaced as 7 For e.g. 2456 7890 will be scrambled to 5648 0927. And also the Rules are as follows: a) For V Accounts first 4 and last 2 digits are fixed. The remaining digits need to be scrambled. For example 45361234 12341299 is replaced as 4536351635163599 b) For Sc card accounts, first 4 digits are fixed. For example 4536 1234 1234 1299 is replaced as 4536 3516 3516 3522 c) For all other accounts keep first 5 digits and last 2 fixed. The remaining digits need to be scrambled. For example 9000 1123 4567 8999 replaced 9000135164809299 Regards, Siddhartha ... View more

can anyone tell me what exactly the difference between proc sql and sql pass through facility? ... View more