About SAS_inquisitive

SAS_inquisitive · ‎03-28-2016

How to interpret this color code (CXD9892C) in the TITLE statement? title1 color=CXD9892C height=2 'This is my title'; proc print data=sashelp.class; run;

SAS_inquisitive · ‎03-23-2016

@FreelanceReinh. Thanks. This helped to see what is going inside one iteration of DOW LOOP. data b; do until ( last.id ); put _all_; set a; put _all_; by id; put _all_; count=sum(count,1); put _all_; sum=sum(sum,var); put _all_; end; mean = sum / count; run;

SAS_inquisitive · ‎03-23-2016

@ballardw. I checked that before posting this. It gives correct result for first by group (A) but not for the second by group (B). For second group var is accumlated for both A and B. However, for this no intialization is required. data a; input id $ var; datalines; A 1 A 2 B 3 B 4 B 5 ; data b; do until ( last.id ); set a; by id; count=sum(count,1); sum=sum(sum,var); end; mean = sum / count; run;

SAS_inquisitive · ‎03-23-2016

This was mentioned as "Henderson-Whitlock Original Form of DoW-loop" at SAScommunity.org. Since the SUM statement intializes itself to 0, why have sum and count variables been explicitly intialized to 0? data a; input id $ var; datalines; A 1 A 2 B 3 B 4 B 5 ; data b; count= 0; sum = 0; do until ( last.id ); set a; by id; count+1; sum+var; end; mean = sum / count; run;

SAS_inquisitive · ‎03-23-2016

@PGStats. Would endtime variable be initialized as zero or missing at the beginning? endTime = max(endTime, end); I checked it initializes with missing value. I also wonder how to check what is going on during one complete dow-loop interation? I also read DOW-LOOP does automatic retain, how does it do that? data want; length roomList $64; put _all_; do until (last.building); set have; by building notsorted; roomList = catx(", ", roomList, room); endTime = max(endTime, end); end; put _all_; keep building roomList endTime; rename roomList=room endTime=end; run;

SAS_inquisitive · ‎03-21-2016

I looked closely at the arugments of the CALL SCAN. It makes sense now. Thanks !

SAS_inquisitive · ‎03-21-2016

I was looking at this example in SAS doc. So CALL SCAN is able to create variables from its arguments (position, length) without specifying those variables explicitly? data artists; input string $60.; drop string; do i=1 to 99; call scan(string, i, position, length); if not position then leave; Name=substrn(string, position, length); output; end; datalines; Picasso Toulouse-Lautrec Turner "Van Gogh" Velazquez ; proc print data=artists; run;

SAS_inquisitive · ‎03-21-2016

Thank you, all.

SAS_inquisitive · ‎03-21-2016

Under what situations CALL ROUTINE is used over SAS functions such as CALL SCAN vs. SCAN?

SAS_inquisitive · ‎03-18-2016

@ LinusH. I believe looping is very important part of any programming language. I really want to master on it.

SAS_inquisitive · ‎03-17-2016

What advantage can be made of DO UNTIL over DO WHILE in programming because of the fact that DO UNTIL executes at least once?

SAS_inquisitive · ‎03-15-2016

How does the statement between inner and outer do loop execute? Under which conditions is it necessary to put statement between inner and outer loop? data test1; put _all_; do i= 1 to 2; a=10; do j=1 to 3; put _all_; output; end; end; run; data test2; put _all_; do i= 1 to 2; do j=1 to 3; a=10; put _all_; output; end; end; run;

SAS_inquisitive · ‎03-09-2016

@ Astounding. Yes, the horizontal list as you mentioned. %let var_list=x y;

SAS_inquisitive · ‎03-09-2016

@data_null__ @Astounding. Thank you. May be I could start another thread. What if variables are not var1 and var2 (ie. can not referenced by macro variable &i) such as x and y and I need to change their attributes inside macro definition. data test; input x $ y $; cards; 1 4 2 5 3 6 ;

SAS_inquisitive · ‎03-09-2016

This macro code creates the code below. I want to create only one length statement and only variable names changing dynamically. data test; input var1 $ var2 $; cards; 1 4 2 5 3 6 ; %macro m; data test; %do i= 1 %to 2; length var&i $ 10.; %end; set test; run; %mend m; %m /* cod generated */ data test; length var1 $ 10.; length var2 $ 10.; set test; run; /* desired code */ data test; length var1 $ 10. var2 $ 10.; set test; run;

Online Status	Offline
Date Last Visited	‎08-24-2020 02:10 PM

Re: macro variable name same as parameter

macro variable name same as parameter

Re: Get specific variables from all data sets in a library

Re: Get specific variables from all data sets in a library

Re: Get specific variables from all data sets in a library

Get specific variables from all data sets in a library

Re: parameter in macros

Re: parameter in macros

parameter in macros

argument in filename()

Re: macro variable name same as parameter

Re: macro variable name same as parameter

Re: macro variable name same as parameter

Re: macro variable name same as parameter

Re: macro variable name same as parameter

Re: Data Step vs. Proc SQL: General Comparisons

Re: PROC SQL cheat sheet

Re: Using _method option in proc sql

Re: Replace characters with a substring from a different variable.

Re: Concatenate multiple rows into a single value

color code

Re: sum statement within DO UNTIL()

Re: sum statement within DO UNTIL()

sum statement within DO UNTIL()

Re: SAS CREATING GROUPS

Re: call routine vs function

Re: call routine vs function

Re: call routine vs function

call routine vs function

Re: advantage of DO UNTIL

advantage of DO UNTIL

statement between inner and outer do loop in nested do loop

Re: Dynamically change the variable attributes

Re: Dynamically change the variable attributes

Dynamically change the variable attributes