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
What is the SAS data set?
Why and when do you use proc sql?
explain about various caches available in data integrator? : Sas-di
what is proc Index? and what is proc document?
Mention some common errors that are usually committed in sas programming.
Which are the statements whose placement in the data step is critical?
Differentiate input and infile.
how does sas handle missing values in formats? : Sas programming
What makes sas stand out to be the best over other data analytics tools?
What is the maximum and minimum length of macro variable
what is operational data and operational system? : Sas-di
What is the difference between %local and %global? : sas-macro
What is the role of unrestrictive users? : sas-grid-administration
What does P-value signify about the statistical data?
Tell e how how dealt with..