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


Please Help Members By Posting Answers For Below Questions

What is program data vector (pdv) and what are its functions?

623


How would you define the end of a macro?

698


Give some examples where proc report’s defaults are same as proc print’s defaults?

637


What are the difference between ceil and floor functions in sas?

704


What is the difference between proportion and average?

2753






What are the automatic variables for macro? : sas-macro

672


What does proc print, and proc contents are used for?

609


what has been your most common programming mistake? : Sas programming

562


How to read an input file in sas?

652


What is the differnce between SDTM 3.1.2 to 3.1.1 version

4608


what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi

548


Explain the purpose of substr functions in sas programming.

561


Explain proc univariate?

604


What is the maximum length of the macro variable?

672


Tell me more about the parameters in macro? : sas-macro

584