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 are the functions which are used for character handling functions?
What are the difference between the sas data step and sas procs?
Explain data_null_?
how does sas handle missing values in assignment statements? : Sas programming
explain about data integrator metadata reports? : Sas-di
Intern stastical programmer written test
What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?
what are the types of interactive display types? : Sas-bi
Describe the ways in which you can create macro variables? : sas-macro
What does PROC print, and PROC contents do?
Describe the ways in which you can create a macro variable?
Which command is used to perform sorting in sas program?
What are the parameters of scan function?
Can you suggest us materials for sdtm mapping?
Difference between SAS STATA & SPSS?