About ZRick

ZRick · ‎02-25-2013

To do the data manipulation (adding, sorting, spliting, searching) in memory for SAS, is hash table the only way?

ZRick · ‎02-20-2013

I tried to this macro: %t(outlib=work, dataset=sashelp.class, varname=age); It still says: NOTE: No rows were selected.

ZRick · ‎02-20-2013

Why following macro return 0 records? how do I fix it? %macro t (outlib=, dataset=, varname=); %if %INDEX(&dataset,.) eq 0 %then %do; %let libname = WORK ; %let setname = &dataset ; %end; %else %do; %let libname = %SUBSTR(&dataset,1,%INDEX(&dataset,.)-1); %let setname = %SUBSTR(&dataset,%INDEX(&dataset,.)+1) ; %end; proc sql noprint; select type into :vartype from sashelp.vcolumn where libname = upcase("&libname") and memname = upcase("&setname") and memtype = "data" and upcase(name) = upcase("&varname") ; quit; %mend; %t(outlib=sashelp, dataset=class, varname=age );

ZRick · ‎02-18-2013

I have implementation using data merge and hash table, but don't know how to do it in proc sql, it is actually a left outer join /*merge data step implementation*/ proc sort data=work.t out=t;by id; run; proc sort data=p out=p; by id; run; data fnl; merge t(in=a) p(in=c); by id; if a; run; /*hash table implementation*/ data fnl_result(drop=rc); if 0 then set p; declare hash tmp(dataset:"p"); rc=tmp.defineKey("id"); rc=tmp.defineData("inst"); rc=tmp.defineDone(); do until(eof); set t end=eof; call missing(inst); rc=tmp.find(); output; end; stop; run;

ZRick · ‎02-18-2013

How do I append the columns to the duplicate rows? data t; input id port $; cards; 001 b_12 001 p_92 ; data b; input id inst $; cards; 001 mthd ; I want the final table has: id, port and inst, In addition, in inst column, both rows are filled? something like: 001 b_12 mthd 001 p_92 mthd

ZRick · ‎12-14-2012

proc sort data=t; by sec dt; run; data t; set t; by sec dt; if first.rate then n=1 ; else n+1; if last.rate then stop; run; It doesn't work, I don't know how to reset the n using first. and last. form to assign the n in ascending order.

ZRick · ‎12-14-2012

WANT TO assign _n_ number in ascending order based on sec, dt, rate in the last column. data t; input sec dt rate; cards; 1 9205 0.2 1 9205 0.3 1 9205 0.4 1 9204 0.2 1 9204 0.3 1 9204 0.4 2 9205 0.1 2 9205 0.2 2 9204 0.1 2 9204 0.2 3 9205 0.8 3 9205 0.9 3 9205 1.1 3 9205 3.5 3 9205 4.2 ; /* WANT TO assign _n_ number in ascending order based on rate in the last column 1 9205 0.2 1 1 9205 0.3 2 1 9205 0.4 3 1 9204 0.2 1 1 9204 0.3 2 1 9204 0.4 3 2 9205 0.1 1 2 9205 0.2 2 2 9204 0.1 1 2 9204 0.2 2 3 9205 0.8 1 3 9205 0.9 2 3 9205 1.1 3 3 9205 3.5 4 3 9205 4.2 5 */

ZRick · ‎11-30-2012

I have meta data extracted into data set b like this proc contents data = t out = b noprint nodetails; run; in data set b, I just use Name, Type, Length. Now, I want to create data set "addi" using the data set b, then append the data set addi to data set t. How do I do that? I want to do this so that appending data set won't have inconsistent length or data type issue.

ZRick · ‎11-23-2012

Great, it works now.

ZRick · ‎11-23-2012

%global &&out_var_nm.1 - &&out_var_nm.%left(&nobs); ERROR: Invalid symbolic variable name -. how do I solve this?

ZRick · ‎11-23-2012

it says: WARNING: Apparent symbolic reference PID1 not resolved. WARNING: Apparent symbolic reference PID4 not resolved. data t; input pid; cards; 10 31 31 2 12 12 ; options mprint; %macro dyn_var_nm(in_var_nm=,ds=,out_var_nm=); proc sql; select count(distinct &in_var_nm) into :nobs from &ds; /*%let nobs = &nobs;*/ select distinct &in_var_nm into :&&out_var_nm.1-:&&out_var_nm.%left(&nobs) from &ds; quit; %mend; %dyn_var_nm(ds=t,in_var_nm=pid,out_var_nm=pid); %put &pid1 &pid4;

ZRick · ‎08-24-2012

I have a simulation data set of over 200 million rows, I have to sort it utilizing proc sort and MP_Connect Can someone help me with the code template?

ZRick · ‎08-15-2012

I need some software that does refactoring job across sas sql/macro/ iml data steps to realize: 1. highlight related variable in all related sas code. 2. change one variable and change all related variables in all related sas codes. for instance, variable $chr, it appears in proc sql 2 times, macro 3 times, data step 1 time I need tool to highlight $chr in all related code I need to change one place and change all other places. I need to measure the change in terms the performance, stability, etc.

ZRick · ‎08-15-2012

Really appreciate this great discussion. I think astounding's code is much simpler and worked. MikeZdeb's code also worked, but personally I don't want to use the looping, I think it could cause the performance issue potentially when processing large volume data. I may test the efficiency and hardware resources to compare further.

ZRick · ‎08-15-2012

the bench data is, variable is not port, bench, sorry about that, I test your code, it doesn't look like working data bench; input port_id bench_id; cards; 10 33 33 44 ;

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: set IML matrix name based on the do loop, how do I do that?

Re: set IML matrix name based on the do loop, how do I do that?

Re: set IML matrix name based on the do loop, how do I do that?

set IML matrix name based on the do loop, how do I do that?

need the logic to tell if this value looks like numeric

Re: how to generate sas code using recursive join

Re: how to generate sas code using recursive join

Re: how to generate sas code using recursive join

Re: how to generate sas code using recursive join

how to generate sas code using recursive join

How do I combine each row into one big row?

what is the purpose of if _N_=1 then do in this data step?

Can macro variables created in select into be local?

how to convert char var to sas date?

how to find closest match that is less than its date?

data manipulation in memory, hash table is the only way?

Re: select into using sashelp.vcolumn, return a 0 record, why?

select into using sashelp.vcolumn, return a 0 record, why?

Re: append / join the columns to the duplicate records, using proc sql...

append / join the columns to the duplicate records, using proc sql, ho...

Re: create a ascending number conditionally in the last column

create a ascending number conditionally in the last column

how do I use meta data extracted from proc contents to read in obs?

Re: why those macro variables are not solved?

Re: why those macro variables are not solved?

why those macro variables are not solved?

sample code to run a partitioned data sorting using MP_Connect?

some refactoring tool that traverse through SAS SQL/Macro Data Steps?

Re: efficiently change variable values selectively?

Re: efficiently change variable values selectively?