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?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the SAS data set?

1136


Why and when do you use proc sql?

1251


explain about various caches available in data integrator? : Sas-di

1055


what is proc Index? and what is proc document?

2723


Mention some common errors that are usually committed in sas programming.

1052


Which are the statements whose placement in the data step is critical?

1267


Differentiate input and infile.

1110


how does sas handle missing values in formats? : Sas programming

1142


What makes sas stand out to be the best over other data analytics tools?

1073


What is the maximum and minimum length of macro variable

1256


what is operational data and operational system? : Sas-di

1115


What is the difference between %local and %global? : sas-macro

1189


What is the role of unrestrictive users? : sas-grid-administration

1010


What does P-value signify about the statistical data?

1366


Tell e how how dealt with..

2226