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?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / vk
i think we can export the report only to III party files
like html,rtf and pdf only. But not to xls(excel).
Is This Answer Correct ? | 2 Yes | 10 No |
If you?re not wanting any SAS output from a data step, how would you code the data statement to prevent SAS from producing a set?
how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming
How would you identify a macro variable?
describe about joins? briefly?
explain the key concept of sas? : Sas-administrator
Can we create datasets by proc step ? (Proc contents, Means)?
Briefly explain input and put function?
What is substr function?
what is incremental update ? is this possible in SAS OLAP CUBE STUDIO.
how do you pull data from equifax?tell me the process?
0 Answers Synchrony Financial,
Which command is used to perform sorting in sas program?
What is the purpose of the trailing and How would you use them?