Because the variable length is already defined by the set statment as in the original data set.
When it will be 12? if the length statment come before the set statament. So order is very important here.
And if you have practicing SAS programming you will know that if you run this programe you will get a warning.
WARNING: Length of character variable jobcode has already been set.
Use the LENGTH statement as the very first statement in the DATA STEP to declare the length of a character variable.
And not 8 for two reasons the one mentioned above plus this length is not defined any where in the data step or the original data and it is char not number. where if it is number the max length is 8.
... View more
None.
To write to a file you need a DATA step with a FILE statement and a PUT statement.
So they are all wrong.
C and D are wrong for that plus that DSD and DLM are not specification parameter of the put statment but the File statments.
After that you need to be aware of the differeance between DLM and DSD and which will let you have the delimiter you specify.
Writing a SAS Dataset To a Text File
So this questions is copied wrong.
... View more
data Dte;
input birthdate $10.;
cards;
Jan1975
1977
021978
run;
data want ;
set Dte;
format date date9.;
if length(birthdate)=4 then date=input('11JUL'!!trim(birthdate),date9.);
else if length(birthdate)=6 then date=
input(substr(birthdate,1,2)!!'JUL'!!substr(birthdate,3,4),date9.);
else if length(birthdate)=7 then date=input('11'!!trim(birthdate),date9.);
run;
... View more
Your code should work. It may be other thing in your full code or with the data. I suggest you open new thread and post sample data with your full code. Then we could be more helpful.
... View more
data have;
input id date yymmdd10. time TIME.;
format time time.;
cards;
100020005 2015-08-27 08:36
100020005 2015-08-27 11:32
100020005 2015-08-27 14:51
100020008 2015-10-01 08:23
100020008 2015-10-01 10:56
100020008 2015-10-01 15:32
140020004 2014-12-18 13:13
140020002 2014-09-30 14:45
140020002 2014-09-30 17:20
;
run;
proc sort data=have;
by id date time;
run;
data want;
set have;
retain f;
by id date time;
if first.date then f=1;
if f=1 then point='PRE';
else if f=2 then point= '2H';
else if f=3 then point='7H';
f+1;
drop f;
run;
... View more
I understand all what you said. I was once working for SAS partner and yes we was forced to take the exams. I think that was good for the company profile with SAS. From my experience I advise you after carefully studying "Base Programming Prep Guide" and solve all the exercises at the end of each chapter. To spend good amount of time on the exam questions online because it will really make difference in passing the exam. I met people really understand and practiced all the topics in the exam and yet not able to pass it. And also people with years of experience in SAS and almost hardly pass the exam too. And I am sure that you figured out after solving some questions this time that it is almost the same questions you saw in the exam and even not updated from years. And sorry to say that but I met people not fully aware of the exams topics, without experience, and very hardly can write job or task in SAS. But they got > 90% in the exam, as they went through the exam dump several times and studied what the exam tricks and focus points.
Regarding it focus on reading from file or text, I cannot say this is bad thing, as this is very important in academia and research where many dataset are in this form. Even if it is not in industry. And even making practicing and testing easier and less time consuming.
But the general advice _based on myself and colleges experience_ spend time on the online previous questions or take SAS Certification Practice Exam: Base Programming for SAS 9.
What I hope in the future and as SAS expand their certifications set to improve the exams and make beta versions to the test and get people feedback and maybe experienced SAS community members could be good for that.
Regarding SAS for real world situations i think other gave you good advices and i post about that in the future too.
All the best
... View more
data want ;
set have;
by id;
retain ttype pflag;
if first.id then do; ttype=type; pflag=0; end;
else if (type ne ttype) and (pflag=0) then do; output; pflag=1;end;
keep id;
run;
... View more
You may need to
select distinct a.var1
if the value could be repeated in each column more than one time. Or you will end up by long list.
... View more
