Could I do this by Proc Export227 (11/10/2006 4:07:52 PM) comp.soft-sys.sas I have a dataset like following: Data test; a=1; b=0; run; Now I can export this test data to excel. PROC EXPORT DATA=WORK.test(where=(a=1)) OUTFILE= "C:\TEMP\test.xls" DBMS... smartie_zhuo
About books019 (8/8/2006 4:46:16 PM) comp.soft-sys.sas Hi There I am an data analyst and use the SAS two years.My platform is 9.Now,for my career advance purpose,I want to buy three kind of book. 1:The first ,I want to buy a book about SAS SQL,considering my two ... smartie_zhuo
Proc format #3221 (7/28/2006 12:58:56 AM) comp.soft-sys.sas Hi There My purpose is transfer all values which are lower than 10 to a char "<10". Then I use proc format to implement it. Proc format value fmt low-10='<10' but what surprise me is the range doesn't incl... smartie_zhuo
Tabulate and PCTN format030 (4/24/2006 8:18:34 PM) comp.soft-sys.sas Hi There >From SAS online help,I found a example.It works well except format.Its pctn outcomes show "Percent of row total | 47.06| 52.94| 100.00" How could I let it show as the format: Percent of ... smartie_zhuo
Assign macro variable a date value227 (1/11/2006 7:25:35 PM) comp.soft-sys.sas Hi There I want to assign a macro variable a date value,I want to assign 16710 instead of '01oct05'd. So,I do it as this way: %let sdate=%sysfunc(putn('01Oct05'd,8.)); and I can get 16710. But I want to know ... smartie_zhuo
Oracle,Proc SQL and performance230 (1/10/2006 2:11:08 AM) comp.soft-sys.sas Hi There my data reside in Oracle on remote server,I use PROC SQL access them.Following program is one of them: PROC SQL; connect to odbc(user=.......) Select * from connection to odbc (select a.x,b.y,c.z from ... smartie_zhuo
oracle 8 the complete reference cd rom346 (12/19/2005 3:00:22 AM) comp.databases.oracle.server Hi there I bought the book" oracle 8 the complete reference" ,but unfortunately,recently when I want to review it,I found I lost my cd rom .Does anyone know where I can download those code sample and data. Tha... smartie_zhuo
Input multiple raw file320 (12/14/2005 9:46:12 PM) comp.soft-sys.sas Hi There I use filevar to read multiple external files,but I found when my external file name include blank,for example "abc x y.txt " then SAS doesn't recognize it.If I removed the blank and changed the file ... smartie_zhuo
Confusing two books131 (12/11/2005 11:49:23 PM) comp.databases.oracle.server Hi There Recently,For new project's reason.I have to learn some Oracle SQL.Since I think example is the best way for self learning.I looked at the books on Amazon.But to my confuse,I found two books are very si... smartie_zhuo
SAS and Oracle #2125 (12/10/2005 1:55:29 AM) comp.soft-sys.sas Hi There Recently,I joined a project team.I found all data are stored in Oracle database.I have to access those data from SAS I know I can use libname and other techniques to connect to Oracle.I also know when ... smartie_zhuo
smartie_zhuo's replies:
Items(6) /1
about julian date244 (5/13/2005 1:06:56 AM) comp.soft-sys.sas Hi,there I ran SAS in mainframe,I have a variable in julian format,For example,"2005120".I read it by "S370fpd4" format.and then ,I try to convert it to SAS date/time format.I got the correct result if I use t... smartie_zhuo(58)
about IBM mainframe format244 (9/1/2005 3:20:08 PM) comp.soft-sys.sas Hi, I have a file,it include both positive and negative number,In cobol,it's defined as S9(6)V99,it length is 8. I try to use s370fpd3.2,s370fpd4.2 , s370fpd6.2 and even s370fpd6.2 to input,but SAS told me inva... smartie_zhuo(58)
Re: Proc summary #8128 (9/14/2005 5:56:49 PM) comp.soft-sys.sas Hi, PROC MEANS is the big brother/sister that grew out of PROC SUMMARY years ago. It will do what you want as shown below: data a; input id n1 n2; datalines; 1 2 3 1 3 4 2 4 5 3 5 6 3 8 7 ; run; proc me... mterjeson(1932)
Re: Question #8318 (11/21/2005 6:54:49 PM) comp.soft-sys.sas data primary; input a b c; if a ~=3D lag(a) then index =3D 1; else index + 1; datalines; 1 2 3 1 2 3 1 2 3 1 2 3 4 5 6 4 5 6 7 8 9 ; run; proc sort data =3D primary; by a index; run; data secondary; input a b ... liuwensui(938)
Re: SAS and Oracle #2250 (12/12/2005 4:38:16 PM) comp.soft-sys.sas When I had to learn Oracle, the first book that I picked up and read was Oracle Press' _Oracle The Complete Reference_. One part of the book covers SQL and SQL*PLUS/iSQL Plus (the Oracle interfaces). You won'... Carol.Bristow(70)
Re: Tabulate and PCTN format220 (4/24/2006 8:41:03 PM) comp.soft-sys.sas What you need is another format. I don't know if this is the "best" solution but it works nicely for me: All you need to do is make a new format--for example, just add this to your format statement: picture pe... afdbn(103)