pearsonmelody's articles:

Items(21) /3 Next >> Last >|

Calculate Percent using proc report 1 782 (5/19/2010 2:37:57 PM) comp.soft-sys.sas proc sql; create table new_file as select code, A , B1, B2 from myfile; quit;run; I have the following dataset and need to create a report with a percentage to be calculated in. For some reason,... Ya

Date Type of MM-DD-YYYY and MM-YY 0 20 (8/12/2009 2:13:05 PM) comp.soft-sys.sas Does anyone know what's the date type of MM-DD-YYYY and MM-YY? I found MM-DD-YYYY as IS8601DA. but while tyring to convert it, the field stay as numeric. I can't find what's the date type for MM-YYYY Are the... Ya

Convert Date from charct into MMDDYY10 type 0 24 (8/11/2009 7:20:27 PM) comp.soft-sys.sas These date were read in as charct from a .dat file, how can I convert the date field back to MMDDYY10.? I used the code below but have errors returned back: data readin2(drop=incre_date recv_date Notify_Date P... Melodyp

Question about Date (month, year) 0 21 (7/15/2009 5:51:45 PM) comp.soft-sys.sas Dear all, I have two datasets and would like to match by date and another field. The date in one file is 01JAN2009 and another file is 15JAN2009, so I need to: 1. substr only month and year from each file an... Melodyp

Proc Score question 0 19 (7/8/2009 2:54:47 PM) comp.soft-sys.sas Dear all, Does anyone know how to using Proc Score along with Proc Discrim? proc discrim data= train pool=test outstat= disc; priors equal; class y; var &varlist; run; proc score data= validation out =score... Melodyp

Proc Score with Proc Discrim 0 19 (7/7/2009 6:31:43 PM) comp.soft-sys.sas Is it possible to use Proc Score on the dataset generated by Proc discrim? In the following codes, what the TYPE shoudl be? proc discrim data= train pool=test outstat= disc; priors equal; class y; var &varlist... Melodyp

SAS macro #4 2 25 (7/6/2009 3:57:07 PM) comp.soft-sys.sas I have 5 dataset contains same variables with different months information, month is not a variable in the file. I need to append these file together and want to also keep the information that which observatio... Melodyp

SAS Macro Problem #3 2 41 (6/23/2009 2:12:42 PM) comp.soft-sys.sas I made the following macro, my intention is: if there is a color as coded in the ref# then a new field ref#_color will be created. Instead of giving me result in ref1_color, ref2_color .. ref3_color, SAS only... Melodyp

SAS Macro problem #2 0 21 (6/23/2009 2:03:18 PM) comp.soft-sys.sas I made the following macro, my intention is: if there is a color as coded in the ref# then a new field ref#_color will be created. Instead of giving me result in ref1_color, ref2_color .. ref3_color, SAS only... Melodyp

How to read CSV file with Percentage into SAS 0 25 (6/6/2009 11:29:12 AM) comp.soft-sys.sas I have a data set it looks like: COST AVG_COST MARGIN AVG_MARGIN PER_MARGIN 3565.00 155.00 178.25 7.75 4.76% 483.00 483.00 24.15 4.15 4.76%... Melodyp

pearsonmelody's replies:

Items(24) /3 Next >> Last >|

Re: How to transfer all missing value all at once? #2 2 18 (3/17/2008 2:24:01 PM) comp.soft-sys.sas trying to offer something, but copy&paste mess the thing up. Sorry! the program should look like this, data melody.combine_final_5; set melody.combine_final_4; array num {*} _numeric_; array char {*} _cha... zhangyu05 (659)

Re: Data Step or SQL problem: updating "Not_Done" records with #2 1 16 (4/22/2008 8:01:48 PM) comp.soft-sys.sas Mary, Here is something rather primitive to at least get the discussion started. data set1; informat id $10. snp1 $10. snp2 $10. snp3 $10.; infile cards; input id $ snp1 $ snp2 $ snp3 $; cards; 415-99 CC GG N... JClark1 (432)

Re: Method to identify missing value #3 1 24 (3/30/2009 7:57:11 PM) comp.soft-sys.sas hi ... for some details of the discussion referred to by Joe, you could also take a look at http://www.sascommunity.org/wiki/Shed_observations_with_all_variables_missing -- Mike Zdeb U@Albany School of Public... msz03 (782)

Re: How to read CSV file with Percentage into SAS 3 19 (6/6/2009 12:23:49 PM) comp.soft-sys.sas I suspect you are using UNIX to read this file. ?? Because the data you posted is ok, with program below. Althought it is not CSV. Sure it is not tab delimited. See if using TERMSTR option CRLF will allow ... iebupdte (1746)

SAS macro #4 2 25 (7/6/2009 3:57:07 PM) comp.soft-sys.sas I have 5 dataset contains same variables with different months information, month is not a variable in the file. I need to append these file together and want to also keep the information that which observatio... pearsonmelody (50)

Re: SAS macro #18 1 22 (7/6/2009 4:05:24 PM) comp.soft-sys.sas No macro needed. data all; set janfile(in=a) febfile(in=b) marfile(in=c); if a then month='Jan'; else if b then month='Feb'; else if c then month='Mar'; run; If you have 9.2 there is INDSNAME data set option ... snoopy369 (1752)

Re: Proc Score question 2 20 (7/8/2009 3:53:21 PM) comp.soft-sys.sas I'm not sure but I don't think you use PROC SCORE. Perhaps this usage note will be helpful. Usage Note 23213: How do I score new data or classify new observations when using METHOD=NPAR with the DISCRIM proce... iebupdte (1746)

Re: Question about Date (month, year) 2 23 (7/15/2009 6:22:26 PM) comp.soft-sys.sas hi ... if you want to make the dates the same in both files, here's one suggestion use the the MONTH and YEAR functions nested within the MDY function * change the second date to the 1st of the same month and... msz03 (782)

Re: Convert Date from charct into MMDDYY10 type 1 24 (8/11/2009 7:42:12 PM) comp.soft-sys.sas Use INPUT. dateval = input(charval, MMDDYY10.); -Joe On Tue, Aug 11, 2009 at 2:20 PM, Melodyp wrote: > These date were read in as charct from a .dat file, how can I convert > the date field back to MMDDYY1... snoopy369 (1752)

Re: Convert Date from charct into MMDDYY10 type #2 1 38 (8/11/2009 9:04:34 PM) comp.soft-sys.sas It should change the value to numeric date. Then you can format that numeric date howsoever you choose with a FORMAT statement. -Joe On Tue, Aug 11, 2009 at 3:19 PM, Melodyp wrote: > On Aug 11, 3:42 pm, sn... snoopy369 (1752)