About singhsahab

singhsahab · ‎11-24-2018

thank you 🙂

singhsahab · ‎11-23-2018

Hello Sir, Can you please explain the working of below statement . having max(grade='D')=0 Thanks...

singhsahab · ‎11-23-2018

Hi Ranjeeta, Call Missing routine assign an ordinary numeric value . (dot) to each numeric variable in the argument list. In your case whenever if condition is true for first group variable, call routine assign . (dot) value for all listed variable. later when the next group variable will come it will again assign the same . if first.cihi_key then call missing(var_cost, fix_Cost, new_idc, totalcost); Thanks...

singhsahab · ‎11-22-2018

Data have ; input year month v1 v2 ; cards ; 2001 1 1 0 2001 1 0 1 2001 1 0 1 2001 2 1 1 2002 2 1 0 2002 3 0 1 2002 5 1 1 2003 2 0 1 2003 4 0 1 2003 5 1 1 2003 5 1 0 2003 7 0 1 2003 8 0 1 2003 9 1 1 2003 10 1 0 2003 11 0 1 2003 12 0 1 ; run ; PROC SQL; CREATE TABLE WANT AS SELECT YEAR,MONTH,SUM(V1) AS FR_V1,SUM(V2) AS FR_V2 FROM HAVE GROUP BY YEAR ,MONTH; QUIT; If you wanted to use PROC SQL above code can help. if wanted to see all month data at least one entry is needed for each month per year. Thanks...

singhsahab · ‎11-22-2018

Hi Nirupama, as per your code we are getting output as you expected . ID Score 1 95 2 96 3 35 4 45 If you wanted to stop overwrite , you should use proc SQL like below. proc SQL; select coalesce(a.id,b.id) as id , coalesce(a.Score,b.Score) as score from ex1 as a left join ex2 as b on a.id = b.id; quit; This will return output as : id score 1 25 2 28 3 35 4 45 Thanks,

singhsahab · ‎11-22-2018

Hi Kalu, Welcome !! You can use PROC Import procedure .like below. proc import datafile="\\path\data.xls" out=want dbms=excel replace; run; proc print data=want; format date ddmmyy8.; run; Thanks,

singhsahab · ‎11-13-2018

Hello , In your case proc SQL insert will not work. You can use PROC APPEND procedure with FORCE options. proc append base=tble_one data=tble_two force; run;

singhsahab · ‎11-11-2018

Hi Julie, instead of using cats function , you can directly use MDY date function. Below is the sample code data test; year='2018'; month='Feb'; day='19'; ; run; proc format ; value $datef 'Feb'=02 'Apr'=04 ; run; data want; set test; new_date=mdy(input(month,$datef.),input(day,2.),input(year,4.)); format new_date ddmmyy10.; run; I created format as per your value available in month. You've to add remaining month. Thanks.

singhsahab · ‎11-08-2018

Hello Suja, i found that there is some contradiction in your request and excepted output. If you want minimum value by each id group. you can use proc means. data test; input id cc_age cc_amt PL_age PL_amt Mort_age Mort_amt bank_age bank_amt; cards; 001 2 1000 . . 8 1600 11 300 001 12 1000 6 3000 . . 6 1300 001 . . 3 4000 . . 4 2430 001 7 900 . . 2 2999 . . 002 5 4000 9 5000 11 2000 . . 002 . . 4 1500 . . 8 990 002 2 900 . . 7 890 10 2600 ; run; proc means data=test min maxdec=0; class id; run; you can use output options to create output data set, if want to include missing observation on calculation . kindly use missing options . Thanks....

singhsahab · ‎11-01-2018

Hello, Welcome !! you have to add DSD option in infile statement to read correct data. infile ‘c:\temp\PurchaseRecords.dat’ dlm=’,’ DSD;

singhsahab · ‎11-01-2018

Hi , If there is no memory concern , kindly use hash object to join ... here is a sample code. data A; input id status; cards; 1 1 2 1 3 . 4 1 5 1 6 1 ; run; data b; input id; cards; 1 2 3 5 ; run; DATA WANT; IF _N_=1 THEN DO; DECLARE HASh H(DATASET:'B'); H.DEFINEKEY('ID'); H.DEFINEDATA('ID'); H.DEFINEDONE(); END; DO UNTIL(LR); SET A END=LR; WHERE STATUS=1; ARRAY ARR ID; DO OVER ARR; r=H.find(key:arr); if r ge 0 THEN OUTPUT; END; END; drop r; RUN;

singhsahab · ‎10-31-2018

data lb; input usubjid lbdtc $ 16. lbtptnum rbc $ wbc $ visit; cards; 101 01-10-2018T10:15 1 1 1 1 101 01-10-2018T10:20 2 2 2 1.01 101 01-10-2018T10:20 2 2 2 1.01 ; run; proc sort data=lb dupout=want nodupkey; by _all_; run; data _null_; set want; put _all_; run;

singhsahab · ‎10-31-2018

Hi Gil, if you want to append data sets , first you have to remove Primary key constraint, as you know it wouldn't allow duplicate values. or Proc append will run without any error but in log you will get warning . Like " Add/Update failed for data set because data value(s) do not comply with integrity constraint primary key, number of observations rejected." Thanks,

singhsahab · ‎10-30-2018

Hi Babloo, can you please share sample data sets ? that will be really helpful to convert your code in SQL joins. Thanks..

singhsahab · ‎10-30-2018

Hello, 1. To see i can class variable output, you have to add put statement. 2. As per loop , when i=1 then SAS automatically assign length as per first declaration . To avoid truncation you have to use LENGTH statement . data _null_; length class $5.; do i=1 to 2; if i=1 then class="bank"; if i=2 then class="bonds"; put i= class=; end; summary=cats(class, "_summary"); call symputx('summary', summary); Current=cats(class, "_curr"); call symputx('current', current); run; %put &summary.; %put &current.;

Online Status	Offline
Date Last Visited	‎06-11-2024 01:54 AM

Extract last digit from a string

Re: how to transpose data in proc sql

Re: how to transpose data in proc sql

Re: series of dates

Re: How to extract a specific text from each cell from the same variab...

Re: re: counting days between two dates

How to remove characters from a text string using regular expressions

Re: Not able to do date difference

Re: read and compare next observation in sas

Re: List files in folder (CSV files)

Re: Extract last digit from a string

Re: Extract last digit from a string

Re: SAS Programming

Re: Date sequence Problem

Re: SCHEDULED VISIT VS UNSCHEDULED VISIT

Re: How to extract a specific text from each cell from the same variab...

Re: read and compare next observation in sas

Re: query for parent

Re: How to merge two files but not concatenate ?

Re: Macro for importing several csv files

Re: Delete observations in BY group on condition

Re: Delete observations in BY group on condition

Re: first.variable and call missing help

Re: programming for aggregating individual level data to the aggregate...

Re: sas merge

Re: Errors reading data from Excel file into SAS (informat & format fu...

Re: Inserting data into a table that has more columns

Re: Unexpected year value with date informat

Re: select minimum value and corresponding amount in proc sql

Re: SAS data step programming

Re: PROC SQL

Re: log

Re: Appending data to access

Re: Merge Vs Join

Re: Newbie Question - How to do a loop in SAS combine with proc sql?