Now you have macro parameters that contains the new variable names plus the adjustable brands
investigation group; label term = 'Name Label' sex = 'Sex Label' years = 'Age Label' peak = 'Height Label' pounds = 'Weight Label'; lay sashelp.class; run;proc report analysis=class; line ('Name Label' title) ('Sex Label' gender) ('Age Label' decades) ('Height Label' level) ('Weight Label' lbs); attrib _all_ label=" "; run;Wiser possibly — but 1st a lot more performs: you can read the new varying brands and you can names out of possibly PROC Material production or regarding dictionary tables, following manage good macro you to definitely essentially creates the new Term report that you have.
proc sql noprint; pick identity, coalesce(term,name) for the :brands broke up of the ' ',:names e='SASHELP' and you can memname='GAS' purchase by the varnum; quit; %lay &=names; %place &=labels;Re: Showing each other variable name and you may varying term regarding dining table header Released 08-11-2022 Am (772 views) | Within the respond to xxformat_com
study class; put sashelp.class; identity identity = 'Name Name (NAME)' intercourse = 'Sex Title (SEX)' years = 'Age Identity (AGE)' height = 'Height Name (HEIGHT)' pounds = 'Weight Term (WEIGHT)' ; run;proc declaration research=class; run;analysis class; set sashelp.class; identity term = 'Name Label' intercourse = 'Sex Label' age = 'Age Label' level = 'Height Label' pounds = 'Weight Label' ; run; proc transpose research=class(obs=0) out=names; var _all_; run; filename code temp; studies names; size varnum 8 _name_ $32 _label_ $256 ; set labels ; varnum+1; file code ; _label_=coalescec(_label_,_name_); _label_=catx(' ',_label_,cats('(',upcase(_name_),')')); place 'label ' _name_ '=' _label_ :$price. ';'; run; Now both work with new made Name statements during the a data action or PROC DATASETS step to alter new affixed names.
1206 proc declaration studies=class ; 1207 %tend to be password / source2; NOTE: %Is (top step 1) file Slavique filles pour le mariage Code is actually file . \#LN00063. 1208 +name Term ="Name Label (NAME)" ; 1209 +identity Sex ="Sex Title (SEX)" ; 1210 +term Age ="Years Title (AGE)" ; 1211 +label Peak ="Peak Name (HEIGHT)" ; 1212 +label Weight ="Lbs Name (WEIGHT)" ; NOTE: %Is (top step 1) stop. 1213 work at;
Re: Exhibiting one another adjustable identity and you may varying label throughout the table header Released 08-11-2022 In the morning (761 feedback) | For the respond to xxformat_com
analysis group; set sashelp.class; label identity = 'Name Label' gender = 'Sex Label' ages = 'Age Label' height = 'Height Label' pounds = 'Weight Label'; run; proc sql noprint; pick catx(' ','("',label,'"',identity,')') on :header elizabeth='WORK' and you will memname='CLASS'; quit; proc statement analysis=category nowd; column &heading ; attrib _all_ label=" "; run; If you want the brand new title to display the name next were title on the term and simply utilize the Title since new heading
Re: Showing both varying identity and you will adjustable name on the dining table heading Printed 08-11-2022 Was (753 feedback) | In the react to xxformat_com
Discovering another reactions, I today wonder in case your question is: tips do this so the variable name is constantly followed closely by the expression Identity; or you require anything alot more standard in which you can find actual names that will be diverse from new changeable title.
Re: Displaying both adjustable name and you may varying name on the dining table header Printed 08-11-2022 PM (704 opinions) | Inside respond to PaigeMiller
You will be proper. My original matter wasn’t regarding adding the fresh new varying name for the supports following the varying. But it is several other interesting approach for delivering each other variable label and term, I had not thought about. I take it once the an enjoyable tip because it helps make the password light.
My genuine concern was to get one line towards adjustable title plus one that into the changeable label without the need to automate (we.e. versus study _null_ or in place of macro vocabulary).
If you’d like new term to show title upcoming tend to be title regarding term and just make use of the Label given that the fresh header
Re: Showing both adjustable label and you will varying label regarding dining table heading Released 08-11-2022 PM (701 viewpoints) | Within the reply to xxformat_com
wrote:You may be right. My personal fresh matter wasn’t regarding including brand new variable identity inside brackets following the adjustable. But it is several other interesting approach for providing each other changeable identity and you can name, We hadn’t regarded. I carry it because a great suggestion since it helps make the code white.
My personal genuine matter were to have one row into varying name and something you to definitely toward adjustable identity without the need to automate (i.age. in place of analysis _null_ otherwise instead macro language).
Re: Displaying each other changeable name and you may variable title throughout the desk header Printed 08-11-2022 In the morning (792 views) | During the react to xxformat_com authored:
I have to claim that you don’t respond to my personal matter. And thus nothing might have been solved. Your amazing code grabbed new varying identity and appended the definition of «Label» and this refers to today the new identity you want to fool around with. Would be the fact whatever you try inquiring accomplish, append the phrase «Label» adopting the varying name, otherwise do you want to make use of the genuine variable names? Including, from inside the SASHELP.Gas in which three of your details from the studies put keeps a label linked to they, the fresh adjustable CPRATIO keeps identity «Compression Ratio», and thus do you need «Compressing Proportion» to arise in your own PROC Statement production or do you want «CPRATIO Title» to arise in the PROC Declaration efficiency? Delight get this clear.
You need an answer in the place of macros and you will in place of Investigation _NULL_ — as to the reasons? As to why remove valid units to get the jobs over?