Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

how does sas handle missing values in assignment statements? : Sas programming

1020


What would be the value of month at the end of data step execution and how many observations would be there?

1147


Difference between informat and format?

1093


I have a dataset concat having a variable a b & c. How to rename a b to e & f?

1285


which date functions advances a date time or date/time value by a given interval? : Sas programming

953


What are the functions used for character handling?

1259


how to do user inputs and command line arguments in sas?

3047


how to change the execute of macro

2313


what is the primary data source for the wrs? : Sas-bi

1235


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

1034


Why double trailing @@ is used in input statement?

1220


What will calendar procedure do?

1074


Describe the ways in which you can create a macro variable?

1084


how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming

1343


what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?

2183