About pradeepalankar

pradeepalankar · ‎01-10-2014

proc sql; select header1 as UniqueNumbers from have group by header1 having count(*)=1; quit;

pradeepalankar · ‎01-10-2014

your question is not clear...input/output data and some more explanation might help us understand better.

pradeepalankar · ‎01-10-2014

data a ; input b; obs=_N_; cards; 1 3 4 5 8 ; run; proc sort data =a out =test(rename=(b=b1)); by descending obs; data test2(keep=b b1); merge a test; obs_new=_N_; run; data test2(drop=b_first b1_first b1); set test2 nobs=nobs; retain b_first b1_first; if _n_=1 then do ;b_first=b;b1_first=b1;end; t=1+_N_*(b1_first-b_first)/nobs; run;

pradeepalankar · ‎01-10-2014

if you want that whenever condition if name='Uppsala & Lund Univ' is true then that row is always splitted into 2 rows with code 1 and 2 then you may use this: data have; Input Name $20. Code x :$ y :$ z :$; cards; Uppsala Univ 1 xxxx yyyy zzzz Lund Univ 2 xxxx yyyy zzzz Uppsala & Lund Univ 3 xxxx yyyy zzzz Uppsala Univ 4 xxxx yyyy zzzz Lund Univ 5 xxxx yyyy zzzz Uppsala & Lund Univ 6 xxxx yyyy zzzz ; data want ; set have; if name='Uppsala & Lund Univ' then do; code=1; output; code=2; end; output; run; But if you want your previous row's code to be different from later rows where if name='Uppsala & Lund Univ' is true then you may have to retain a varibale that will keep the previous count; e.g: data want(drop=count) ; set have; retain count 1; if name='Uppsala & Lund Univ' then do; code=count; output; count+1; code=count; count+1; end; output; run; Message was edited by: pradeep alankar

pradeepalankar · ‎01-10-2014

can you example input and desired output data .

pradeepalankar · ‎01-10-2014

If job is deployed and executed in batch, and your logging is not disabled then easient way to find the log path is to check the deployed job propery of the job: deployed job icon>properties>scheduling details tab> in command area you will find log path after "-log" parameter.

pradeepalankar · ‎01-03-2014

proc sql; select * from have group by HH_No having x=max(x); quit;

pradeepalankar · ‎01-02-2014

Your queston is not clear, can you explain further?

pradeepalankar · ‎12-30-2013

Hi, Try this : data _null_; format time tod.; /*just to show difference*/ time='9:1:12't; time6=compress(put(time,tod.),':'); put "time=" time; put "time6=" time6; run; output: time=09:01:12 time6=090112

pradeepalankar · ‎12-19-2013

Hi Sanjeev, try this one , it will read the file directly: data want(keep=first_name last_name); infile 'infile.txt' truncover; input line $1000.; /*give here the max length for line*/ do i=1 to countc(line,';')+1; first_name=scan(scan(line,i,';'),1,','); last_name=scan(scan(line,i,';'),2,','); output; end; run;

pradeepalankar · ‎12-17-2013

Here is another approach, you can read input data as demonstrated by PGStats in above reply. proc sort data=have ; by week day time; run; data want(drop=time value1); retain value1 0; set have; by week day time; if first.day and first.time then do ;value1=value;delete;end; if last.day and last.time then value=value1+value; run;

pradeepalankar · ‎11-29-2013

data want; set have; obs=_N_; proc sort data=want; by descending obs; data want; RETAIN score_new; set want; IF score1 NE . THEN score_new = score1; ELSE score1 = score_new; proc sort data=want out=want(drop=obs score_new); by obs; run;

pradeepalankar · ‎11-14-2013

data work.comp; set work.comp ; if var1<=0 then var1=0 ;else var1=1; if var2<=0 then var2=0 ;else var2=1; if var3<=0 then var3=0 ;else var3=1; ;run; proc print;run;

pradeepalankar · ‎11-10-2013

%macro time(a,b); %put here in time a=&a; %put here in time b=&b; %mend; %MACRO PARAMETERS; %DO K = 1 %TO 100 ; %DO L = 1 %TO 100 ; %IF &K. NE &L. %THEN %TIME(&K,&L); %ELSE %put entered in else :); %END; %END; %MEND; %PARAMETERS;

pradeepalankar · ‎10-30-2013

CSV is comma separated file ',' not semicolon separated.

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: Count

Re: Prompts with OR

Re: Create an evenly series variable

Re: How to make two data lines from one

Re: How to make two data lines from one

Re: Job Log in DI Studio

Re: Select observations that meet a criteria

Re: Imported dataset

Re: time HHMMSS format

Re: How to read Input data

Re: Add values based on calculation

Re: Missing values in data

Re: modify all the observations of all the variables in a dataset

Re: Do loop macro

Re: SAS Import CSV file - Free text column - carriage return

SAS Analytics Explorers