how to import HTML files into SAS datasets?
Answers were Sorted based on User's Feedback
Answer / harinath
html files are converted to flat flies like excel,txt,access
files and import the data in sas enviranment
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / chandrakanth
change the html file to excel file. let us say if the filename is first.html right click on the file and select rename and type first.xls. Now the file becomes excel and you can import wizard or Proc import
Right now I can think of this solution, there may be another easy one.
Let me know if you have any questions
Is This Answer Correct ? | 0 Yes | 11 No |
if i having variables named a b c d e f ,how to find total of each variable ????give syntax...??
How do you debug and test your SAS programs? What can you learn from the SAS log when debugging? How do you test for missing values? How would you create multiple observations from a single observation? What are some good SAS programming practices for processing very large data sets? Briefly describe 5 ways to do a "table lookup" in SAS. Why is SAS considered self-documenting? Are you sensitive to code walk-throughs, peer review, or QC review? What other SAS features do you use for error trapping and data validation? How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
Mention some common errors that are usually committed in sas programming.
1.we can execute a macro with in a macro,by using call symput and symget can any one give me one example? 2.We can create the macro variables by using %let,%do,macro parameters,INTO clause in proc sql and call symput, can any one give me example to create macro variable with INTO clause and call symput? 3.
How are the analysis data sets structured?
Baseline definition in your study
3 Answers Accenture, Quintiles,
how does sas handle missing values in procs? : Sas programming
Please write codes to merge two datasets and keep every record in the first dataset.
Below is the table. Required to be output should be the highest number of each student_id. Example. Student_id Subject Marks 1 Hindi 86 2 Hindi 70 3 English 80 . Calculate sum and average marks for each group of student_id Example. Student_id Subject Marks Total Marks Average 1 English 40 181 60.33333 2 English 67 196 65.33333 3 English 80 160 53.33333 PLEASE PROVIDE THE CODE OF ABOVE PROBLEMS
Explain what is SAS informats?
What is instream data in SAS?
i have a dataset with 100000 records. i want 100 records from that dataset and create a dataset.we need to pick the observations random order like 100obs,500obs,1020obs,1890obs,2565obs like that i need 100 obs in random order? how can we create this one?