About jamie0111

jamie0111 · ‎04-29-2017

Hi there. I have a column name 'checkoutday' Each row has check out day information like checkoutday 20160818 20160911 20160730 ... And I want to add 65days to each row. So I tried to add 65days to each row like Data want ; set From; wantdate = checkoutday + 65; run; Data want; set from; wantdate = input(checkoutday, yymmdd8.) + 65; format wantdate yymmd8. ; run; But it didn't work Any tips or help will be much appreciated. Thanks.

jamie0111 · ‎03-26-2017

Hi! The 2858 sample score's average does not have to be exactly 564. I will do sampling many times until I have average 560~570. Anyway, thanks for your big help!!

jamie0111 · ‎03-24-2017

I have 1million people's score. Each people's score is between 400 and 650; I want to extract sample(exactly 2858 person's score information) and I also want sample score's average is 564. How can I extract this information?? Any helps and tips will be much appreciated. Thanks, Jamie.

jamie0111 · ‎03-24-2017

I can't understand what you mean.. sorry... Please explain more detail?? Thanks, Jamie.

jamie0111 · ‎03-24-2017

I think score between 560-565 sampling will be much better. Then, how can I limit the range of score of sampling...? Your help will be much appreciated! Thanks, Jamie.

jamie0111 · ‎03-24-2017

Hi, there. I have big data(exactly 2,770,880 rows and more than 200 columns). I want to make column name member with each rows number. The result will be column A column B ...... member 1. 245 250 1 2. 250 255 2 3. 255 260 3 4. 260 270 4 ... ... ... Any help and tips will be much appreciated! Thanks, Jamie.

jamie0111 · ‎03-23-2017

Hi, there. I have large data containing 20,000 people's total test score. ex) Total Score member1 727 member2 566 member3 661 member4 525 member5 609 ....... I want to extract exactly 2,818 people's information. And I also want to 2,818 people's average total score is between 560~565. Any help and tips will be much appreciated ! Thanks, Jamie.

jamie0111 · ‎03-22-2017

I have a table ( l column and 2000 rows). And I want to double 2000 rows. The result should be 1column and 4000 rows. But I can't find the function... Any help and tips will be much appreciated. thanks . jamie.

jamie0111 · ‎03-21-2017

I have one column that demonstrate each people's birthd. Column contains 2million people's information(each are different and format yymmdd8. / ex : 19910111) I want to dadd 65days to each people's birthd. Much help appreciated. Thanks. Jamie.

Online Status	Offline
Date Last Visited	‎05-02-2017 06:16 PM

How can I add 65days to yymmdd column.

Re: How can I extract sample with desired statistics

How can I extract sample with desired statistics

Re: How to make column with each row's number

Re: How to random sample with desired aggregate statistics

How to make column with each row's number

How to random sample with desired aggregate statistics

How to double the data

how can I add days to yymmdd date column

Re: how can I add days to yymmdd date column