About tmm

Reeza · ‎03-30-2012

If you have the data in an excel sheet, save it as CSV and then use proc import to read it in. You don't need any special license for that and don't have to I'd highly suggest you either hire someone offline to help you get through this issue and get working with SAS though otherwise you're spinning your wheels on a lot of small problems...or take a course through SAS.

tmm · ‎04-12-2012

found the answer

SteveDenham · ‎10-12-2012

And with so many cells with virtually no representation (counts<2)? A sensible aggregation seems in order here. Steve Denham

Haikuo · ‎03-20-2012

Are you certain that it did not 'append' or it did but with a warning about 'length' problem? If it was the later and the warning really bothers you, you can turn it off by adding option 'NOWARN' after 'force'. It would be ideal if you could post your code along with your error log.

Tom · ‎03-19-2012

Since you are renaming the variable on the way out you need to use the old name of the variable in your Label statement.

Haikuo · ‎03-19-2012

There you go!

Linlin · ‎03-15-2012

Hi Art, I thought you wanted to show how to print all numeric or character variables between two variables. In the example below, the two outputs are different. Thanks -Linlin data class; set sashelp.class; age2=age; w2=weight; proc print data=class; title print out all numeric variables; var _numeric_; run; proc print data=class; title print out all numeric variables between name and weight; var name-numeric-weight; run;

Hima · ‎03-14-2012

Code: DATA TEMP; INPUT memberID yes no; CARDS; 111 0 1 222 1 0 ; RUN; data chi (drop = yes no); set TEMP; array _col(2) yes no; do _n_= 1,2; who = vname (national); admission = vname(_col(_n_)); count = _col(_n_); output; end; DROP NATIONAL; run; PROC PRINT; RUN; Output: member Obs ID who admission count 1 111 national yes 0 2 111 national no 1 3 222 national yes 1 4 222 national no 0

GeorgeSAS · ‎03-18-2012

Hi HaiLuo, It seems there is an error in your hash method. could you correct that? Thanks

shivas · ‎03-14-2012

Hi, Try this... data want; set one;set two; run; data want1; merge one two; run; Thanks, Shiva

tmm · ‎03-14-2012

That was the ticket. Thanks

tmm · ‎03-09-2012

Thanks that worked perfectly

BobD · ‎03-09-2012

I don't think so. Try this: proc sql; connect odbc (dsn); create table claims as select * from connection to odbc ( select mbr_id , prov_mpin , prov_id , max(prov_row_eff_dt) as prov_eff_dt from co.table where mbr_id > 0 group by 1,2,3 ) order by mbr_id; disconnect from odbc; quit; I reformatted your query to make it easier to read. I removed the DISTINCT keyword because I don't think it is needed, and I used column references (1,2,3) in the GROUP BY clause, which I'm pretty sure will work. I also deleted a stray semi-colon from your example code (in front of your ORDER BY clause).

Maheshvaran · ‎03-09-2012

Hi tmm, Just off the cuff here, you may want to get the format in which the Date is stored in the Table and the when asking it in the Where clause use the followng syntax: Note the Double qoutes and d. WHERE mkt_row_row_end_dt >= "&date"d; Hope this helps! Kind Regards, Maheshvaran

ballardw · ‎03-07-2012

And you never bothered to let us know you were reading DB2 files. All of the above solutions work on SAS datasets.

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Place quotes around column header and data

Re: Point = error

Point = error

Re: Insert into confusion

Re: Insert into confusion

Insert into confusion

Re: create a proc sql without the need for multiple proc sqls

create a proc sql without the need for multiple proc sqls

Re: how to combine 2 inner joins to proc sql

how to combine 2 inner joins to proc sql

format max date

concatenating number columns

data in for chi square

Re: Chi Output Issue

Re: chisq issue

Re: PROC APPEND problem

proc sql label change

UPDATE PROBLEM

Re: rename column in data step

Put in column

make columns different

merge no nulls

count of table

max not working

Re: MAX Help

SQL Date Issues

>= current