how can u import .csv file in to SAS?tell Syntax?
Answer Posted / 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 |
Post New Answer View All Answers
What is program data vector (pdv) and what are its functions?
How would you define the end of a macro?
Give some examples where proc report’s defaults are same as proc print’s defaults?
What are the difference between ceil and floor functions in sas?
What is the difference between proportion and average?
What are the automatic variables for macro? : sas-macro
What does proc print, and proc contents are used for?
what has been your most common programming mistake? : Sas programming
How to read an input file in sas?
What is the differnce between SDTM 3.1.2 to 3.1.1 version
what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi
Explain the purpose of substr functions in sas programming.
Explain proc univariate?
What is the maximum length of the macro variable?
Tell me more about the parameters in macro? : sas-macro