Interested to Buy Any Domain ? << Click Here >> for more details...
how can u import .csv file in to SAS?tell Syntax?
- 7 Answers
- 32582 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 |
Why and when do you use proc sql?
How do you connect the desktop application to metadata server? : sas-grid-administration
What is your weekness? I am confuse what to say about this question. so can u give some answer which can be yur strenght.
who is the best SAS clinical Trainer in Hyderabad?
What is _n_?
if i having variables named a b c d e f ,how to find total of each variable ????give syntax...??
Can anyone help me about SAS Realtime scenarios in Clinical field
How would you define the end of a macro? : sas-macro
What are the functions done while Compilation...?
what is business intelligence? : Sas-bi
How can a SAS WEB REPORT STUDIO USER identify which report tabs they have been permitted without entering the SAS WEB REPORT STUDIO
why is sas considered self-documenting? : Sas programming
Teradata 
