SAS

PLEASE HELP...........problem in Merge ...
Hi all, The input dataset is as follows: data sample; input id a b c; cards; 2 11 . . 2 . 44 . 2 . . 66 1 55 . . 1 . . 99 1 . 22 . ; I want the output as id a b c 2 11 44 66 1 55 22 99 The input dataset is not in sorted order by id . As my data is huge, i can NOT sort the Sample dataset by Id. I... 23 Mar 2010 01:14

Unable to sort dataset with 6.7 Million records. ERROR: Utility file write failed. Probable disk full condition.
Hi all, Below is the code, I am trying to run. proc sort data=ftf_out.want1 out=ftf_out.want(drop=n _name_); by PLTK_PLAN_ID; run; Dataset want1 has 6.7 Million records. I am getting error as ERROR: Utility file write failed. Probable disk full condition. I tried few options like changing the location of U... 22 Mar 2010 20:39

How to debug a SAS program?
By that I mean just scan the program to check for syntax errors and not actually process the data but assume that all datasets exist. My client won't give me access to Oracle where the data reside and I am writing the program rather blindly. ... 22 Mar 2010 02:46

How to merge with duplicate observation on both sides
Hi, If I have two files like this: Left.csv: ID Value1 1 a 1 b Right.csv ID Value2 1 c 1 d Note the ID is duplicate. I want to merge by ID (most other observations that not duplicate like this pathological example) but how do I merge the two files so that every possible combination of v... 21 Mar 2010 19:42

What is the right statistical procedure?
Hi, Sorry this is more of a statistical question . I have data on the specific date when states adopt mandatory insurance laws and I also have survey data on car dealerships. I want to investigate the whether dealers profit increase after adoption of mandatory insurnace state laws. The problem is that the su... 21 Mar 2010 18:34

How to run a loop?
Hi suppose I have a bunch of libraries called CARSALE CARBRAND CARWEIGHT In each library there is a file called COUNT How do I run a loop so that I can run proc means on each one of the libraries imaginary code: array list(3) list1 list2 list3 ('carsale','carbrand','carweight'); for i 1 to dim(list); d... 22 Mar 2010 11:51

unistats powerpoint show
I thought I would remind people that you can download a free clinical reporting system from my web site. http://www.datasavantconsulting.com/roland The reporting system is called Spectre-Clinical. It has two major macros for producing reports named %unistats and %npcttab. %unistats produces summary statistics ... 21 Mar 2010 10:29

Could anyone help me to figure out what the meaning of this code?
Hi I tried to prefix some variables and found someone wrote a solution already. But there is one part of the codes that I am not so sure. Could anyone answer it for me? Thanks data _null_; set sashelp.class (obs=1); array nu _numeric_; length renl $200; renl=''; do over nu; renl=trim(renl)||' '||vname(n... 24 Mar 2010 02:13

getting unique ID observations
This is yet a simple question which I am not knowing how to do in sas: I have a longitudinal dataset and I need to get how many unique observations there are for each variable. For example, if i have 5430 subjects and 80,000 observations. how do I get unique observations for each variable based on the 5430 (how... 24 Mar 2010 19:19

Sort Large Dataset
Dear SAS users, I know this is a common question. I have googled but could not find a good solution. basically I have a huge dataset ~7GB with 3 variables and 2 billion observations. I just need to sort it by one variable. What is the best solution for my task? thank you so much claus ... 20 Mar 2010 21:03