Help on using RANUNI in proc SQL Chalanachithram.com | Topics | Search
Hide Clipart | Log Out | Register | Edit Profile

Last 30 mins | 1 | 2 | 4 hours     Last 1 | 7 Days

Chalanachithram.com DB » TF Industry related » Archive through March 07, 2013 » Help on using RANUNI in proc SQL « Previous Next »

Author Message
Top of pagePrevious messageNext messageBottom of page Link to this message

Kalikaalam
Side Hero
Username: Kalikaalam

Post Number: 7113
Registered: 01-2008
Posted From: 171.159.192.10

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, March 07, 2013 - 11:02 am:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)


Dma:

did you try using ranuni(date)?




I don't think that is the right syntax.
Top of pagePrevious messageNext messageBottom of page Link to this message

Dma
Side Hero
Username: Dma

Post Number: 8277
Registered: 11-2009
Posted From: 74.92.229.89

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, March 07, 2013 - 10:13 am:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)

did you try using ranuni(date)?

I am not a SAS User. but, I used similar before.
Top of pagePrevious messageNext messageBottom of page Link to this message

Kalikaalam
Side Hero
Username: Kalikaalam

Post Number: 7112
Registered: 01-2008
Posted From: 171.161.160.10

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, March 07, 2013 - 06:34 am:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)

SAS experts nundi help kaavaali.Random gaa 75 accounts kaavaali. Month lo date 1 nunchi date 31st varaku different transactions tho data vuntundi. DATASET lo 8 columns vunnaayi.Example:Account number, Sales, Date etc..I used a code like

Proc sql outobs=75;
Create table XXX.DATASETRandomSamples as
Select *
from XXX.DATASET
order by ranuni(0);

Idi yela work avuthundi??Nenu inthaku mundu company lo vunna RANUNI function ni copy chesaanu.

Total gaa 10,000 Accounts vunte, account numbers ni maatram random gaa pick chesthondi. Maa manager yemo, "vachina accounts anni month loni first 2-3 days lovi maatrame vasthunnaayi.30 days lo anni dates lo nunchi random gaa pick cheyyaali" ani aduguthondi.yelaa cheyyaali?? Particular gaa aa DATE ane column nunchi maarame random gaa pick cheyyalai ante, yemi cheyyaali?

Add Your Message Here
Post:
Bold text Italics Underline Create a hyperlink Insert a clipart image HASH(0x9fc4448){Movie Clipart}
Show / hide regular icons selection options

Click on following links to open cliparts by Alphabetical Order

 A   B   C   D   E   F   G   H   I   J   K   L   M  

 N   O   P   Q   R   S   T   U   V   W   X   Y   Z  

Show / Hide Filmy icons selection options

Click on following links to open cliparts by Alphabetical Order

 A   B   C   D   E   F   G   H   I   J   K   L   M  

 N   O   P   Q   R   S   T   U   V   W   X   Y   Z  

Username: Posting Information:
This is a public posting area. Enter your username and password if you have an account. Otherwise, enter your full name as your username and leave the password blank. Your e-mail address is optional.
Password:
E-mail:
Options: Enable HTML code in message
Automatically activate URLs in message
Action: