About HeatherNewton

HeatherNewton · ‎04-03-2022

I did yesterday. Could u see?

HeatherNewton · ‎04-03-2022

I did. The data set is no of years. The calculation not seems not doing mich. What do u think?

HeatherNewton · ‎04-03-2022

I have confirmed that the years is actually no of years. could you please check what is the significance of this calculation of month.. I see no difference with just applying *12 to no of years whether the no of years is integer or with decimal data result; input YEARS_OF_IMP $5.; month=(input(YEARS_OF_IMP,4.)-int(input(YEARS_OF_IMP,4.)/100)*100)*12 +int(input(YEARS_OF_IMP,4.)/100); X=input(YEARS_OF_IMP,4.); month1 = (X-(int(X/100))*100)*12+int(X/100); test2=int(X/100); test2a=int(X/100)*100; test3=X-int(X/100)*100; test3a=(X-int(X/100)*100)*12; datalines; 0 20 30 15.5 12.8 12.3 14.1 ; proc print data=result;

HeatherNewton · ‎03-30-2022

I am trying to make sense of the code. but got nowhere. please help. month=(input(years,4.)-int(input(years,4.)/100)*100)*12 +int(input(years,4.)/100); what is the above doing? I tried with different value for "years" and got nowhere. eg. data new; years=1961; month=(input(years,4.)-int(input(years,4.)/100)*100)*12 +int(input(years,4.)/100); run; only getting '.' i.e. missing for month

HeatherNewton · ‎03-28-2022

PROC SQL NOPRINT; CREATE TABLE PERF_ACCT AS SELECT DISTINCT ORG_CODE, ACCOUNT_NO, LOGO, DATE_CARD_OPENED, BLOCK_CODE_1 FROM CREDIT_CARD; *WHERE EFF_FROM_DATE<="&PERF_END"D AND (EFF_TO_DATE>"&PERF_END"D OR EFF_TO_DATE=.); QUIT; generally I know that * means commenting a statement, however, here I am suspicious. Could you take a look and confirm for me if where statement above is commented and what about the line starting with AND ..., is it also commented when it is on the next line?

HeatherNewton · ‎03-25-2022

am I right to say that we only care if a is not null and therefore it is a left join? I am not sure about the significance of if b statement here

HeatherNewton · ‎03-24-2022

proc sort data=samp_acct; by org account; run; data samp_acct; merge samp_acct (IN=A) GUARANTEE(in=b); by org account; if A; if b then IND_GUARANTEE=1'; run; I dont get this. What does it mean to merge with if A and if B? Can you put this into sql join statement for me? thanks

HeatherNewton · ‎03-23-2022

dual = compress(substr(acc,1,8) || put (( input(substr(acc,9,1),1.),5.) || substr(acc,10,7) || put (( input(substr(acc,17,1),1.)+1),5.) || substr (acc,18,2)," "); I have trouble understand the above, could you enlighten me? especially the put, input part, is it bad practice to write this kind of code? why so complicated, there is no single function to do put, input together? very scary code the big paragraph above...

HeatherNewton · ‎03-23-2022

am I right to say if these if then else loops in within a macro program, it needs % added to if then else? if the if then else condition is not inside a macro program, then no % is required in from of if then else...

HeatherNewton · ‎03-23-2022

Hi I want to know the sequence of how sas process the code... proc sort data=cch (drop=date) out=book nodupkey; by post_to_acct; run; am I right to think the following sequence from the above code... 1. drop date 2. sort by post_to_acct; 3. drop duplicate 4. output to book I am tempted to write as follows, ie dropping duplicate and variable "date" before sorting, would the result be the same? Select distinct post bookcart cake lemon; from cch; order by post_to_acct; run;

HeatherNewton · ‎03-22-2022

thanks for your hint, you are so right

HeatherNewton · ‎03-22-2022

proc sort data=apple; by colour weight; run; for proc sort, input data is dataset apple, is the output data set after sorting is also apple?

HeatherNewton · ‎03-21-2022

Select A.ORG_CODE, A.ACCOUNT_NO, LOGO, DELINQUENCY 1, DELINQUENCY 2, DELINQUENCY 3, DELINQUENCY 4, DELINQUENCY 5, DELINQUENCY 6, DELINQUENCY 7, DELINQUENCY 8, DELINQUENCY 9, DELINQUENCY 10, DELINQUENCY 11, DELINQUENCY 12, DELINQUENCY 13, BLOCK CODE _ 1, BLOCK_CODE_2, DATE_BLOCK_CODE_1, DATE_BLOCK_CODE_2, DATE _LAST_PMT, B.REFINANCE_ ACCT, B.REFINANCE DATE FORMAT=DATE9. FROM ACCT_LIST_PERF A LEFT JOIN VW_xx_REF_NODUP B ON A. ACCOUNT_NO=B . ACCOUNT_NO; I want to know it the FORMAT=DATE9. only for B.REFINANCE DATE or for other var before B.REFINANCE DATE?

HeatherNewton · ‎03-17-2022

before I saw example where % are only added to %macro and %mend... why suddenly they are added to do if then this kind of word?

HeatherNewton · ‎03-17-2022

Hi I am not familiar with the kind of macro where there is a % before a lot of words, what do they mean? %macro gen_ind(num); %do i=1 %to &num %by 1; proc sql; create table rate_MAC as select a.*, . . . Quit; %end;

Online Status	Offline
Date Last Visited	‎07-16-2024 08:12 AM

Re: odbc

Re: odbc

Re: odbc

Re: odbc

Re: odbc

Re: odbc

Re: odbc

Re: odbc

Re: odbc

Re: odbc

Re: looks like join but not

call symput

sas dataset with index

Re: Access SAS data file without SAS license

Re: Access SAS data file without SAS license

intck

Re: dates issue

Re: dates issue

Re: dates issue

dates issue

SUSPICIOUS *

Re: merge

merge

compress

Re: macro

Order of execution within proc sort

Re: proc sort default output data set

proc sort default output data set

format date

Re: macro

macro - meaning of % sign