Now you must macro parameters who has brand new adjustable labels and changeable labels

investigation classification; name name = 'Name Label' sex = 'Sex Label' age = 'Age Label' level = 'Height Label' weight = 'Weight Label'; lay sashelp.class; run;

proc statement study=class; column ('Name Label' label) ('Sex Label' gender) ('Age Label' ages) ('Height Label' level) ('Weight Label' weight); attrib _all_ label=" "; run;

Smarter perhaps – but 1st more performs: you can read brand new varying labels and labels regarding often PROC Content productivity otherwise regarding the dictionary tables, after which would a beneficial macro one basically creates this new Identity report you have.

proc sql noprint; see identity, coalesce(title,name) for the :brands split up from the ' ',:brands age='SASHELP' and you can memname='GAS' order of the varnum; quit; %lay &=names; %place &=labels;

Re: Demonstrating each other changeable label and you can changeable term throughout the dining table header Printed 08-11-2022 Was (772 views) | Inside answer xxformat_com

investigation classification; set sashelp.class; label identity = 'Name Name (NAME)' sex = 'Sex Title (SEX)' age = 'Age Name (AGE)' peak = 'Height Label (HEIGHT)' weight = 'Weight Name (WEIGHT)' ; run;

proc declaration investigation=class; run;

study group; put sashelp.class; identity name = 'Name Label' gender = 'Sex Label' many years = 'Age Label' top = 'Height Label' weight = 'Weight Label' ; run; proc transpose research=class(obs=0) out=names; var _all_; run; filename code temp; analysis brands; duration varnum 8 _name_ $thirty two _label_ $256 ; set names ; varnum+1; document password ; _label_=coalescec(_label_,_name_); _label_=catx(' ',_label_,cats('(',upcase(_name_),')')); place 'label ' _name_ '=' _label_ :$quote. ';'; run; 

Now both focus on this new made Label statements into the a data action otherwise PROC DATASETS action to alter the brand new affixed names.

1206 proc report analysis=classification ; 1207 %tend to be password / source2; NOTE: %Are (top step one) document Code is actually file . \#LN00063. 1208 +label Label ="Identity Label (NAME)" ; 1209 +title Sex ="Sex Term (SEX)" ; 1210 +title Age ="Age Title (AGE)" ; 1211 +name Level ="Top Term (HEIGHT)" ; 1212 +title Pounds ="Pounds Label (WEIGHT)" ; NOTE: %Were (level step one) ending. 1213 manage;

Re: Displaying both changeable title and you can variable identity from the table header Released 08-11-2022 Am (761 views) | Into the respond to xxformat_com

research class; put sashelp.class; identity identity = 'Name Label' gender = 'Sex Label' many years = 'Age Label' peak = 'Height Label' weight = 'Weight Label'; run; proc sql noprint; discover catx(' ','("',label,'"',identity,')') into the :heading age='WORK' and you may memname='CLASS'; quit; proc report study=classification nowd; line &header ; attrib _all_ label=" "; run; 

If you need the fresh new title to demonstrate the name upcoming include title in the term and just use the Name since the the new header

Re: Showing one another variable title and you will adjustable identity regarding desk header Released 08-11-2022 Are (753 viewpoints) | During the answer xxformat_com

Discovering the other answers, We today question in case the real question is: how-to do that therefore, the changeable name’s constantly accompanied by the word Label; or you need some thing so much more general in which discover actual brands that are unique of brand new changeable identity.

Re: Demonstrating both varying title and you can changeable title in the dining table heading Posted Mongolie plus belle fille 08-11-2022 PM (704 views) | In answer PaigeMiller

You will be best. My personal new matter was not regarding the including the brand new varying name during the supports adopting the variable. But it is another fascinating method for delivering both varying name and name, We had not regarded. I bring it as the a nice tip since it helps to make the code light.

My genuine concern was to get one line to the adjustable identity and another that to the varying identity without the need to speed up (i.age. instead of studies _null_ otherwise rather than macro code).

If you want the name to demonstrate title next were the name about label and just utilize the Identity as the the newest header

Re: Demonstrating each other variable term and you will varying label on desk heading Released 08-11-2022 PM (701 feedback) | Into the reply to xxformat_com

wrote:You may be right. My original concern wasn’t regarding incorporating the fresh new varying term inside mounts following variable. However it is other fascinating method for getting each other varying label and identity, I hadn’t regarded as. I carry it as a pleasant suggestion as it helps make the code light.

My personal actual matter would be to have one line into the adjustable name and another you to into adjustable term without having to speed up (i.elizabeth. as opposed to study _null_ otherwise as opposed to macro language).

Re: Displaying each other changeable identity and you can adjustable title about dining table header Released 08-11-2022 In the morning (792 opinions) | In the answer xxformat_com typed:

I want to say that your failed to address my concern. And therefore absolutely nothing has been solved. Your fresh password took brand new changeable label and you may appended the word “Label” referring to now the newest name you want to explore. Is the fact everything you try asking doing, append the expression “Label” pursuing the varying label, or do you wish to utilize the actual adjustable labels? Eg, within the SASHELP.Fuel where three of the details from the investigation place possess a tag attached to it, the adjustable CPRATIO keeps term “Compressing Ratio”, and therefore how would you like “Compressing Ratio” to surface in your own PROC Report yields otherwise do you want “CPRATIO Identity” to appear in their PROC Report yields? Excite make this obvious.

You need a response as opposed to macros and as opposed to Studies _NULL_ – as to the reasons? Why eradicate legitimate gadgets to obtain the occupations complete?