Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6615 Views
- Dr Reddys, Oracle, I also Faced
- E-Mail Answers
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 |
How to write duplicate records into a separate dataset using sort?
what is in stream data in SAS?
What statement do you code to write the record to the file?
libname deepak 'C:\SAS Files'; proc format; invalue convert 'A+' = 100 'A' = 96 'A-' = 92 'B+' = 88 'B' = 84 'B-' = 80 'C+' = 76 'C' = 72 'F' = 65; data deepak.grades; input ID $3. Grade convert.; *format Grade convert. ; datalines; 001 A- 002 B+ 003 F 004 C+ 005 A ; proc print data = deepak.grades; run; I get the following output Obs ID Grade 1 001 . 2 002 . 3 003 . 4 004 . 5 005 . I don’t understand why Grade shows up as a missing value. Everything seems fine, including ID $3. Now, in case I use ID : $3. Or use column input, I get the desired output. Kindly help Deepak
how can you sort the dataset having millions of OBS(instead of sort procedure?
I need to find the numeric field which contains blank in between..Ex:123 456...there is blank in between the 123 456..I need to know if there is any SAS function to find a field.. Please suggest...
What are all the problems you faced while validating tables and reports?
0 Answers Accenture, Quintiles,
what type of graphs we will create(for 2+years candidates)?
What do you know about sas and what we do? : sas-grid-administration
What statement do you code to tell SAS that it is to write to an external file? What statement do you code to write the record to the file?
Please, anyone, let me know the style or an example of using 'by='/'by' variable of a PDV(Program Data Vector)
3 Answers Verinon Technology Solutions,
explain the difference between proc means and proc summary?
Teradata 
