how to handle in stream data containing semicolon in it?
Answers were Sorted based on User's Feedback
Answer / paul
data dummy;
input Name $ Remarks $15.;
cards4;
aaa 123;aaa;23;M
bbb 132;bbb;26;F
ccc 133;ccc;24;F
;;;;
run;
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / n katepalli
we can also use datalines4 as well as cards4
Is This Answer Correct ? | 2 Yes | 0 No |
Hi, I have one dataset like id date ex: id date 1 13 1 13Oct2011 2 14 2 14Oct2011 3 15 3 15Oct2011 --->this is the current date here i want date format like 13Oct2011,14Oct2011 how we can modify the numeric to date format plz answer.
How do dates work in sas?
What is _n_?
In the SAS Data step what is the difference between the subsetting done by Where and subsetting done by If?
What are the applications primarily used by business analyst? : Sas-bi
I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com
what is _error_?
2 Answers Axis Bank, Cognizant, JPMorgan Chase,
Which statement does not perform automatic conversions in comparisons?
Describe what are the different levels of administrative users in sas? : sas-grid-administration
What is the Program Data Vector (PDV)? What are its functions?
What is the pound sign used for in the data_null_ ?
/* 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;