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 study design in while working with SAS? what are screening variables in SAS?
sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately
What are the special input delimiters used in SAS?
Differences between where and if statement?
how do you pull data from equifax?tell me the process?
What are the functions which are used for character handling functions?
How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?
What can you learn from the SAS log when debugging?
Name types of category in which SAS Informats are placed?
What do you code to create a macro? : sas-macro
Explain substr function?
How sas treats the dsd delimiters?
what is sas application server? : Sas-di
explain the proc in sas? : Sas-administrator
Approximately what date is represented by the SAS date value of 730?