how can u import .csv file in to SAS?tell Syntax?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you execute a macro within a macro? Describe. : sas-macro

853


How do dates work in SAS data?

896


what is the difference between infile and input? : Sas-administrator

833


What are the differences between sum function and using “+” operator?

788


what r the job openings SAS for fresher graduates !

2185


what are some good sas programming practices for processing very large data sets? : Sas programming

705


How to create an external dataset with sas code?

785


Name and describe few sas character functions that are used for data cleaning in brief.

865


what do the pad and dim functions do? : Sas programming

775


what are informats in sas? : Sas-administrator

771


What is data _null_?

886


how does sas handle missing values in a merge? : Sas programming

761


What do you know about sas data set?

797


how to change the execute of macro

1904


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

889