SAS Support Communities

Hi All, I have a code which is writing some data in the log as a part of note/warning. I want to suppress writing the column names and their values in the log. Is there any option that will prevent writing column names and their values? I am fine with the note though. Note: Invalid numeric data at line 520 column 35 column1=abc Column2=500 column3=12345……… Thanks in advance Nick ... View more

Hello All, I have a SAS dataset with account numbers(character). I want to display only last 4 masking the remaining with ‘x’. Input: Account 123456 34567898 Output: Account xx3456 xxxx7898 Any suggestions will be highly appreciated. ... View more

Hello everyone, I have a proc sql code that is taking more than an hour hour to complete. Is there a way I can optimize it to run quicker? Code: Proc sql; Create table want as Select distinct a.*, c.*, b.column1 From table1 a Left join table2 b On a.ID1=b.ID1 Left join table3 c On a.ID2=c.ID2 ; Quit; Any suggestions is highly appreciated. Thanks, Nick ... View more

Hi all, I have a sas dataset with around 15k record that I have to do an inner join with an Oracle table. I am doing a heterogeneous join but it is taking extremely long to complete even with options like readbuff, dbkey and multi_datasrc_opt=in. Is there any other way I could run my program faster? Thanks, Nick ... View more

Hello friends, I am trying to do my development work on Sas studio on Viya server and stop using enterprise guide. But I am struggling to save the .sas program files on my local machine. Is there a way I can save the program files on my local machine and open/edit/run on sas studio whenever I need? Thank you, Nick ... View more

Hello everyone, Is it correct to use date constant in %let statement? I will be using this value only to filter the data in a datastep later on. %let mydate=‘01jan2021’d; data test1; set test ; If dt=&mydate; Run; Please let me know your thoughts. Thanks, Nick ... View more

Hello all,   I have a dateset Have. It has multiple records by identifier ID, all the values are same except for attrib1 and attrib2.   I want to change the attrib 1 values to column names and assign them the values of attrib2.   Have: ID  Name  State Date  attrib1 attrib2 123 John AZ 1/1/2021 level A 123 John AZ 1/2/2021 Score 120 123 John AZ 1/3/2021 Maint1 202 123 John AZ 1/4/2021 Maint3 501 123 John AZ 1/5/2021 Maint2 302 123 John AZ 1/6/2021 Maint4 101 234 Mary CA 2/6/2021 Maint2 150 234 Mary CA 2/7/2021 Maint1 101   Want: ID  Name  State Date  level Maint1 Maint2 Maint3 Maint4 Score 123 John AZ 1/1/2021 A 202 302 501 101 120 234 Mary CA 2/6/2021   101 150         What will be the best way to achieve this? Any suggestions or solution is appreciated.   Thanks, Nick ... View more

I am trying to bring in latest record from teradata based on two IDs, but without grouping them. Both these IDs have been reassigned to each other so I want to pick up the latest. I do not want to have duplicates by any IDs. Have: ID1 ID2 date 123 987 12/01/2020 123 654 05/10/2020 345 999 01/20/2020 456 999 12/20/2020 231 789 12/10/2020 231 789 12/21/2020 Want: ID1 ID2 123 987 456 999 231 789 Since the data is in teradata, might be efficient to use sql/teradata sql instead of data step? Please advice. ... View more