Hi I would like to pull out the first 8 digits to the left of the number........the numbers marked in yellow should be discarded..... 295999335 295999333 295999336 295999337 Thanks ... View more

Hi, I have a character variables with recoreds of different lengths like 8,9,10,11,12,13,13.... i want to write a code in such way that i want to pull out only last 8 charcters of that variable....only last 8 charaters irrespective of the varaible lenght. thanks ... View more

Hi, I have dataset X with variables COL1 TO COLN.... I wanted to create new varaible to concatenate all collumns sepeareted by delimiter..... COLN coule be col20 or col25...so it has to be generalised for all col starting with COL.... I TRIED THIS WAY BUT NOT WORKING.... data _null_;    separator='%%$%%';    col1='The Olympic  ';    col2='   Arts Festival ';    col3='   includes works by ';    col4='Dale Chihuly.';    result=catx(separator,col:);    put result $char.; run; . ... View more

I Have dataset with numerical id as variable. I would like to write a code in a such way that i get red colored below out put. 40047915 -------Truncate 40 if it starts with 40 and the length is 8             40047916 40047917 400032724 400032725 400032726---------- Truncate 400 if it starts with 400 and the length is 9 047915 047916 047917 032724 032725 032726 ... View more

I have a library X with N number of datasets……I want to write a macro in such a way that it will check all the datasets and outputs metadata of all datasets with additional column of COMMENT saying variable is Null for all records or not. EX: We have library with two dataset( but we have N number of datasets) AE and CE with below variable. I would like to output all the variables in the datasets and display if that variable is null for all records or not….. SASNAME         COMMENTS CESPID                             Null CETRTNY                         Not null CEENDTC                        Not null CEENDY                           Null SASNAME         COMMENTS AEBDSYCD               Null AEHLGT                    Null AEHLT                      Not null AEHLTCD                 Not null AELLT                      Not null AELLTCD                Not null AEPTCD                 Not null AESOC                   Null AESOCCD               Null ... View more

I Have a dataset with 5 variables a, b, c, d and e I have to write a program to find out if the variable is null(individual vaaribles) for all recs. If so, then output ‘NULL’ to Comment column. ... View more