how to read character value without using substr function in
sas ?
Answers were Sorted based on User's Feedback
Answer / smit
Scan function can be used
SCAN(string, count<,charlist <,modifiers>>)
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / vaibhav wadhera
Hey
You can use the SUBSTRN function to Read the Character
Value.....
ALso it will be more clear that what you want to do after
reading character value...
| Is This Answer Correct ? | 1 Yes | 4 No |
How do you convert basic cube to transaction cube and transaction cube to basic cube?
How the Excel file enter into the SAS environment without Code of Infile & Import procs,if i have no file Conversion?
i want to upload titles and footnotes to excel file?how it is possible?
Tell me more about the parameters in macro? : sas-macro
what is sas metadata server? : Sas-di
What is the difference between proportion and average?
what is sas? is a package or tool? give me introduction about sas?
Name and describe three SAS functions that you have used, if any?
What are the default statistics that proc means produce?
/* This is example of age caluculate wihtout to display perfect days and years in output window */ data age; retain dob "12jun2003"d now "24may2011"d; age1=now-dob; age=(now-dob)/365.25; years=int(age); days1=round((age-years)*365.25); months=month(now)-1; if days1 gt 30 and months in(12,10,8,6,4,2)then do; month1=days1/30.4375; month=int(days1/30.4375); if day(now)=1 then days=1; else days=round((month1-month)*30.4375)+1; drop days1 month1 month; end; else if days1 gt 30 and months in (1,3,5,7,9,11)then do; month1=days1/30.4375; month=int(days1/30.4375); if day(now)=1 then days=1; else days=round((month1-month) *30.4375); drop days1 month1 month; end; drop age age1; proc print data=age; format dob now date.; run;
What is the Program Data Vector (PDV)? What are its functions?
is data integration and etl programming is same? : Sas-di