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

Which statement does not perform automatic conversions in comparisons?

1205


How to include or exclude specific variables in a data set?

648


How do dates work in sas?

648


What are the parameters of scan function?

622


What is the use of stop statement?

647






Which date function advances a date, time or datetime value by a given interval?

672


What commands are used in the case of including or excluding any specific variables in the data set?

596


what are the categories that sas informats are used to the place the data? : Sas-administrator

616


Mention what is the difference between nodupkey and nodup options?

597


What are the new features included in the new version of SAS Programming Language?

741


what are validation tools that are used in sas? : Sas-administrator

593


how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming

603


what is sas and what are the functions? : Sas-administrator

544


Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?

1470


where are dashboard components are created and maintained? : Sas-bi

570