• Community
    • Home
    • Welcome
      • Getting Started
      • Community Memo
      • All Things Community
      • SAS Customer Recognition Awards (2024)
      • SAS Customer Recognition Awards (2023)
    • SAS Community Library
    • SAS Product Suggestions
    • Upcoming Events
    • SAS Customer Recognition Awards
    • All Recent Topics
  • Learn
    • New SAS User
    • SAS Software for Learning Community
    • Ask the Expert
    • SAS Certification
    • SAS Tips from the Community
    • SAS Training
      • Programming 1 and 2
      • Advanced Programming
      • Course Case Studies and Challenges
      • Trustworthy AI
    • SAS Global Forum Proceedings 2021
    • Tech Report Archive
    • SAS Insights Archive
  • Programming
    • SAS Programming
    • SAS Procedures
    • SAS Enterprise Guide
    • SAS Studio
    • Graphics Programming
    • ODS and Base Reporting
    • SAS Code Examples
    • SAS Web Report Studio
    • Developers
  • Analytics
    • Statistical Procedures
    • SAS Data Science
    • Mathematical Optimization, Discrete-Event Simulation, and OR
    • SAS/IML Software and Matrix Computations
    • SAS Forecasting and Econometrics
    • Streaming Analytics
    • Research and Science from SAS
  • SAS Viya
    • SAS Viya
    • SAS Viya on Microsoft Azure
    • SAS Viya Release Updates
    • Moving to SAS Viya
    • SAS Visual Analytics
    • SAS Visual Analytics Gallery
    • Your Journey to Success
    • SAS Viya Workbench
      • SAS Viya Workbench: Getting Started
      • SAS Viya Workbench Discussion
      • SAS Viya Workbench: Release Updates
  • Administration
    • Administration and Deployment
    • Architecture
    • SAS Hot Fix Announcements
    • SUGA
  • Solutions
    • Microsoft Integration with SAS
    • Decisioning
    • SAS Decision Builder
    • Data Management
    • Customer Intelligence
      • SAS Customer Intelligence
      • SAS Customer Intelligence 360 Release Notes
      • SAS 360 Match
    • Risk and Fraud
      • SAS Risk Management
      • Fraud, AML and Security Intelligence
      • SAS Risk Release Updates
      • Risk & Finance Analytics
      • Insurance Fraud
      • MRM AI Governance Working Group
      • SAS Quant Community
    • SAS Health
      • SAS Health and Life Sciences
      • SAS Life Science Analytics Framework
  • Hubs
    • Regional Hubs
      • SAS User Groups
      • SAS Community Nordic
      • AML Nordic User Group
      • SAS Japan
      • SAS Korea
      • CoDe SAS German
      • SAS Plattform Netzwerk
      • SAS Brazil Community
      • SAS Spanish Community
      • SAS Users Group in Israel
      • 欢迎来到SAS中文社区!
      • Ottawa Area SAS Users' Society
      • Toronto Area SAS Users Group
      • SAS Türkiye Community
    • Special Interest Hubs
      • SAS Hacker's Hub
      • SAS Innovate 2026
      • SAS Analytics Explorers
      • The Curiosity Cup
      • SAS Inner Circle Panel
      • SAS Hackathon Team Profiles (Past)
      • SAS Explore
      • Reporting and Optimization
      • Intern Alumni Network Community
Sign In

Search the Community

Showing results for 
Search instead for 
Did you mean: 
Search Options
  • Subscribe to RSS Feed for this Search
Advanced Hide Advanced
  • Posts
  • Users
  • Places
  • Products
Advanced Search Options
Search Modifiers:
You can apply modifiers to the terms you enter in the search field.
Use quotes to search for an "exact phrase".
Use the plus sign to search for +one +or +more +words.
Use the minus sign to -exclude -certain -words from your search.
Limits search results to topics that have no replies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
740 results
Sorted by:
Best Match
  • Date
  • Views
  • Likes
  • Replies
  • Best Match

Rename Variable List

by Quartz | Level 8 shellp55 in SAS Procedures
‎09-28-2012 01:28 PM
‎09-28-2012 01:28 PM
...e changed. I searched the site and was able to successfully change singular variable names using "modify" and "rename" but I'm not sure how to do a range.  Some of the examples on the sites i...
Show results in replies (1)
  • ...nd; %mend; data want; set have; rename %renm; run; Haikuo

Estimating the Standard Deviation of a Variable in a Finite Population

