About pradeepalankar

pradeepalankar · ‎03-24-2014

try this, if num_var1=1 then date01=input("01/1/2012",mmddyy10.); else date01= .; if num_var2=2 then date02=input("03/15/2013",mmddyy10.); else date02=.;

pradeepalankar · ‎03-24-2014

Hi, shouldn't it be "table1.charvarn in (table2.char_var)" in place of "table2.charvarn in (table2.char_var)" as charvar1-charvar6 are present in table1 not in table2 as per your comments in post??

pradeepalankar · ‎03-24-2014

data have; infile datalines delimiter=','; input account description $ amount; datalines; 123,a,0 123,a,0 123,r,1 123,r,20 123,ra,30 123,w,4 234,b,1 234,c,20 234,ra,400 234,r,200 234,c,200 ; run; data test; set have(where =(description in ('r','ra'))); by account;if last.account then output ;run; proc sql; update have set amount=(select amount from test where test.account=have.account ) where have.description in ('r','ra'); quit;

pradeepalankar · ‎03-22-2014

hi, correct sql should be: Data have; input Week Activity :$; cards; 5 Pingpong 10 Badminton 15 Chess ; proc sql ; select count(distinct week) into :week_distinct from have; quit; 238 %put &week_distinct; 3

pradeepalankar · ‎03-22-2014

hi, as written in above post, code should remove the duplicates: Check the syntex of your code: DATA TEST; infile cards dlm='|' dsd; INPUT PRIMARY_KEY :$ ADDRESS :$20. SEX :$ AGE : ZIP : DISEASE : EVENT :$ DATE ddmmyy10.; cards; AA12345|1 SAMPLE ST,NY|M|20|00000| |x|03/01/2008 AA12345|1 SAMPLE ST,NY|M|20|00000| |x|03/01/2008 AA12345|1 SAMPLE ST,NY|M|20|00000| |x|03/01/2008 |2 SAMPLE ST,FL|F|21|12345||Y|04/01/2008 |2 SAMPLE ST,FL|F|21|12345||Y|04/01/2008 |3 SAMPLE ST,CA|F|22|22222||Y|05/01/2008 BD6789||M|19|33333||Z|06/01/2008 AA12345|1SAMPLE ST,NY|M|20|00000||x|03/01/2008 |3 SAMPLE ST,CA|F|22|22222||Y|05/01/2008 ; run; 165 PROC SORT DATA=test NODUPRECS; 166 BY _ALL_; 167 RUN; NOTE: There were 9 observations read from the data set WORK.TEST. NOTE: 4 duplicate observations were deleted. NOTE: The data set WORK.TEST has 5 observations and 8 variables.

pradeepalankar · ‎03-21-2014

Hi Yaswanth, i don't see any difference in your input and output(correct me if i am wrong ) can you explain bit more? what are we trying to achieve here..

pradeepalankar · ‎03-14-2014

%let id=&sysuserid; %put &id;

pradeepalankar · ‎03-03-2014

Hi , Use time_numeric=input(time,hhmmss6.); this should read your time.

pradeepalankar · ‎02-28-2014

Update : getting rid of proc sql: data test1; do sequence=1 to 20; output; end; call symputx('last_sequence',sequence); run; data test2; do sequence=&last_sequence to 100;output;end; run;

pradeepalankar · ‎02-28-2014

hi it can be done by multiple ways couple are below: /*method 1*/ data test1; do sequence=1 to 20; output; end; run; data test2; if _N_=0 then set test1 nobs=nobs; sequence=nobs+1; run; /*method2*/ data test1; do sequence=1 to 20; output; end; run; proc sql; select count(*) into :count from test1; quit; data test2; do sequence=&count+1 to 100;output;end; run;

pradeepalankar · ‎02-26-2014

or u may try this park=transtrn(park,'Canyon','');

pradeepalankar · ‎02-26-2014

Ok, let us know if it helps

pradeepalankar · ‎02-25-2014

if you got ur answer then mark it as answered

pradeepalankar · ‎02-25-2014

data have; input time $50.; if countw(time,': ')>=3 then num=input(scan(time,1,': '),2.)*60+input(scan(time,3,': '),2.); else num=input(scan(time,1,': '),2.)*60+input(scan(time,2,': '),2.); cards; 2 hr 25 min 1:30:30 9:30:30 9:30 00:12 1 hr 10 min ; run; output: Obs time num 1 2 hr 25 min 145 2 1:30:30 90 3 9:30:30 570 4 9:30 570 5 00:12 12 6 1 hr 10 min 70

pradeepalankar · ‎02-25-2014

hi, didn't understood your query completely in first place, based on what i understood is the below solution: if you need changes/new records which are there in new table and not in old one, /*1. compared based on some key columns.*/ if this so then try this: data previous_table_temp; set previous_table; compare_value1=md5(cats(key_column1,.....,key_columnN)); run; data current_table_temp; set current_table; compare_value2=md5(cats(key_column1,.....,key_columnN)); run; proc sql; create table incremantal_copy(drop=compare_value2) as select * from current_table_temp where compare_value2 not in (select compare_value1 from previous_table_temp); quit; if there are no such thing like "Key_Columns" over which comparison should be done then simple EXCEPT will give you the result: proc sql; create table incremantal_copy as select * from current_table except select * from previous_table; quit; check if this helps...and if you need something else please explain.

Online Status	Offline
Date Last Visited	‎05-24-2024 10:51 AM

Re: Filling missing values

Re: creating dummy variables based on string part

Re: Proc SQL and select count(*)

Re: How we create only specific row(observations)/How do we create row...

Re: Displaying count in a proc export statement

Display "X" at cross section in crosstab report

Re: check duplicates

Re: Restructure the table

Re: Data Seperation

Re: How to flag a group that has at least one particular value

Re: Import space delimited text if column values contain spaces

Re: Single observation per subject from multiple observation per subje...

Re: Stop proceeding the rest of the program if certain condition is me...

Re: get then minimum value when you have missing values

Re: update control table information

Re: Job Log in DI Studio

Re: Generate sequence

Re: Stop proceeding the rest of the program if certain condition is me...

Re: MMDDYY10. format turning all dates into 01/01/1960

Re: If then statement to case statement

Re: replace with last observation data

Re: Store distinct count in macro variable

Re: Multiple Duplicate Records

Re: Need help on comparing end dates with start date in second line

Re: how to use SYSUSERID as observation.

Re: How to convert string to time?

Re: Generate sequence

Re: Generate sequence

Re: Removing a certain part of a word

Re: output incremental data changes

Re: Convert character time to numeric

Re: Convert character time to numeric

Re: output incremental data changes

SAS Analytics Explorers