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

Describe 5 ways to do a “table lookup” in SAS?

0 Answers  


I have 50 variables in one data set, In reports i want to generate every 10 variables in one page how we will write code in proc report.

4 Answers  


what has been your most common programming mistake? : Sas programming

0 Answers  


What are the different versions of sas that you have used until now? : sas-grid-administration

0 Answers  


what is snowflake schema? : Sas-di

0 Answers  


what is treatment emergent events and treatment emregent adverse event

0 Answers  


In ARRAY processing, what does the DIM function do?

0 Answers  


How did you use the round function?give an example(don't say it will round to the nearest intger) eg1:round(84.55,.1) =84.6 eg2:round(92.64,.1)=92.6,How it is happening like this tell me the logic,that is how the round function works when we have deimal values?

2 Answers   BoA,


How can you create a macro variable with in data step? : sas-macro

0 Answers  


diff between nodup rec and ondup key???

3 Answers   AON, Sciformix,


If you use a symput in a data step, when and where can you use the macro variable? : sas-macro

0 Answers  


Name some categories in sas 9? : sas-grid-administration

0 Answers  


Categories