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

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

603


why is sas data integration studio important? : Sas-di

557


Did you used proc test? when?

1573


What will calendar procedure do?

593


Enlist the functions performed by sas.

672






What are the best sas programming practices for handling very large datasets? : sas-grid-administration

562


What is substr function?

622


Explain the use of proc print and proc contents?

554


what is star schema? : Sas-di

638


what is snowflake schema? : Sas-di

693


what are the benefits of data integration? : Sas-di

535


how does sas handle missing values in functions? : Sas programming

597


Explain proc sort?

662


Mention few capabilities of sas framework.

687


Explain why double trailing @@ is used in input statement?

567