Interested to Buy Any Domain ? << Click Here >> for more details...
how can u import .csv file in to SAS?tell Syntax?
- 7 Answers
- 32549 Views
- CitiGroup, Franklin Templeton, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / enr
To create csv file,we have to open notepad.then ,declaring
the variables.then save the file.like enr.csv
SYNTAX: proc import datafile='external file'
out=<dataset name> dbms=csv replace;
getnames=yes;
proc print data=<dataset name>
run;
eg:proc import datafile='E:\enr.csv'
out=sai
dbms=csv replace;
getnames=yes;
proc print data=sai;
run;
| Is This Answer Correct ? | 32 Yes | 2 No |
Answer / chiranjeevi
retreving the data we can use import&infile also.
import:
proc import datafile='external file'
out=<dataset name> dbms=csv replace;
getnames=yes;
proc print data=<dataset name>
run;
infile:
data code;
infile'C:\Documents and Settings\admin\Desktop\chiru.csv';
input<variable list>;
run;
| Is This Answer Correct ? | 13 Yes | 1 No |
Answer / shruthi
data DatasetName(drop = If any);
infile 'Path\CSVFileName.csv' delimiter = ',' ;
informat Var1 $2.;
informat Var2 anydtdte21.;
format Var1 $2.;
format Var2 anydtdte21.;
Input
Var1 $
Var2 $;
run;
| Is This Answer Correct ? | 14 Yes | 7 No |
Answer / rajamohan
proc import datafile="externalfile location" out=library.datasetname dbms=csv repalce;
getname=yes;
run;
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / ganesh
by using proc import or through wizard select import data
from file menu and infile statement.
proc import datafile='c:\my .csv' out =gan;
run;
| Is This Answer Correct ? | 7 Yes | 10 No |
Answer / dupe bassey
You can also use an
ods html file ='c:\user\new.xls';
proc print data=new;
run;
ods html close;
something along those lines
| Is This Answer Correct ? | 1 Yes | 19 No |
What is _n_?
What are the ways in which macro variables can be created in sas programming?
AE datasets names? how many types?
In SAS how to read the variable values having different formats. eg:mar99,mar1999 (in a single variable)
8 Answers GSK GlaxoSmithKline,
what is the usage for assigning error=1 in a dataset ?
WHAT IS DEBUGGING? HOW TO TEST THE DEBUGGING IN SAS?
what is pdv? how it is related to input buffer in sas?
how are numeric and character missing values represented internally? : Sas programming
Are you involved in writing the inferential analysis plan? Tables specfications?
which features do you use to check the data validations and errors? : Sas-administrator
What is the significance of the ‘OF’ in X=SUM (OF a1-a4, a6, a9);?
What is the difference between INPUT and INFILE ?
Teradata 
