Hello there, I am trying to change the date variable (original like "16798") to something like 01/01/1990 in PROC SQL. However, below the code seems not correct. proc sql;
create table class_bd as
select Birthdate format=date10.,
UPCASE(Name)
from
class_birthdate
where
Height >= 160.0
order by
Birthdate desc;
quit; This is the log: 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
68
69 proc sql;
70 create table class_bd as
71 select Birthdate format=date10.,
72 UPCASE(Name)
73 from
74 class_birthdate
75 where
76 Height >= 160.0
77 order by
78 Birthdate desc;
NOTE: Table CLASS_BD created, with 0 rows and 2 columns.
79 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
user cpu time 0.01 seconds
system cpu time 0.00 seconds
memory 5613.40k
OS Memory 26536.00k
Timestamp 11/05/2023 05:59:00 AM
Step Count 199 Switch Count 4
Page Faults 0
Page Reclaims 603
Page Swaps 0
Voluntary Context Switches 60
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 264
80
81 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
91 There is no error, but I got empty new table.
... View more