Hi, I have 6 excel files in one folder ex: c:/data.....I want to import all those files into SAS. Can somebody help me with the code,how can i do it with programming,instead of importing each file. one more thing,is there anyway we can import(only one file which is added to that folder later using program). Please somebody help me. Thanks, brm ... View more

Hi, I'm working on Environment where we have connection to the database from sas server.We are using EG 4.2 to access those database files. I'm running below query,it is running since 40 min.I have million records to process. select fs.sender_name "Specialty Pharmacy", pat.drc_case_id "DRC CASE ID", ship.most_recent_ship_date "Milestone_Date", ship.ndc_nbr "Product", 'Ship' as "Milestone_Type" bi.num_of_days_supplied "Days of Therapy" from cld_account_cooked acct, cld_benefit_cooked bi, received_files rf, cload.file_senders fs, cld_patient_cooked pat left join cld_detail_cooked ship on ship.cld_patient_cooked_id = pat.cld_patient_cooked_id where rf.file_date_of_report >= '01-Jan-2010' and fs.sender_name = 'SDI CuraScript' and rf.received_file_id = pat.received_file_id and acct.cld_account_cooked_id = pat.cld_account_cooked_id and bi.cld_patient_cooked_id = pat.cld_patient_cooked_id and fs.file_sender_id = rf.file_sender_id) Could somebody suggest me what i can do to improve performance. Thanks, brm. ... View more

Hi, I trying to keep duplicate records in sepate dataset.I' doing it like this,but having problem with large data.Can anybody suggest how can i do this in other way. proc freq data = b noprint ; /*by DRC_CASE_ID Milestone_Date Product MILESTONE_TYPE ;*/ table DRC_CASE_ID*Milestone_Date*Product*MILESTONE_TYPE*DAYS_OF_THERAPY / out = test18(drop=percent where = (Count >1)); run; ERROR: The requested table is too large to process. NOTE: The SAS System stopped processing this step because of errors. NOTE: There were 219548 observations read from the data set WORK.B. Thanks, brm ... View more

I'm trying to store all distinct records in a macro variable. Proc sql noprint ; select distinct DRC_CASE_ID into : tempids separated by ',' from c; quit; Getting below error,how can i do it using sas 15 Proc sql; 16 select distinct DRC_CASE_ID into : tempids separated by ',' from c; ERROR: The length of the value of the macro variable TEMPIDS (79271) exceeds the maximum length (65534). The value has been truncated to 65534 characters. 17 quit; ... View more

Hi, I'm a beginner learning EG 4.2...I finished Chapter 1 & 2 from Little SAS Book...Trying to do Chapter 3,there they are mentioning about volcano data table... How should i create that table..If anybody have that sample file pls send me. Thanks, brm ... View more

Hi, If One coloum is missing,then i want to delete all the records under that id. How can i do this using query analyser in EG.Thanks in advance brm ... View more