by Community Manager AlexBeaver in SAS Code Examples
‎12-20-2023 09:27 PM
‎12-20-2023 09:27 PM
...acro variables Spending_Mean and N: data Working; set IceCreamStudy; z=(1/(&N-1))*(Spending-&Spending_Mean)**2; run; Step 3: Estimate the Total of z and T...
Labels:
  • SAS STAT

FROM %LET TO %LOCAL; METHODS, USE, AND SCOPE OF MACRO VARIABLES IN SAS...

by Obsidian | Level 7 IyenJ in SAS Communities Library
‎03-10-2025 09:09 AM
‎03-10-2025 09:09 AM
Presented at PharmaSUG 2022 in Austin, TX
PharmaSUG-2022-AP-041.pdf (‏633 KB)
Labels:
  • SAS Conference Papers

Estimating the Variance of a Variable in a Finite Population

by Community Manager AlexBeaver in SAS Code Examples
‎12-20-2023 11:35 AM
‎12-20-2023 11:35 AM
...un;   The data set Long has 40 x 16 = 640 observations. There are 16 copies of the original variables from the IceCreamStudy data set stacked on top of each other, and each c...
Labels:
  • SAS STAT

WARNING: The variable in the DROP, KEEP, or RENAME list has never been...

by Quartz | Level 8 Riteshdell in SAS Programming
‎07-14-2016 06:50 AM
1 Like
‎07-14-2016 06:50 AM
1 Like
hello all,   I am getting a warning in some code: WARNING: The variable in the DROP, KEEP, or RENAME list has never been referenced   Can any one tell me, what can be the scenario of t...
Show results in replies (1)
  • ...omplains in the log: ERROR: The variable chr1 in the DROP, KEEP, or RENAME list has never been referenced....

rename variabile with an element of list by macro variable

by Calcite | Level 5 antosferry in SAS Studio
‎11-17-2020 08:58 AM
‎11-17-2020 08:58 AM
Hi, I created a macro variable using proc sql ....select into.... The macro variable is for example: %put &top10.; run; '04050606', '94958693', '20494585'....   I want to rename a variabl...
Show results in replies (1)
  • ...an use it to generate code: create table prova_new as select drg_new , _c2_ as %scan(%s...

conditionally renaming variables

by Calcite | Level 5 avbraga in SAS Programming
‎06-24-2014 10:49 AM
‎06-24-2014 10:49 AM
Hi all, I am trying to conditionally rename variables if they are present or not in a dataset. Consider the example: I read in the dataset, which sometimes there could be a case where the variabl...
Show results in replies (1)
  • ...sid)); %if &countnum=0 %then %do; data test2; set &dsname;   rename count1 = amount1;&n...

WARNING: The variable CT in the DROP, KEEP, or RENAME list has never b...

by Calcite | Level 5 Desi2003 in New SAS User
‎11-08-2023 01:17 PM
‎11-08-2023 01:17 PM
...hysical activity to tract_name*; 85 DATA Phy_Act1; 86 SETCoImpt.PhysicalActivity; 87 RENAMECT= TRACT_NAME; 88 RUN; WARNING: The variable CT in the DROP, KEEP, or RENAME...
Show results in replies (1)
  • There is no variable named CT in the incoming dataset. Remove the RENAME statement to avoid the W...

%Looping; warning SAS Grid 8.3 WARNING: THE VARIABLE INFO IN THE DROP,...

by Calcite | Level 5 Biffothebear in SAS Enterprise Guide
‎10-05-2023 08:32 PM
‎10-05-2023 08:32 PM
...bsp; WARNING: THE VARIABLE INFO IN THE DROP, KEEP, OR RENAME LIST HAS NEVER BEEN REFERENCED   The warning related to this line of code   %looping;   which is at the end of the whole c...
Show results in replies (1)
  • ...bsp;   You get this warning because in your code you attempt to DROP a variable that doesn't e...

drop list of variables from macro variable

by Calcite | Level 5 ngnikhilgoyal in SAS Procedures
‎01-15-2015 10:57 AM
‎01-15-2015 10:57 AM
I wanted to drop a list of variables from my inputds. This list itself is present as observations in another dataset. After doing some googling, I found this excellent paper on the topic. http://w...
Show results in replies (2)
  • ...get an error message: : The variable _TYPE_ in the DROP, KEEP, or RENAME list has never been r...
  • Nikhil, The problems you are noticing come about because $1000 is not long enough to hold 2000 variabl...
  • « Previous
    • 1
    • 2
    • 3
  • Next »
Powered by Khoros