my problem is to export my report to xsl.i can do that.but
the problem is my report has 3 headings first heading
should be printed with the merging of (1-5)cells and
heading 2 should be of merge(2-4)cells?how to do this
condition?
Answers were Sorted based on User's Feedback
Answer / ankit
may be it is possible in macros when we use index function and compress function
data value;
infile 'val.txt' DSD delimiter='09'x MISSOVER lrecl=5000 ;
informat No :best. ;
informat Name:$75. ;
format Sl :best. ;
format Name :$75. ;
input
Sl_No :best.
Name_Of_Salon :$75. @;
if index (Name_Of_Salon,'"') gt 0 then do;
input / Name_Of_Salon_a :$75. @;
run;
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / vk
i think we can export the report only to III party files
like html,rtf and pdf only. But not to xls(excel).
Is This Answer Correct ? | 2 Yes | 10 No |
What are the functions done while Compilation...?
Explain proc univariate?
Are you involved in writing the inferential analysis plan? Tables specfications?
describe about joins? briefly?
Does SAS ?Translate? (compile) or does it ?Interpret?? Explain.
what are the differences between proc report and proc tabulate?
If you have a data set that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variable?
How would you compile all macros from a folder in a study, within the autoexec program?
Can you execute macro within another macro? : sas-macro
which date functions advances a date time or date/time value by a given interval? : Sas programming
How many missing values are available? When might you use them?
How would you code the criteria to restrict the output to be produced?