Hi Team,   How to achieve given below request in sas.   * Mean value and Range of values for numeric fields • Five lowest and five highest values. * How to find outliers in SAS column.   Thanks! ... View more

Hi Guys,   I am trying to get duplicate records based on the nodupkey which find the duplicate records based on the by statement. However, It is giving me no-duplicate records in duplicate output file(dup_recs). Given is the syntax I have used.   proc sort data=table1 nodupkey out=without_dup  dupout=dup_recs; by &col.; run; and col macro keep the 178 column to validate if there is any duplicate record or not.   Thanks, Abhishek ... View more

Hi,   I am looking for a logic where I can compare one source sas dataset with multiple destination sas datasets without proc compare. Also column names are different in the destination datasets.    Thanks! ... View more

Hi Team,   I am looking for a best approach to identify complete duplicate records(redundancy) in large dataset. I can not use proc sort since it will impact the performance of the code. Is there anyone can share a sample of code except proc sort for identifying duplicate records in a dataset. It will be highly appreciated.   Thanks, Abhishek ... View more

Hi Team,   Given below Unix command is not working in SAS eg  with X command. Rest all commands are working fine instead of "archive". Archive is not functioning whenever I am trying to do with SAS eg. However, following command is working fine when I use with the unix editor. Please suggest any solution.   find -type f -not -name '*.txt' -mtime +30 -printf '%P\n' | xargs archive   Thanks, Abhishek ... View more

Hi Team,   I have a sas table and in that table I have 20 columns and all 20 columns have certain values. And here I want to create another sas table from this table where I should two column. in one column I should have all column names of first sas table and in other table I want to store all the values respective to the column names.   first dataset: DATA Abhi; input a b c d e f g h i j k l m; datalines; --- --- -- ;   outcome dataset result: 1st  2nd  a       5 a      4 a      3 b     2 b      6 c   8 d   9 e  10 f  11 g  12 h  13 ;       thank! ... View more

Hi Team,   I have a dataset test and in this dataset I have columns like acctn, cust_name, gender, address curr_date. I want to validate all the attributes of this datasets such as account number should always remain numeric and meta data should not change for all the columns. and I want to send an email to the user if the any attribute change for any column.   attributes ie. type of column, length, format, informat, label, all kind.    DATA Test; infile datalines; datalines; 12345 ram    M POST OFFICE 2013 12/01/2018 43215 sham F POST OFFICE 2014  12/02/2018 45678 geeta M POST OFFICE 2015 12/03/2018 45677 **bleep**a F POST OFFICE 2016   12/04/2018 ; RUN; ... View more

Hi,   I have a sas dataset and in that dataset I have a column and there we should have 4 record in that column. for ie. JAN,FEB,MAR,APR. if any one is missing then its an issue and i have another icolumn with the name issue and that should get updated if any value is missing.     ... View more

Hi SAS Experts,   Could you explain me the given queries about SAS DI on the basis of given points.   #1. Commercial or Open source -- does SAS DI open source available ? #2. History --> what is the history of SAS DI ? #3. Pricing --> what is the basic cost of SAS DI ? #4. Popularty --> How popular SAS DI as compare to other tool ? how it is better as copare to other tools ? #5. Platform --> In which platform SAS DI works ? #6. Custom Codes --> How to write customs codes in sas ? #7. Learning --> How easy to learn sas as compare to other ETL tool such as talend ? #8. Deployment --> How's deployment process of SAS DI. Is it easy as compare to other ETL tools. #9. Re- usability --> Do the SAS DI transformations are reusable #10. Scheduling --> is it possible to do the scheduling in SAS DI and how we do that #11. Parallelism --> Does SAS DI support parallelism and how it works? #12. Backup & Recovery --> Does backup and recovery possible in SAS DI and how ?   Thanks in advance !   Thanks, Abhishek ... View more