About ImPrasad

ImPrasad · ‎11-18-2015

Dear All, Currently I am using Sas 9.4 version.My system configuration is Intel(R) Core(TM) i5 processor 64 bit,16GB RAM. When I Insert ReadBuff option in libaname statement my session abruptly gets closed without any data extraction. Attached herewith the error message which gets generated before closing the session.Please provide me solution for the same. Thanks, prasad

ImPrasad · ‎10-19-2015

Currently we are using Sas 9.4 version.Intel(R) Core(TM) i5 processor 64 bit libname statemnt LIBNAME ORA ODBC DSN=XX UID=XXXXX PWD=XXX READBUFF = 32000;

ImPrasad · ‎10-19-2015

Dear All, We are facing an issue while exporting dataset to excel.Currently we are using Sas 9.4 version.Intel(R) Core(TM) i5 processor 64 bit . Below is the synatx and error message displayed in log Syntax: PROC EXPORT DATA=<Dataset> OUTFILE = "E:\CONTACTIBILITY_PRAMOD\REPORTS\abc\SHEET3P_BRANCH_REGIONWISE_REPORT_FINAL.XLSX" DBMS = EXCEL REPLACE; SHEET = "&CAT"; RUN; Log Mesage: ERROR: DBMS type EXCEL not valid for export. Same was working successfully when We were using 32 bit OS and Sas 9.2. Please suggest a solution. Thanks, Prasad Devasthali Hdfc Bank.

ImPrasad · ‎10-09-2015

Dear All, I use to extract data from server by using readbuff statement from system which was 32 bit and having sas 9.2. Now I have new system which is 64 bit and having sas 9.4. Library got assigned successfully but unable to extract data.Post running data ;set ; run;statement session gets hanged. Please suggest modifications required of any? Thanks, prasad

ImPrasad · ‎09-14-2015

I want to upload large data on server.Its a bimonthly activity data size is approx. 6 GB and it always take amount of time while loading through data set statement. Is there any wayout for the same??I have used Readbuff statement while downloading the data from server.Is there any option available for fast ulpoading of data??

ImPrasad · ‎09-14-2015

What is the wayout then??How could we upload data on server in batch mode?

ImPrasad · ‎09-14-2015

Hello Friends, I am a beginer in SAS.Recently I have checked the option READBUFF while DOWNLOADING the data from SERVER.Which really worked fanatastic. My questions are as below: 1)Do we have any option to upload the data on server from local machine through SAS. 2)Why I am unable to use readdbuff statement while assigning library on local machine . E.g. libname dc "D:\Prasad\DC" readbuff=32000; error message: 984 libname dc "D:\Prasad\DC" readbuff=32000; -------- 22 ERROR: Libname DC is not assigned. ERROR: Error in the LIBNAME statement. ERROR 22-7: Invalid option name READBUFF. Thanks, Prasad Devasthali Business Analyst HDFC Bank

ImPrasad · ‎08-07-2015

Very true data_null_;!!!Why should I write such dates in such nightmare formats...Anyways Cheers ...Happy Weekend Guyss!!

ImPrasad · ‎08-07-2015

Thanks andreas_lds..Thanks RW9...Your solutions resolved my problem...!!

ImPrasad · ‎08-07-2015

Thanks Xia,this option really helped me a lot to reduce TAT.However I am unable to increase value more than 32000 on my local system against ReadBuff value.My sas version is 9.3 and I am operating it through 32 Bit processor

ImPrasad · ‎08-07-2015

Hello Friends, I have character date in YYMM format.(Column Name EXPDATE) e.g. '2004' which means April 2020 '2104' which means April 2021 '2204' which means April 2022 '2304' which means April 2023 How to convert it into date format ? Being a beginner in SAS I googled the same and use below mentioned logic format exp date9.; Exp = intnx('month', input(put(EXPDATE,4.), yymmn4.), 1)-1; ; Which gives me output 30Apr1920 instead of 2020 and similarly for all remaining values where YY value is above 20. Please help me to resolve the same. Thanks, Prasad Devasthali Business Analyst,HDFC Bank

ImPrasad · ‎07-25-2015

Hello Everyone, Being Data Scientist,One of the prominent challenge is to extract data from server to local machine.Is there any way out to extract data from oracle server more speedy than traditional Data;Set;Run; Process. Majority data extraction for us are blanket extraction i.e. without applying any filter.Is there any bulk download process which wont read every line of the data and download all the files in batch mode. Ragards, Prasad Devasthali HDFC Bank

Online Status	Offline
Date Last Visited	‎02-22-2017 09:34 PM

ReadBuff SAS 9.4 (64 Bit) help

Re: ReadBuff SAS 9.4 (64 Bit)

Export SAS 9.4 (64 bit) into Excel

ReadBuff SAS 9.4 (64 Bit)

Re: How We can Upload data on server Quickly?

Re: How We can Upload data on server Quickly?

How We can Upload date on server Quickly?

Re: Convert character sas date to numeric

Re: Convert character sas date to numeric

Re: Batch Download from Oracle

Re: Convert character sas date to numeric

Re: Convert character sas date to numeric

ReadBuff SAS 9.4 (64 Bit) help

Re: ReadBuff SAS 9.4 (64 Bit)

Export SAS 9.4 (64 bit) into Excel

ReadBuff SAS 9.4 (64 Bit)

Re: How We can Upload data on server Quickly?

Re: How We can Upload data on server Quickly?

How We can Upload date on server Quickly?

Re: Convert character sas date to numeric

Re: Convert character sas date to numeric

Re: Batch Download from Oracle

Convert character sas date to numeric

Batch Download from Oracle