SAS Support Communities

larkjr18 · ‎07-21-2017

Hey guys, I'm relatively new to SAS and am trying to write a piece of code in SAS enterprise that finds the number of rows and columns for each data set in a library of 20 or so datasets. I know I need some sort of macro and possibly a nobs= statement but overall I'm generally lost. Any tips or suggestions to point me in the right direction would be much appreciated.

larkjr18 · ‎05-31-2017

When you cick from the stacked bar to one of the hierachy sections below the color of the legend items gets all jumbled. Also wondering how I can add values to each portion of the stacked column. Ex putting 671.9 in the 2017 column in the blue section.

larkjr18 · ‎03-30-2017

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

larkjr18 · ‎03-30-2017

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

larkjr18 · ‎03-30-2017

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?

larkjr18 · ‎03-30-2017

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.

larkjr18 · ‎03-30-2017

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;

larkjr18 · ‎03-30-2017

Create a SAS data set for observations starting with the 10th and ending with the 40th based on the female-master-applicant data set, which you have created for item 5. Use the appropriate data set option and the assignment statement or the SUM statement to calculate the average GPA (Ave_GPA) for those 31 students. Show the average GPA (i.e., the value of the Ave_GPA variable) from SAS Log or PROC PRINT output. This is the general code I have right now: data hi.femalesq6; infile 'C:\Users\larkj\Desktop\STUDENT.DAT'; input SSN 1-9 sex $ 11 type $ 19 GPA 50-53; run; proc print data=hi.femalesq6(firstobs= 10 obs=40); where sex='F' and type='M'; run; When I add some kinda sum statement it just seems to create a new variable and print the same numbers as the gpa.

larkjr18 · ‎03-30-2017

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

larkjr18 · ‎03-30-2017

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

larkjr18 · ‎03-30-2017

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.

larkjr18 · ‎03-30-2017

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

larkjr18 · ‎03-29-2017

That worked great, don't know why I didn't do that before. Thank you

larkjr18 · ‎03-29-2017

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;

larkjr18 · ‎03-29-2017

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