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



my problem is to export my report to xsl.i can do that.but the problem is my report has 3 headings..

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

my problem is to export my report to xsl.i can do that.but the problem is my report has 3 headings..

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

Post New Answer

More SAS Interview Questions

What are the functions done while Compilation...?

1 Answers   TCS,


Explain proc univariate?

0 Answers  


Are you involved in writing the inferential analysis plan? Tables specfications?

0 Answers  


describe about joins? briefly?

2 Answers   CitiGroup,


Does SAS ?Translate? (compile) or does it ?Interpret?? Explain.

10 Answers  






what are the differences between proc report and proc tabulate?

3 Answers  


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?

10 Answers   Accenture,


How would you compile all macros from a folder in a study, within the autoexec program?

1 Answers  


Can you execute macro within another macro? : sas-macro

0 Answers  


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

0 Answers  


How many missing values are available? When might you use them?

1 Answers   Quintiles,


How would you code the criteria to restrict the output to be produced?

6 Answers   Accenture,


Categories