About SAS_inquisitive

SAS_inquisitive · ‎07-20-2016

@Astounding. Thanks. This is what I was assuming.

LinusH · ‎07-17-2016

Not necessarily. As per my previous answer, ech join could be 1 to many, or even many to many which would expand the no of result observations.

Reeza · ‎06-19-2016

Use a do loop with an explicit output statement. Heres as a sample for you: Data want; Set have; Do I=1 to num_of_visits; Visit_num= Visit_num+I-1; OUTPUT; End; run;

LinusH · ‎05-17-2016

Usually, it's hard to create a new key with a lower granular level on an existing table. Your sample data show too little of the possibilities. But it depends on the data. The best if you could get back to the data provider and ask for more details, and have tables that have a true primary key. The other "leg" is what you actually want to achieve by matching those tables. What is the business rule/requirement?

FreelanceReinh · ‎05-06-2016

@SAS_inquisitive wrote: Does the %IF statment executes first to generate the SAS statements before Proc Sql statement? Yes, sure. That's how SAS macro language works. Roughly speaking, the macro processor generates the code (data steps, proc steps, other non-macro statements) that is eventually sent to the compiler. Please see the documentation How SAS Processes Statements with Macro Activity for a detailed overview.

SAS_inquisitive · ‎04-27-2016

@RW9 I have one more question. If EX data set has one more variable, how can I add it to resulting data set? I tried to put it as the separate subquery as you did, it is not working.

Ksharp · ‎04-21-2016

COMPUTE block can do that. As Cynthia point out , Post some data and the output you want to see .

ballardw · ‎04-20-2016

SASAUTOS sets a search order of directories to look for your autocall macros. By placing SASAUTOS second in side the parentheses it says to set the !SASROOT/sasautos to be searched before the current description of SASAUTOS. This may be needed if someone had specified a SASAUTOS path that excluded the (usually a default) !SASROOT/sasautos for some reason. the '.' indicates to search the current executing directory and './SAS_macros' says to search a directory to current executing named SAS_macros (if it exists).

RW9 · ‎04-01-2016

Out of interest, why all the code? It basically distills down to: proc sort data=sashelp.class out=class; by age; run; proc print data=class; by age; run; Or worse case scenario: proc sort data=sashelp.class out=class nodupkey; by age; run; data _null_; set class; call execute(cat('proc print data=sashelp.class; where age=',strip(put(age,best.)),';run;'); run;

SAS_inquisitive · ‎03-31-2016

@ LinusH. This is just an example. But I know being able to process list (either horizontal or vertical) is an important skill.

Jay54 · ‎03-31-2016

A simpler example is easier to understand. This works. proc template; define Style myStyle; parent = styles.htmlBlue; CLASS graphdata1 / contrastColor=gold color=gold; CLASS graphdata2 / contrastcolor=silver color=silver; end; run; ods html style=mystyle; proc sgplot data=sashelp.cars; vbar type / group=type response=mpg_city stat=mean; run;

data_null__ · ‎03-30-2016

@SAS_inquisitive DO WHILE(1); is infinite loop. Notice the LEAVE statement to exit. _NAME_ is the value returned from CALL VNEXT. It is the name of a variable from the PDV. Each time VNEXT is executed it returns the "next" variable in the PDV. It provides a way to iterate across the PDV. It will also return the length and type of the variable. In some other languages it might be writen using FOR statement a list iterator. for NAME in PDV do end

Reeza · ‎03-29-2016

Out of date but here's a good starting point: http://www.sas.com/store/prodBK_63120_en.html I would pick something to focus on though, what type of graphs are you interested in? SGPLOT actually goes very far, but if you need very customized graphics then yes, using GTL is great. Also, try recreating a bunch of the standard graphs from procs (proc corr, proc reg diagnostic plots) will help you out. And you can see the templates. Learn how to modify the templates.

DanH_sas · ‎03-28-2016

Yes.

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;

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

Re: output statement

Re: multiple left joins

Re: creating a dataset

Re: keeping only particular observations in full join in proc sql

Re: Macro statment in Proc SQL

Re: date time issue

Re: report two variables in same column

Re: specifying file path and autocall macros in Unix SAS

Re: Concatenation with macro

Re: storing macro variable values in data set

Re: Integration of style element to GTL

Re: SAS Export

Re: Options of GTL statement

Re: color code

Re: sum statement within DO UNTIL()