Isn't that what the length statement does? Create the num_dob variable? ... View more

Just figured out that I had by and not var thank you for the help though. ... View more

Sorry there's just alot to do with little time so I've been racing through the code. I guess I don't truley know the order of operations. Do you think you could expand on your hint? ... View more

When I tried proc means yesterday it didn't work. Here is my code for it.   proc means data=hi.femalesq6(firstobs=10 obs=40); where sex='F' and type='M'; by GPA; run;   Also posted a picture of the output. ... View more

Sorry about that, here is my relevant code right now:   libname hi 'C:\Users\larkj\Desktop'; proc format library = hi; value season 1='Fall' 2='Spring' 3='Summer'; value $sx 'M'='Male' 'F'='Female'; value race .='Missing' 2='Hispanic' 3='Puerto Rican' 4='Mexican American' 5='Asian American' 6='Caucasian' 7='American Indian' 8='African American' 9='Other'; ; run; options fmtsearch=(hi); data hi.student (drop=i); infile 'C:\Users\larkj\Desktop\STUDENT.DAT'; length num_dob 8; input ssn 1-9 sex $ 11 term 17 type $ 19 div $ 21-24 major 26-30 ed $ 32 state $ 34-35 sat 37-40 satm 42-44 satv 46-48 gpa 50-53 rank 55-58 act 60-63 toefl 65-68 honor $ 70 ethnic 72 year_dob 101-102 month_dob 103-104 day_dob 105-106 ; num_dob= input(char_dob,mmddyy10.); if char_dob eq '0' then call missing(num_dob); else num_dob=input(char_dob,mmddyy10. ??); Char_DOB = input(catx("/", month_dob, day_dob, year_dob),?? mmddyy8.); Total_DOB = input(catx("/", month_dob, day_dob, year_dob),?? mmddyy8.); if ((month_dob = 02) AND (day_dob= 29)) then Total_DOB = mdy(03,01,year_dob)-1; else Total_DOB = mdy(month_dob,15,year_dob); format Total_DOB mmddyy8. term Season. sex $Sx. ethnic Race.; array change (6) gpa sat satm satv act toefl; do i = 1 TO 6; if change(i) = 0 then change(i) = .; end; Char_DOBc = put(Char_DOB,mmddyy8.); drop Char_DOB; rename Char_DOBc = Char_DOB; run; PROC CONTENTS DATA=hi.student; RUN; proc print data=hi.student; format term Season. sex $Sx. ethnic Race. Total_DOB mmddyy8. ; run; proc print data=hi.student; where num_dob=.; var SSN Total_DOB; run;   Here is my problem that the log is saying: 2359 proc print data=hi.student; 2360 where num_dob=.; ERROR: Variable num_dob is not on file HI.STUDENT. 2361 var SSN Total_DOB; 2362 run;   ... View more

Wow that worked great thank you!!! It is still printing all the other observations but just as 0's any way to stop that? ... View more

Hmm the proc print statement is still tell me num_dob is not on file in hi.student. ... View more

Do I need to create the num_dob var before I can run your code?   I assumed that since there is a var=put statement in your code it would create it but when I try to run the proc print it says it can't find num_dob in the set. ... View more

The z9. worked great is there any way to create a new data file with just the observations that added the extra 0's? ... View more

Here is my code: I also added pics of the data set and proc contents   libname hi 'C:\Users\larkj\Desktop'; proc format library = hi; value season 1='Fall' 2='Spring' 3='Summer'; value $sx 'M'='Male' 'F'='Female'; value race .='Missing' 2='Hispanic' 3='Puerto Rican' 4='Mexican American' 5='Asian American' 6='Caucasian' 7='American Indian' 8='African American' 9='Other'; ; run; options fmtsearch=(hi) data hi.student (drop=i); infile 'C:\Users\larkj\Desktop\STUDENT.DAT'; input ssn 1-9 sex $ 11 term 17 type $ 19 div $ 21-24 major 26-30 ed $ 32 state $ 34-35 sat 37-40 satm 42-44 satv 46-48 gpa 50-53 rank 55-58 act 60-63 toefl 65-68 honor $ 70 ethnic 72 year_dob 101-102 month_dob 103-104 day_dob 105-106 ; Char_DOB = input(catx("/", month_dob, day_dob, year_dob),?? mmddyy8.); Total_DOB = input(catx("/", month_dob, day_dob, year_dob),?? mmddyy8.); if ((month_dob = 02) AND (day_dob= 29)) then Total_DOB = mdy(03,01,year_dob)-1; else Total_DOB = mdy(month_dob,15,year_dob); format Total_DOB mmddyy8. term Season. sex $Sx. ethnic Race.; array change (6) gpa sat satm satv act toefl; do i = 1 TO 6; if change(i) = 0 then change(i) = .; end; Char_DOBc = put(Char_DOB,mmddyy8.); drop Char_DOB; rename Char_DOBc = Char_DOB; run; PROC CONTENTS DATA=hi.student; RUN; proc print data=hi.student; format term Season. sex $Sx. ethnic Race. Total_DOB mmddyy8. ; run; proc print data=hi.student; where Char_DOB = '.'; var SSN Total_DOB Char_DOB; run; ... View more

I'm getting this in the SAS log when I run it NOTE: No observations were selected from data set HI.STUDENT. NOTE: There were 0 observations read from the data set HI.STUDENT. WHERE Char_DOB='.'; NOTE: PROCEDURE PRINT used (Total process time): real time 0.01 seconds cpu time 0.01 seconds ... View more