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
Administration
Administration and Deployment
Architecture
SAS Hot Fix Announcements
SAS Product Release Announcements
SUGA
Solutions
Microsoft Integration with SAS
Decisioning
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
Risk & Finance Analytics
Insurance Fraud
SAS Health
SAS Health and Life Sciences
SAS Life Science Analytics Framework
Hubs
Regional Hubs
SAS User Groups
SAS Community Nordic
SAS Network for Women in Norway
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
Polish SAS Users Group
SAS User Group UK & Ireland
欢迎来到SAS中文社区!
SAS User Group Middle East
Ottawa Area SAS Users' Society
Special Interest Hubs
SAS Hacker's Hub
SAS Innovate 2025
SAS Analytics Explorers
The Curiosity Cup
SAS Inner Circle Panel
SAS Hackathon Team Profiles (Past)
SAS Explore
Sign In
All community
Knowledge base
Tanmay
Users
Products
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
Home
/
About Tanmay
02-29-2016
Tanmay
Calcite | Level 5
Member since
07-09-2014
View All
5
Posts
2
Likes Given
0
Solutions
0
Likes Received
Follow Tanmay
Recent Posts
Activity
Posts Liked
Posts Liked by Others
Article Contributions
Latest posts by Tanmay
Subject
Views
Posted
Re: Drop and Keep Question
SAS Programming
3063
01-06-2016
07:28 AM
Re: how to add prefix to a column
SAS Programming
940
01-06-2016
06:45 AM
Re: append / join the columns to the duplicate records, using proc sql...
SAS Programming
1354
01-06-2016
05:54 AM
Re: Deleting duplicates based on three variables
SAS Procedures
12423
01-14-2015
03:22 AM
View All
Activity Feed for Tanmay
Liked
Re: How to - Sort Variable Which Includes Both Numeric and Character Value
for Jagadishkatam.
01-06-2016
07:55 AM
Posted
Re: Drop and Keep Question
on
SAS Programming
.
01-06-2016
07:28 AM
Posted
Re: how to add prefix to a column
on
SAS Programming
.
01-06-2016
06:45 AM
Posted
Re: append / join the columns to the duplicate records, using proc sql, how?
on
SAS Programming
.
01-06-2016
05:54 AM
Posted
Re: Deleting duplicates based on three variables
on
SAS Procedures
.
01-14-2015
03:22 AM
Liked
Re: SQL Script from SAS Enterprise Guide
for Kurt_Bremser.
07-09-2014
05:37 AM
Posts I Liked
Subject
Likes
Author
Latest Post
Re: How to - Sort Variable Which Includes Both Numeric and Character V...
SAS Programming
3
Jagadishkatam
01-05-2016
04:48 AM
by
RW9
Re: SQL Script from SAS Enterprise Guide
SAS Enterprise Guide
2
Kurt_Bremser
07-07-2014
09:01 AM
by
Kurt_Bremser
View All
Latest Contributions by Tanmay
Topics Tanmay has Participated In
Latest Contributions by Tanmay
Re: Drop and Keep Question
by
Tanmay
in
SAS Programming
01-06-2016
07:28 AM
01-06-2016
07:28 AM
Out put data set will contain two variables 1 + 1 (newly created variable) = 2
... View more
Re: how to add prefix to a column
by
Tanmay
in
SAS Programming
01-06-2016
06:45 AM
01-06-2016
06:45 AM
You can also try this New_Col = Compress(Prefix||Your_col);
... View more
Re: append / join the columns to the duplicate records, using proc sql...
by
Tanmay
in
SAS Programming
01-06-2016
05:54 AM
01-06-2016
05:54 AM
Try This : proc sql; create table Table_1 as select t.*,b.inst from t left join b on a.id = b.id; quit; or you can also try with inner join, as per our required logic.
... View more
Re: Deleting duplicates based on three variables
by
Tanmay
in
SAS Procedures
01-14-2015
03:22 AM
01-14-2015
03:22 AM
proc sort data=pat_detail out=pat_detail_new nodupkey; by pat_ID dis_date linker; run;
... View more
Contact Me
Online Status
Offline
Date Last Visited
02-29-2016
05:13 AM
Likes given to
User
Likes Count
Jagadishkatam
1
Kurt_Bremser
1
View All
Quick links
Register
Sign In