I haven't merged any datasets, this data is imported from another database where it is manually entered. This is actual data I need to work on.
Kind regards,
Bhanu
Hi Guys,
Thank you for your solutions but my question is bit weired now I want to make it clear. Under the colume Value:I want to subtract 1st row from 5th row, 2nd row from 6 th, 3rd from 7th, 4th from 8th. assume that there are no other columns (because hours are not always same).
if you...
Thank you Mr. Chris.
Could you please tell me the use of substr function for numerical values is it same as for charecters. Here is example
data work.AreaCodes;
Phonenumber=3125551212;
Code='('!!substr(Phonenumber,1,3)!!')';
run;
answer is ( 3).
Thank you Mr. Chris.
Could you please tell me the use of substr function for numerical values is it same as for charecters. Here is example
data work.AreaCodes;
Phonenumber=3125551212;
Code='('!!substr(Phonenumber,1,3)!!')';
run;
answer is ( 3).
hai,
I am a starter in SAS and while I was doing the following progrmme I found answer as 'length 7' and 'under 6'. I want explenation how it does.
data fltaten;
input jobcode $ salary name $;
cards;
FLAT1 70000 Bob
FLAT2 60000 Joe
FLAT3 30000 Ann
;
run;
data desc;
set fltaten;
if...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.