About RamKumar

RamKumar · ‎03-05-2015

what the following line will do in your program? %if %sysfunc(exist(&dsname)) %then &dsname ;

RamKumar · ‎03-05-2015

can we create a dataset with first few observations instead of reading it in log?

RamKumar · ‎03-05-2015

I got it. Thanks.

RamKumar · ‎03-05-2015

Any shortcut keys available in EG 7.1 to copy\paste the SAS dataset to Excel along with variable names? I don't wish to export the dataset every time.

RamKumar · ‎03-05-2015

If you really have no idea what is in the file then read the first few lines and look at them - how to read first few lines in SAS?

RamKumar · ‎03-04-2015

Is SAS running on the same UNIX machine, or do you read the file over the network? Yes, SAS running on UNIX server. I've used my proc import in SAS EG. I could see a difference after I put a compress option and trimming one zero's from guessing zeros as Gergely suggests.

RamKumar · ‎03-04-2015

How much time does it take to simply copy this file with operating system command? It takes only 5-7 seconds to copy a file in UNIX box. I did this using cp command.

RamKumar · ‎03-04-2015

Even reading the .csv file is also time consumes. I used to get warning message like 'File not loaded completely' when I try to open large volume file. I don't know the field attributes without reading the file though. Any other suggestions?

RamKumar · ‎03-04-2015

What is the best way to import the .csv effectively with less time consumption? I've several thousands of records in my .CSV and I used to import the file as follows. If the file is large (say 200 MB) it is taking hours to complete. Can it be complete in minutes by tweaking the import process? filename rawdata "/data/04001_Compa_12312014.csv" termstr=crlf lrecl=32760; proc import datafile=rawdata out=rawdata1 dbms=csv replace; guessingrows=3000000; run; Thanks in advance for your inputs.

RamKumar · ‎03-04-2015

Try this. data have; input accid $; datalines; abc abc def abc xyz def run; proc sort data=have; by accid; run; data want (rename=count=uniqid); set have; by accid; if first.accid then count+1; else count=count; run;

RamKumar · ‎02-19-2015

Just I want to know what does factor value says?

RamKumar · ‎02-18-2015

Thanks. Where that 'e' comes from?

RamKumar · ‎02-18-2015

Any helpful answers?

RamKumar · ‎02-18-2015

I understood residuals now. How does an error term exists in the model? May I request you to give an simple example please.

RamKumar · ‎02-18-2015

What is the difference between error term and residuals in modeling?

Online Status	Offline
Date Last Visited	‎09-07-2018 06:08 AM

Case Study with SAS Campaign Management

Sum and Group by

Time Series Analysis in Banking sector

Data reporting for decline in sales

Re: Reading a list of files and conditionally export the files

Read the file names and create a dataset

Re: Parameterized Job

Re: Parameterized Job

Re: Parameterized Job

Re: Proc SQL Explicit pass through and Memsize

Re: Data reporting for decline in sales

Re: Do loops not sure if I am using the right step

Re: how to import excel with headings

Re: how to import excel with headings

Re: first. and last.

Re: Proc SQL Substring

Re: problem with proc import

Re: how to stack variables in different columns?

Re: How to give unique id to group of similar values in a column?

Re: Create Multiple Files Conditionally

Re: Appending multiple datasets using macro

Re: Effective way to import huge CSV file

Re: Shortcut keys to copy the SAS dataset with variable names in Excel...

Shortcut keys to copy the SAS dataset with variable names in Excel.

Re: Effective way to import huge CSV file

Re: Effective way to import huge CSV file

Re: Effective way to import huge CSV file

Re: Effective way to import huge CSV file

Effective way to import huge CSV file

Re: How to give unique id to group of similar values in a column?

Re: Proc Factor - Factor Value

Re: Error term and Residuals

Re: Proc Factor - Factor Value

Re: Error term and Residuals

Error term and Residuals