About Hima

Hima · ‎02-16-2012

Art - I see what you are saying . If the date in the table has time stamp may be that will work? Suppose that the format of the tran_date is something like this 12MAY2009:00:00:00.00000 (datetime25.6) data a; input account_number $ tran_am $ tran_dt $; cards; 12345678 14.00 12JAN2012:00:00:00.00000 12345678 12.00 12JAN2012:04:50:18.254602 12345678 9.00 12JAN2012:09:23:00.00000 23456789 13.00 11JAN2012:00:00:00.00000 23456789 15.00 11JAN2012:04:50:18.254602 23456789 9.00 11JAN2012:09:23:00.00000 ; run; proc sql; select distinct account_number, tran_am, tran_dt from a group by account_number having tran_dt = max(tran_dt); quit; Raghs_Newbee - Can you please post sample data?

Hima · ‎02-16-2012

The above query works good even if there are multiple transactions with in the max date.

Hima · ‎02-16-2012

data a; input account_number $ tran_am $ tran_dt $; cards; 12345678 12.00 02/16/2012 12345678 14.00 02/15/2012 23456789 15.00 02/14/2012 23456789 13.00 02/13/2012 ; run; proc sql; select distinct account_number, tran_am, tran_dt from a group by account_number having tran_dt = max(tran_dt); quit; Output: account_ number tran_am tran_dt ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ 12345678 12.00 02/16/20 23456789 15.00 02/14/20

Hima · ‎02-16-2012

Zipping the data set might help.

Hima · ‎02-16-2012

Code: data a; input var1 $ var2 $; cards; A . B . C . D . Z . Z ZA Z ZB Z ZC Z ZD Z ZE ; run; data b; input (l_var1 l_var2 valvar) ($); cards; A . RED B . GREEN C . BROWN D . YELLOW Z . WHITE Z ZA GREEN Z ZB PURPLE Z ZC WHITE Z ZD WHITE Z ZE WHITE ; run; proc sql; select a.var1, a.var2, b.valvar from a inner join b on a.var2 =b.l_var2 and a.var1=b.l_var1; quit; Output: var1 var2 valvar ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ A RED B GREEN C BROWN D YELLOW Z WHITE Z ZA GREEN Z ZB PURPLE Z ZC WHITE Z ZD WHITE Z ZE WHITE

Hima · ‎02-16-2012

Let's try this. Select the data in the excel. Copy and paste it to notepad. Open a new excel spread sheet Copy the data from notepad to the new excel. Save the excel. Run the proc import code.

Hima · ‎02-16-2012

Change SHEET="'feb2012$'"; to range='feb2012$';

Hima · ‎02-16-2012

This is strange. It worked for me on PC SAS. I found this link that might help you. http://support.sas.com/kb/19/293.html

Hima · ‎02-16-2012

PROC IMPORT OUT= work.asd DATAFILE= "C:\Documents and Settings\abc.xls" DBMS=excel REPLACE; sheet = "feb2012"; RUN; proc print data = work.asd; run;

Hima · ‎02-15-2012

Code: data rpt_product_credit; informat application_id $15.; input application_id source_cd; cards; 123456789012345 1 543210987654321 2 ; run; proc sql; create table test as SELECT Distinct A.application_id, A.Source_CD as Source_Code FROM RPT_PRODUCT_CREDIT A WHERE application_id > '201111*'; QUIT; PROC EXPORT DATA= Test OUTFILE= "C:\Documents and Settings\TEST.XLS" DBMS=EXCEL REPLACE; SHEET="T"; RUN; Output from Excel: application_id Source_Code 543210987654321 2

Hima · ‎02-15-2012

Aborts from SAS session DATA TEST1; SET TEST; IF <CONDITION> THEN ABORT ABEND 123; RUN;

Hima · ‎02-15-2012

First verify if the table "test" exist in work. Code: PROC SQL; select libname, memname, memtype from DICTIONARY.MEMBERS where libname = 'WORK' AND memname = 'TEST'; QUIT; Output: Library Member Name Member Name Type ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ WORK TEST DATA If the table exists the code provided by SASKiwi should work given the primary key and foreign key relationship exist between the two tables.

Hima · ‎02-15-2012

Say that the data set you used to create html report is Table_A. Run the below code, instead of converting the html report to excel. PROC EXPORT DATA= Table_A OUTFILE= "C:\Documents and Settings\Test.xls" DBMS=EXCEL REPLACE; SHEET="Sheet_1"; RUN;

Hima · ‎02-09-2012

How does SAS EG win over PC SAS with respect to an organization, end user and a programmer ? How is SAS EG cost effective compared to PC SAS? How much would be the difference in cost at enterprise level?

Hima · ‎02-07-2012

Read the following link (Page 6 and 7). I hope this will help and good luck http://www2.sas.com/proceedings/sugi26/p003-26.pdf

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

SAS Email - Insert a date in the subject line

Re: Date Format

Re: Setup Email via SAS

Re: Export to an ".xls" excel file

Re: Export to an ".xls" excel file

Re: Export to an ".xls" excel file

Re: Question vlookup equivalent in SAS

Re: Question vlookup equivalent in SAS

Re: Filtering character data only when it has specific characteristics

Re: Filtering character data only when it has specific characteristics

Re: Filtering character data only when it has specific characteristics

Re: Altering data structures

Re: Compare Function

Re: Dropping variables with null values

Re: First observation in a series of columns

using the Obs column

difference between merg and proc sql join.

Re: Dropping variables with null values

Using Except Operator with a Subquery

Using Except Operator with a Subquery

Find the Last Transaction in DataSet

Find the Last Transaction in DataSet

Find the Last Transaction in DataSet

What is the tip for shrink SASdata

Proc Sql Left Join - joining vars special condition

Proc import error

Proc import error

Proc import error

Re: Proc import error

Re: convert data from character to numeric

Stopping SAS program if an error occurs

using PROC sql with 2 tables from two different sources

Re: Report export in excel

How does SAS EG win over PC SAS at an organization level?

PDF with Logo in Header