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 statements that are executed only?

1 Answers  


In ARRAY processing, what does the DIM function do?

1 Answers  


Give some examples where proc report’s defaults are same as proc print’s defaults?

1 Answers  


What procedure you used to calculate p-value?

2 Answers   Accenture, Quintiles,


What is the use of PROC gplot?

1 Answers  


What are the data types in sas?

1 Answers  


differnce between 8.2 and 9.1.3

1 Answers  


Why double trailing @@ is used in input statement?

1 Answers  


how can you import .csv file in to sas? : Sas programming

1 Answers  


Mention how to limit decimal places for the variable using proc means?

1 Answers  


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   Accenture,


Can you explain the process of calendar?

1 Answers  


Categories