To create a zero observation dataset with column specifications:   DATA work.MEMBER; LENGTH NAME $ 28 DOB 4; FORMAT DOB DATE9.; INFORMAT DOB DATE9.; STOP; RUN; It is same like Create Table doing PROC SQL.   proc sql; create table work.member (Name varchar(28) , DOB num format date9. ); quit; ... View more

data input_extract; set input; len = length(str); do i =1 to len; len1 = len -2; sub_str = substr(str,1,len1); end; run; ... View more

Consider  a txt file: 1 2 3 4 5 6 7 8 9 10 11   data missing1; infile "C:\Users\sachin\Desktop\SAS\DataSet\Learning\missing.txt" pad; input x y z; run; after execution  you will get 3 records and 3 observations. after that update and change it ot truncover instead of pad   data missing1; infile "C:\Users\sachin\Desktop\SAS\DataSet\Learning\missing.txt" truncover; input x y z; run; this will run absolutely fine.   But if you  write missover instead of truncover that also works over here but not always.   Consider one more file: 001Josuha Tyson 88 002Helen Ames 75 003ShouEn Lu 004Pam Mann   data short; infile "C:\Users\sachin\Desktop\SAS\DataSet\Learning\short.txt" pad; input Subject $ 1-3 Name $ 4-15 Quiz 17-20 ; run; run with pad, truncover and missover. Will work with pad and trunover but not with missover   My concern is to show truncover can be used in any situation for missing values. It has effect of the PAD and missover options combined and is a good overall choice for the INFILE option when you are reading "variable length" record.   I hope this helps!!! ... View more

NameHard = upcase(first(Name)) || substr(Name,2,length(Name));   You need to get first letter in caps with upcase and first function After that with substring function get the last letters with length function. ... View more