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?
- 2 Answers
- 5719 Views
- Dr Reddys, Oracle, I also Faced
- E-Mail Answers
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 data integration? : Sas-di
Tell me about % include and % eval? : sas-macro
hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?
What are the automatic variables for macro? : sas-macro
How do dates work in sas?
explain about data integrator metadata reports? : Sas-di
what is the difference between nodup and nodupkey options? : Sas programming
how does sas handle missing values in a merge? : Sas programming
How many ways to overcome a missing values???
Mention sas system options to debug sas macros.
How would you identify a macro variable? : sas-macro
How do you convert basic cube to transaction cube and transaction cube to basic cube?
is data integration and etl programming is same? : Sas-di
How would you include common or reuse to be processed along with your statements?
If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable? : sas-macro
