huang8012's replies:

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

how to combine two columns into one column 5 31 (5/13/2009 4:06:39 AM) comp.soft-sys.sas Hi, I have a dataset that has a column "Address 1" and "Address 2", how do = I combined them (with an space character seperating between the two)into = a single column "Address" . Thanks. ... jinto83 (18)

How to get particular variable names from a macro variable list 2 6 (5/17/2013 12:15:21 AM) comp.soft-sys.sas Hi, I have a macro variable which contains all the variable names in my data set. %let x = %varlist(reptdata); %put &x.; In the log it says "id date name sex age salary dx1 dx2 dx3" How can I get d... tingma.stanford (8)

PROC IMPORT #15 1 11 (3/27/2013 6:06:45 PM) comp.soft-sys.sas Dear colleagues, I have to use a proc import to import a csv file into SAS. There is a date that is not correctly read: the format MMDDYY10. is attributed whereas the true format is DDMMYY10. The option GUES... chaix (5)

Output 1 obs to 1 file 3 9 (4/3/2013 9:29:56 AM) comp.soft-sys.sas Hi to write all observations to an output, i can adopt this code as found on the internet : filename out "C:\hsb2.txt"; data _null_; set hsb2; file out; put @1 id @4 female @5 race @6 ses @7 prog @8... joceychin (9)

Pass different parameters to a macro call with changing libname 1 10 (4/3/2013 10:59:17 PM) comp.soft-sys.sas Hi All, I am wondering if there is efficient way to do this. Below, with each changing "lib=" there are several macro call to %test. The parameter X in each macro call is the same except each 'c' is followed... toosewho (13)

How to create an adjacency matrix in SAS 1 6 (4/8/2013 8:30:44 AM) comp.soft-sys.sas Hi all, I have an adjacency list like: id a b c 100 1 1 0 200 1 0 0 300 0 1 1 400 1 0 1 Where id is an unique identifier (e.g. a person) and a, b and c are dummy v= ariables for whether... nikolaynenov (1)

Running a Macro Stored on Web 2 9 (4/10/2013 2:10:45 AM) comp.soft-sys.sas Hello, I want to store my macro on the web where any computer will be to run it just by providing the internet address where the macro is store. For example, usually the first line of the macro call would... roger6778 (15)

How to check the consecutive lab results? 2 10 (4/11/2013 12:53:11 AM) comp.soft-sys.sas Dear All, I tried to identify the events for and ID who has consecutive SBP<70 and th= e length of each event. For example, for ID=3D1, it has two events: one fro= m 13:18 to 13:19 with length=3D2, another... nancy0318 (26)

What is wrong? 5 6 (4/11/2013 3:03:06 AM) comp.soft-sys.sas Is the following macros wrong? %macro merged ( data1, data2, data3); proc sql; create table $data3 as select a.*, b.* from data1 as a, data2 as b where a.id1=b.id2; quit; %mend; %merged (one, ... nancy0318 (26)

SAS counting process format 2 10 (4/14/2013 4:24:29 PM) comp.soft-sys.sas Hi All, I am doing proc phreg and need data in counting process format, seems extremely simple , but i am running out of ideas. but I cant do this.. My data looks like this ID Difference 1 34 1 48 ... harshaldeshmukh (7)