About Hima

Hima · ‎02-24-2012

You can create a profile in SAS EG by clicking on "No profile selected" on the bottom right hand side corner of the tool. A window pops up. Click on Add. Another window pops up and will ask you for details like Name, Description, Machine, port, User, Password and authentication domain. Enter all those details and click on Save. Click on Set active. This connects you to the server. Once connected successfully. Run the code begininning with the line RSUBMIT <SERVERNAME>; and end the code with ENDRSUBMIT;

Hima · ‎02-24-2012

I am trying to create a hash table for the below criteria. Please help. Table_A ID Name Fee_Amt 1 a 0 2 b 200 3 c 0 4 d 400 5 e 500 Table_B ID City 1 Test1 2 Test2 3 Test3 4 Test4 5 Test5 Result ID Name City Fee_Amt Fee 1 a Test1 0 No 2 b Test2 200 Yes 3 c Test3 0 No 4 d Test4 400 Yes 5 e Test5 500 Yes Usually, in PROC SQL the below code works good but it takes hours to run if the observations are in millions. I happened to know that Hash tables are effective in this case. If some can help me creating a hash table for left join, it would be a great help. Thank you. Proc SQL Code: PROC SQL; CREATE TABLE RESULT AS SELECT A.*, B.CITY, CASE WHEN (A.ID = B.ID AND A.FEE_AMT > 0) THEN 'YES' ELSE 'NO' END AS FEE FROM TABLE_A LEFT JOIN TABLE_B ON A.ID = B.ID; QUIT;

Hima · ‎02-22-2012

If I understand you correctly, this is what I have done. data test; input val stat $ add $; datalines; 2002.04 SINGLE Province1 1852.04 MARRIED Province2 ; RUN; PROC EXPORT DATA = test OUTFILE= "C:\Documents and Settings\TEST.XLS" DBMS=EXCEL REPLACE; SHEET="Sheet1"; RUN; Then opened the excel to creat a pivot table. Sum of val stat add Total MARRIED Province 1852.04 SINGLE Province 2002.04 Grand Total 3854.08 which is working fine

Hima · ‎02-22-2012

data test1; set test; obs = _n_; run;

Hima · ‎02-22-2012

Can you post the results of man bdf? It would greater visibilty for me to help you solve this.

Hima · ‎02-22-2012

The best approach would be moving the results to text file and then converting the text file to data set. Give it a try.

Hima · ‎02-22-2012

I am getting 37. Not sue how you are getting 38. total ƒƒƒƒƒƒƒƒ 37

Hima · ‎02-22-2012

It would help if you can post more details. what do you have in 'bdf'?

Hima · ‎02-22-2012

data one; input d1 d2; datalines; 1 2 13 3 -1 2 13 3 13 2 9 2 -18 1 61 3 -9 2 19 1 1 1 ; run; proc sql; create table two as select d1/d2 as res from one; quit; proc sql; select sum(round(res)) as total from two; quit;

Hima · ‎02-22-2012

Try logging off from SAS and restart your pc. Lets see if that works.

Hima · ‎02-22-2012

Can you try the below and see if it works by any chance? Help pull-down menu and select "Show Application Log".

Hima · ‎02-22-2012

data test; input num; datalines; 0.0000000000 0.5000000000 4.3333333333 0.0000000000 0.0000000000 -0.5000000000 4.3333333333 0.0000000000 6.5000000000 0.0000000000 0.0000000000 0.0000000000 -4.5000000000 -18.0000000000 20.3333333333 0.0000000000 4.5000000000 19.0000000000 1.0000000000 ; run; proc print data = test; run; proc sql; select round(sum(num)) as total from test; quit; Output: total ƒƒƒƒƒƒƒƒ 37

Hima · ‎02-21-2012

PROC SQL; SELECT CASE WHEN DATE1<DATE2 THEN DATE1 ELSE DATE2 END AS MIN_DATE FORMAT MMDDYY10. FROM TEST; QUIT;

Hima · ‎02-16-2012

Try creating a Distrubution List with all the email ID's. Usually bigger organizations have the capabilty to create DG list for emails. Paste the DG name in the code and it should work.

Hima · ‎02-16-2012

Check this link out. It has some info related to this topic. http://support.sas.com/techsup/technote/ts605.html

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

Forcing all sas queries to execute remotely

Creating Hash tables

Re: exporting into Excel loses SUM

using the Obs column

x statement output

x statement output

Handling decimals numbers in SUM function

x statement output

Handling decimals numbers in SUM function

Re: Log Window always empty

Log Window always empty

Handling decimals numbers in SUM function

to find minimum of two date values?

Issue with email ID list for EMAIL engine in FILENAME statement

Issue with email ID list for EMAIL engine in FILENAME statement