Interested to Buy Any Domain ? << Click Here >> for more details...
If reading a variable length file with fixed input, how
would you prevent SAS from reading the next record if the
last variable didn’t have a value?
- 3 Answers
- 13713 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kumaraswamy maduri
Using MISSOVER or TRUNCOVER. TRUNCOVER is best because if
the last variable doesn't have value then it assigns
missing as just as missover one extra difference with
TRUNCOVER is, if you are using formatted input and the
width is more than the value still truncover reads the
available value but missover assigns a missing.
Eg: data t;
input num 3.;
cards;
1
12
121
;
run;
Check the above code using missover and truncover.
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / nitin
By using stopover, missover is used to read next record
without stopping.
| Is This Answer Correct ? | 6 Yes | 2 No |
i have multiple .csv files in a unix directory. every file is having variable names as header.even for empty file also. suppose take 3 files a.csv b.csv c.csv a.csv contains data as name;age,salary; raja;34;4000; ravi;33;5000; kumar;25;3000; b.csv contains data as name;age,salary; ajay;40;4500; and c.csv contains name;age,salary; (only headers) Now i want to import and append all these files in to a single dataset. i tried infile statement with *.csv to import all at a time. but i m not getting correct data. please help me . its urgent. thank you in advance
How do I CREATE an external dataset with sas code? I would like to create within a sascode a non-exsistent textfile on the host. So I am not forced to create the file befor filling it.
Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager
What is proc sort?
how the sas basic syntax style described? : Sas-administrator
How many ways to overcome a missing values???
What is a macro routine?
Can we replace a dataset into view?
What are the best sas programming practices for handling very large datasets? : sas-grid-administration
Explain the difference between using drop = data set option in set and data statement?
WHAT DOES A SAS SPECIFICATION DOCUMENT SDS CONTAIN ?
How do you use the do loop if you don’t know how many times you should execute the do loop?
Teradata 
