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 |
SAS using companies in chennai
What are the new features included in the new version of SAS Programming Language?
What do you know about sas data set?
Give some examples where proc report’s defaults are different than proc print’s defaults?
How do handle working under pressure?
Which date functions advances a date time or date/time value by agiven interval?
i have a null dataset with 20 variables. i want to upload the variables which contain name like a or k or anything in another dataset.how can we create the dataset?
is it possible to generate sas datasets using proc print ???
1 Answers GSK GlaxoSmithKline,
Mention common programming errors committed in sas ?
How to import the Zip files into SAS? If it is possible in SAS? If it is posible write the code...
Describe the function and untility of the most difficult SAS macro that you have written.
firstobs and obs are working only option wise,but we are using infile statement with firstobs and obs in a statement wise? so firstobs,obs working at options and statemnts or not?