What is wrong with this code?
Data Mite;
Input obs time;
Cards;
0 8
1 14
0 17
1 20
;
Run;
data MItest;
set MIte;
if obs=0 then ttime=.; else ttime=time;
run;
Nothings wrong, it runs without error.
Why do you think something is wrong?
Remember we can't read your mind 😉
So if something unexpected is happening you need to explain what you expect and what isn't happening. Given what you've provided I have no idea what you want.
1 Data Mite;
2 Input obs time;
3 Cards;
NOTE: The data set WORK.MITE has 4 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.18 seconds
cpu time 0.01 seconds
8 ;
9 Run;
10 data MItest;
11 set MIte;
12 if obs=0 then ttime=.; else ttime=time;
13 run;
NOTE: There were 4 observations read from the data set WORK.MITE.
NOTE: The data set WORK.MITEST has 4 observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
Nothings wrong, it runs without error.
Why do you think something is wrong?
Remember we can't read your mind 😉
So if something unexpected is happening you need to explain what you expect and what isn't happening. Given what you've provided I have no idea what you want.
1 Data Mite;
2 Input obs time;
3 Cards;
NOTE: The data set WORK.MITE has 4 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.18 seconds
cpu time 0.01 seconds
8 ;
9 Run;
10 data MItest;
11 set MIte;
12 if obs=0 then ttime=.; else ttime=time;
13 run;
NOTE: There were 4 observations read from the data set WORK.MITE.
NOTE: The data set WORK.MITEST has 4 observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
There was no error, I had the data set opened,that is why
Sounds like you had an ERROR. Show the error from the Log and the code submitted that generated the error.
If you had posted something like
ERROR: You cannot open USER.JUNK.DATA for output access with member-level control because
USER.JUNK.DATA is in use by you in resource environment ViewTable Window.
we could likely have told you that you had the set or an explorer window about the contents open.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.