Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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 is the role of administrative users? : sas-grid-administration

0 Answers  


There is a field containing a date. It needs to be displayed in the format "ddmonyy" if it's before 1975, "dd mon ccyy" if it's after 1985, and as 'Disco Years' if it's between 1975 and 1985. How would you accomplish this in data step code? Using only PROC FORMAT

8 Answers   D&B,


This entry was posted in General. Bookmark the permalink. Post a comment or leave

0 Answers   Quintiles,


if you have 365 no of data set and each one having different variable from each other. how will you read by creating macros and create a single data set.

2 Answers  


Which is the best place to learn SAS clinicals and Oracle clinical in hyderabad?

2 Answers  


Can you excute a macro within a macro? Describe.

2 Answers   Genta,


I have a dataset concat having a variable a b & c. How to rename a b to e & f?

0 Answers  


What is the difference between an informat and a format. Name three informats or formats.

6 Answers  


name several ways to achieve efficiency in your program? : Sas programming

0 Answers  


Why Info School? BUILD YOUR CAREER WITH RIGHT GUIDANCE AND SUPPORT

0 Answers  


Name statements that are recognized at compile time only?

3 Answers   Accenture,


explain the difference between proc means and proc summary?

0 Answers  


Categories