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 are pdv and it functions?

759


what are all the reports you generated in your recent project?

1925


Which statement does not perform automatic conversions in comparisons?

1432


Can you suggest us materials for sdtm mapping?

4232


What are the statements that are executed only?

883


describe about metadata object? : Sas-di

809


How can you create a macro variable with in data step? : sas-macro

765


what type of graphs we will create(for 2+years candidates)?

2076


name some data transformation used in sas di? : Sas-di

731


What is the general format of function in sas? : sas-grid-administration

757


what is sas data set?

855


Where do you use proc means over proc freq?

747


what is data governance? : Sas-di

783


What is the length assigned to the target variable by the scan function?

887


explain the proc in sas? : Sas-administrator

816