About larkjr18

abcde · ‎08-10-2017

As far as I know there is no solution for the colors. For the also question unfortunately NO. There is a way thought if you create a custom bar chart and insert more than one bar charts into it. Then you can see each stack with a different number.

kiranv_ · ‎07-21-2017

All the info you need is sashelp.vtable and you can get by below query. Two things to keep in mind . SASHELP.vtable is dictionary view. Any queries run against dictionary views will be slow or very slow. So always have where clause and also put the libname you want in upper case as shown in the code. proc sql ; select libname, memname, nobs as totalrows, nvar as totalcolumns from sashelp.vtable where libname in ('LIB1','LIB2'); quit;

ballardw · ‎03-31-2017

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.); /*<==== where does a value for char_dob come from?? it is not on the input statement*/ 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.); /* value assigned AFTER use above*/ Total_DOB = input(catx("/", month_dob, day_dob, year_dob),?? mmddyy8.);

larkjr18 · ‎03-30-2017

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

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?

Reeza · ‎03-30-2017

@larkjr18 wrote: Here is my code and I attached the output. Some of the data only extracted 3 digits and then randomly switches to extracting 4 digits? This is the problem i am solving Consider only the first 4 character digits of SSN, find the duplicate groups through By-group processing, and create a SAS data set for these observations. Present the screenshot of the partial SAS LOG, showing the number of observations in this subset of data. Show the output for “corrected SSN” variable using PROC PRINT (OBS=8);”. data hi.question4; infile 'C:\Users\larkj\Desktop\STUDENT.DAT'; input ssn 1-9; SSNc = put(ssn,9.); drop SSN; rename SSNc = SSN; SSN_New=substr(SSNc,1,4); run; proc sort data = hi.question4 dupout = SSN_New nodupkey; by SSN_NEW; run; proc print data=hi.question4; run;

larkjr18 · ‎03-29-2017

Here is my full code 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;

Kurt_Bremser · ‎03-28-2017

First of all, are month_dob, day_dob, year_dob numeric or character? In your code snippet you treat them as both, which is at least not sound programming practice. Assuming that they are numeric, I'd do Total_DOB = input(put(year_dob,z4.) !! put(month_dob,z2.) !! put(day_dob,z2.),yymmdd8.); if Total_DOB = . then do; if ((month_dob = 29) and (day_dob = 2)) then Total_DOB = mdy(3,1,year_dob)-1; else if day_dob = . then Total_DOB = mdy(month_dob,15,year_dob); end;

Jagadishkatam · ‎03-27-2017

Yes, if you want to make the zero to missing (.) then yes you could use your old code. But i think in the array you cannot separate the variables by comma as they will be considered as values , just separate the variables in array by space. array change(6) gpa sat satm satv act toefl; do i = 1 TO 6; if change(i) = 0 then change(i) =.; end;

Online Status	Offline
Date Last Visited	‎10-10-2017 05:14 PM

Finding the Number of Rows and Columns for each dataset in a library

Graphs legend changing the colors when I drill into the hierachy

Re: print only data with invalid dates

Re: calculating the average of multiple data points

Re: print only data with invalid dates

Re: calculating the average of multiple data points

Re: print only data with invalid dates

calculating the average of multiple data points

Re: Replacing Embedded blanks with 0's

Re: print only data with invalid dates

Re: arrays to change values to missing

Re: arrays to change values to missing

Re: Extracting the first non-zero digit from a numeric variable + dele...

Re: Graphs legend changing the colors when I drill into the hierachy

Re: Finding the Number of Rows and Columns for each dataset in a libra...

Re: print only data with invalid dates

Re: calculating the average of multiple data points

Re: Replacing Embedded blanks with 0's

Re: Extracting the first non-zero digit from a numeric variable + dele...

Re: where statement with missing char data points

Re: Using an if statement with an AND

Re: arrays to change values to missing