how to read raw data in sas. Do it manually and throw the
programming.
- 1 Answers
- 6821 Views
- WNS, I also Faced
- E-Mail Answers
Answer / singh.naveen409
Process-1
FIle-Import Data-Next-Browse-ok-finish
Process-2
filename myfile "file location path.extension";
data qqq;
infile myfile;
input ......................;
run;
In the place of this .............just right down variable
name;
If you have csv file then;
process:-
proc inport out=work.auto1 filename " path of file which you
want to read.csv"
dbms=csv replace;
getnames=yes;
run;
| Is This Answer Correct ? | 7 Yes | 0 No |
how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5
Hi im new to sas. I have a file with some charecter variables and some numeric variables now i want to load charecter variables into one datastep and numeric variables into another data step pls let me know Thanks
What function CATX syntax does?
how does sas handle missing values in procs? : Sas programming
What is SAS informats?
what are 5 ways to perform a table lookup in sas? : Sas-administrator
Hi I have list of products in a dataset, which are classified by other name for eg:- there is a product A> Malambo Shiraz Malbec 750ML(0388) which is a Red wine.Now i need to generate a report where it shows if this product appears then it should b displayed as red wine,similarly for other products and other classification. I dont wan use proc format.
How to limit decimal places for the variable using proc means?
how do you read binary data in sas?
explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di
What is the purpose of _character_ and _numeric_?
How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?
Teradata 
