About LarryWorley

LarryWorley · ‎01-29-2013

Alex, Yuo get a list of file names to iterate over, you can use a filename pipe ..... to get a list of files. Then iterate over Peter's code above to read the files if they are spreadsheets. If not spreadsheets, then you might have to build your own code to handle reading the data. I am attaching a paper I presented a couple of years ago which addresses this problem. Larry

LarryWorley · ‎01-25-2013

How do you want your final data set to look? I suspect the merge you are doing does not give you what you want?

LarryWorley · ‎01-11-2013

Tal, ANSI standard does allow the syntax of create table new_table_name as select column_spec1,....,, from table_name group by group_by_column_spec ; The issue with your query (as you suspected) is the word 'table' in the from clause 'from table a'. That clause should simply be 'from a' Larry

LarryWorley · ‎11-28-2012

I may be wrong here, but it seems to me that the easiest way to fix this is to remove the lag function since it is not needed. Since the overall implicit data loop runs only once, won't the following code generate the desired random walk? data want; call streaminit(123); do i=1 to 1000; x=rand('normal', 0, 1); if i=1 then y=x; else y=y+x; output; end; run;

LarryWorley · ‎11-19-2012

Just need to sort by id.

LarryWorley · ‎11-19-2012

By ID Variable visit_date Output the dataset with Only stats - min as first visit and max as last vist. You may need to add formats to the min and max. I'll let you figure out the exact syntax:-)

LarryWorley · ‎11-13-2012

Try like operator with multi-character wild card "%' where b.dsn like trim(a.prefix)||'%'

LarryWorley · ‎11-09-2012

Art's code does exactly what you are asking for. It adds the column called flag which has the requested values. But at the risk of sounding pedogic, you need to understand what you are doing. The purpose of forums like this is to share knowledge and help neophytes understand how to use SAS efficiently, not to get someone to write your homework or business assignment. IMHO, it would help you to understand the changes which Art suggested.

LarryWorley · ‎11-08-2012

Nor do you have to use proc transpose unless it is a homework assignment. Choose what you are most comfortable with and what your standards require. If you are working on large datasets then performance should be a consideration as proc transpose would be more efficient -- fewer passes through data and special purpose memory procedure rather than general purpose procedure.

LarryWorley · ‎11-08-2012

Chris, Thanks for posting the correct solution. I forgot the where clause in my solution. Larry

LarryWorley · ‎11-08-2012

So I am assuming your requirement is one record per CodeA with the three values of title. This sql code would do that: proc sql ; select d1.codeA as code ,d1.title as title1 ,d2.title as title2 ,d3.title as title3 from is d1 inner join is d2 on d1.codea = d2.codeA inner join is d3 on d1.codeA = d3.codeA ; quit ;.

LarryWorley · ‎11-07-2012

How about using day of week name (downame) format. Something like this: your_dummy_variable = (put(your_date_variable,downame.) = 'Monday' ) ; Note this assumes your date variable is actually a sas date value and not a sas datetime value.

LarryWorley · ‎11-07-2012

How about: Main01 = ( med01 = 'HTN')*htn or (med01 = 'DM')*dm ; If logical expressions are not you cup of tea, you could also use if-then logic.

LarryWorley · ‎11-07-2012

Assuming you have a dataset which consists of the list of storenames, you can do this with either a data step merge or proc sql left join. Here is example code: Data table_for_report; merge table_list (keep = store_name) sales_table(keep = store_name sales) ; by store_name ; if sales = . then sales = 0 ; run ; It is important that the table_list be the first table in the merge statement. A record will be create for each value of store_name which is in either table. The table will have a sales column which will be filled with the sales values from the second table when that store is in the sales table. otherwise it will have a missing value. Then the if statement converts the missing value to a value of 0.

LarryWorley · ‎11-02-2012

Except operator is succinct way of doing in sql. Here is example with your data. data A; input Id score ; datalines ; 1 200 3 300 5 600 7 500 ; data B ; input Id score ; datalines ; 1 200 2 400 3 300 ; proc sql ; select * from b except select * from a ; quit ;

Online Status	Offline
Date Last Visited	‎03-21-2016 10:07 AM

Re: Troubleshooting case statement

Re: SET statement point option

Re: SET statement point option

Re: Concatenation of 2 fields (need to retain Leading Zeros)

Re: SAS window trick?

Re: SAS window trick?

Re: Suggestions On Difficult Import

Re: Can Libname statement read the datasets which are named in capital...

Re: Suggestions On Difficult Import

Re: Suggestions On Difficult Import

Add BATCH SUBMIT button to EG

How to UPDATE on unique key in MySQL using SAS EG

Re: SAS/Connect, libname engine, invisible tables

Re: Help with merging databases

Re: why cards stop reading values at some length

Re: Hi

Re: SAS macro to import multiple Excel sheets, clean invalid data, etc...

Re: Many to Many Merge

Re: SQL code

Re: Anything wrong with the codes?

Re: Proc Summary

Re: Proc Summary

Re: Quick SQL Question

Re: Addind a dummy variable

Re: proc sql with subquery

Re: proc sql with subquery

Re: proc sql with subquery

Re: Addind a dummy variable

Re: Use value of variable as variable name

Re: How to insert missing records into a table?

Re: Proc SQL