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

If you?re not wanting any SAS output from a data step, how would you code the data statement to prevent SAS from producing a set?

1 Answers  


how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming

0 Answers  


How would you identify a macro variable?

0 Answers  


describe about joins? briefly?

2 Answers   CitiGroup,


explain the key concept of sas? : Sas-administrator

0 Answers  






Can we create datasets by proc step ? (Proc contents, Means)?

2 Answers  


Briefly explain input and put function?

0 Answers  


What is substr function?

0 Answers  


what is incremental update ? is this possible in SAS OLAP CUBE STUDIO.

1 Answers   TCS,


how do you pull data from equifax?tell me the process?

0 Answers   Synchrony Financial,


Which command is used to perform sorting in sas program?

0 Answers  


What is the purpose of the trailing and How would you use them?

8 Answers  


Categories