Epoch
Would you like to react to this message? Create an account in a few clicks or log in to continue.
Search
 
 

Display results as :
 


Rechercher Advanced Search

Keywords

Latest topics
» SAS Macro: Convert numbers (e.g., 1000) to names (e.g., One thousand)
MLF option added in Proc Report EmptyMon Jun 10, 2013 2:57 pm by Admin

» SAS Enterprise Guide: Explore Data before you start Analysing
MLF option added in Proc Report EmptyMon Jun 10, 2013 2:53 pm by Admin

» Predictive Analytics
MLF option added in Proc Report EmptyFri May 31, 2013 3:30 pm by Admin

» Creating Frequency Report and Creating User Defined styles in SAS Add-In for Microsoft Office
MLF option added in Proc Report EmptyTue Oct 23, 2012 2:11 pm by pallav

» Prompted Reports in BI Dashboard
MLF option added in Proc Report EmptyThu Oct 11, 2012 4:54 pm by kushal

» Free SAS Webinar : Getting Started with SAS Hash Object
MLF option added in Proc Report EmptyWed Oct 10, 2012 6:08 pm by pallav

» Which SAS procedure changes the name of a permanent format for a variable stored in a SAS data set?
MLF option added in Proc Report EmptyTue Oct 02, 2012 12:47 am by rajin_kumar@yahoo.com

» What is written to SAS Log?
MLF option added in Proc Report EmptyTue Oct 02, 2012 12:39 am by rajin_kumar@yahoo.com

» SAS Portal and BI Dashboard: Customizing the Tabs
MLF option added in Proc Report EmptyTue Oct 02, 2012 12:33 am by kushal

Affiliates
free forum


MLF option added in Proc Report

Go down

MLF option added in Proc Report Empty MLF option added in Proc Report

Post  pallav Mon Mar 26, 2012 2:28 pm

In Proc Report new option called MLF (Multilable format) is added to define statement.

For Example:

proc format;
value agelfmt (multilabel)
11='11'
12='12'
13='13'
14='14'
15='15'
16='16'
11-12='11 or 12'
13-14='13 or 14'
15-16='15 or 16'
low-13='13 and below'
14-high='14 and above' ;
run;
/*Create the AGE1FMT. format.The FORMAT procedure creates a multilabel */
/*format for ages by using the MULTILABEL option. A multilabel format */
/*is one in which multiple labels can be assigned to the same value. */
/*Each value is represented in the table for each range in which it occurs.*/

ods html file="example.html";
title "GROUP Variable with MLF Option";
proc report data=sashelp.class nowd;
column age ('Mean' height weight);
define age / group mlf format=agelfmt. 'Age Group';
define height / mean format=6.2 'Height (in.)';
define weight / mean format=6.2 'Weight (lbs.)';
run;
ods html close;


Here you can see that age is define as a group with MLF option.

Which will give the output like below.

MLF option added in Proc Report Procreportexp17_3

pallav

Posts : 98
Join date : 2012-03-14
Location : Ahmedabad

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum