About archibald

archibald · ‎06-20-2016

Hi, Using this syntax in SAS Age= (graduationdate-dob)/365.25; and using the equivalent in spss Compute Age= (graduationdate-dob)/365.25. I get the same exact result. In SPSS, the present code takes into account leap year. but the issue is in SAS to accurately calculate age while taking into acount leap year the folllowing should be used syntax 3- Age= ('year' dob, graduationdate, 'continuous') OR syntax 3- Age= intck('year', dob, graduationdate) - (put(dob, mmddyy4.) > put(graduationdate, mmddyy4.)). However results from syntax3 or syntax4 are not similar to that of the SPSS code. Does anyone know why this discrepancy? thanks.

archibald · ‎06-19-2016

Great! Thank you very much Reeza

archibald · ‎06-19-2016

Great! Thank you very much

archibald · ‎06-19-2016

This makes a lot sense.Thanks a lot!

archibald · ‎06-19-2016

Hi , I need to calculate age at graduation. I was wondering if any of the two methods below are appropriate and take care leap years as well. Method 1: Age= INTCK('year',dob,graduationdate,"C") Method 2: Age= (graduationdate-dob)/365.25 Thank you very much

archibald · ‎06-05-2016

Thank you PGStats!

archibald · ‎06-01-2016

Updates: I want to select all female students in all grades except grade 3 to run a proc tabulate, but I am getting this error . Is there a solution to this without listing grade 1,2,4,5,6,and 7 in the "where" statement. Thank you. proc tabulate data= new; where sex=2 and grade ne 3; ERROR: WHERE clause operator requires compatible variables.

archibald · ‎06-01-2016

I want to select all female students in all grades except grade 3 to run a proc tabulate, but I am getting this error . Is there a solution to this without listing grade 1,2,4,5,6,and 7 in the "where" statement. Thank you. proc tabulate data= new; where sex=2 and grade ne 2; ERROR: WHERE clause operator requires compatible variables.

archibald · ‎05-18-2016

You saved the day! thank you very much!

archibald · ‎05-18-2016

Another great solution. Thank youvery much!

archibald · ‎05-18-2016

This is perfect!Thank you very much!

archibald · ‎05-18-2016

@sowmya not all the data will need a trailing zeros, as you can see on what the result should look like. Thanks!

archibald · ‎05-18-2016

I have a character variable internship_date in the following format (20000130) and would like to get the week days? Any ideas? Thanks

archibald · ‎05-17-2016

Hi , I need to add trailing zeros and period field, any help would be appreciated. data have; Input alpha : $5.; cards; 00100 1019 099 185 1010 0803 12398; run; data want; set have; test1=substr(alpha,1,3)||'.'|| substr(alpha,4,2); /* add a period to fields*/ run; In addition to adding a period , I would want to add trailing zeros so to have : test1 001.00 101.90 099.00 185.00 101.00 080.30 123.98;

archibald · ‎04-26-2016

here you go array cab_array{20} cab_1 - cab_20; array tax_array{20} taxcode1- taxcode20; do i=1 to 20; taxcode {i}= substr(cab_array{i},1,5); end;

Online Status	Offline
Date Last Visited	‎11-22-2016 10:33 AM

Re: adding period

Re: adding period

adding period

Re: efficicient coding

Re: efficicient coding

efficicient coding

Re: format date

format date

Re: error in merging : Multiple lengths were specified for the BY vari...

Re: character variables to numerical variables

Re: adding period

Re: adding period

Re: compute age from two dates

Re: compute age from two dates

Re: proc tabulate -where statement

Re: determining weekdays character variable

calculating age difference between SAS and SPSS

Re: compute age from two dates

Re: compute age from two dates

Re: compute age from two dates

compute age from two dates

Re: proc tabulate -where statement

Re: proc tabulate -where statement

proc tabulate -where statement

Re: determining weekdays character variable

Betreff: adding trailing zeros & period to fields

Re: adding trailing zeros & period to fields

Re: adding trailing zeros & period to fields

determining weekdays character variable

adding trailing zeros & period to fields

Re: array and trim