About Howles

Howles · ‎01-20-2012

Consider the SAS FTP Access Method http://www.google.com/search?client=safari&rls=en&q=SAS+FTP+Access+Method&ie=UTF-8&oe=UTF-8

Howles · ‎01-18-2012

I think it's simpler to do all in the SQL step. proc sql noprint ; select case type when "char" then "input("||name||",32.) as " else "" end || name into :renames separated by "," from dictionary.columns where libname="WORK" and memname="HAVE" ; create table want as select &renames from have ; quit;

Howles · ‎01-15-2012

Use a Double DoW after pre-processing to create an appropriate BY variable. data grouped ; set have ; by panelist ; groupnum + ( first.panelist OR ( dif(year) GT 1 ) ) ; run ; data want ; do many = 1 by 1 until (last.groupnum) ; set grouped ; by groupnum ; end ; do nn = 1 to many ; set grouped ; if many GE 3 then output ; end ; run ;

Howles · ‎01-15-2012

Here's a way which uses only documented features. proc sql ; ods output sql_results=numbered ; ods listing close ; reset number ; select * from sashelp.class /* (obs=1) */ ; reset nonumber ; ods listing ; ods output close ; create table first_last(drop=row) as select * from numbered having row EQ min(row) union all select * from numbered having row EQ max(row) ; drop table numbered ; quit ; Note that this will generate two rows if the given data set has one row (test that by un-commenting the OBS= option). If that behavior is not desired, it's simpler; get rid of the UNION and combine, with OR, the MIN and MAX conditions.

Howles · ‎01-13-2012

No need for a macro. Try this model. data have ; set sashelp.class ; * keep _numeric_ ; run ; data want ; set have ; array charvar _character_ ; do i = 1 to dim(charvar) ; drop i ; charvar(i) = upcase( charvar(i) ) ; end ; run ; Note that if there happen to be no character variables, a WARNING appears. You may want to bulletproof for that situation.

Howles · ‎01-11-2012

I would suggest proc sql; select /* distinct */ id format=best12. into :ids separated by ',' from l; select largest(2,&ids.) format=date9. as highest from sashelp.class(obs=1); quit; Use of DISTINCT in the first SELECT depends upon how ties are to be treated. No need for DISTINCT in the second SELECT if only one row is processed. The FROM clause can point to any table having at least one row and one column.

Howles · ‎12-26-2011

Maybe file ... dlm= '|' ; put name $8. '|' no sal ; The results should look like this: Rajesh |2563|5600 Kumar |5698|6580 |4568|7560 Abcde |4812|2461

Howles · ‎12-21-2011

Don't use a DATA step. Use PROC DATASETS instead for such metadata tasks.

Howles · ‎12-09-2011

I have little experience with dataset lists, which are a pretty new feature. However, variable lists, an old feature, are evaluated at compile time, so I think I would expect the behavior you found. I would use PROC SQL and tap DICTIONARY.TABLES to get the current list.

Howles · ‎12-09-2011

To take it a step further, one can create a custom interval to reflect the holiday pattern. See http://www.sascommunity.org/wiki/Generating_Holiday_Lists#Custom_Intervals

Howles · ‎12-07-2011

Consider using a multilabel format.

Howles · ‎12-04-2011

Look at PROC EXPAND (in SAS/ETS). podarum wrote: Hi, I guess my 2 questions are first, how can I convert from annual GDP to monthly GDP.. some sort of extrapolation. Secondly, anyone knwo if I do have let's say 1999 GDP = $1.75Bill and 2000 = $2.1Bill could I do an average like 1999.01 = $1.75Bill and 1999.02 = $1.75Bill or do I divide $1.75Bill into 12 so 1999.01=$145Mill and so on for each month?? Thanks

Howles · ‎11-21-2011

I would probably use this approach: proc sql ; create table want as select coalesce(main2.key, minor2.key) as key from (select key , 1 as mainflag from main ) as main2 full join (select key , 1 as minorflag from minor) as minor2 on main2.key EQ minor2.key where n(mainflag, minorflag) EQ 1 ; quit ; Some of the other techniques might encounter difficulties when there are composite keys when there are missing-values in the keys when there are satellite variables littlestone wrote: Thank you. Is it possible to do the task using JOIN method?

Howles · ‎11-21-2011

Yes. See http://support.sas.com/techsup/technote/ts553.html http://www.nesug.org/proceedings/nesug03/at/at008.pdf LinusH wrote: I think it's hard to optimize this one and keep it as one sql. If you can, try to split your data into (overlapping) smaller chunks of data, based on geographical position. Then doing cartesian joins will give smaller overhead. Linus

Howles · ‎11-18-2011

See http://www.sascommunity.org/wiki/Computing_Products iusing wrote: As the title, what is the sas function of ∏?

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

Re: I'm trying to convert SAS code into SQL.

Re: Update existing and insert new record to sas dataset.

Re: invert a sequence column in a dataset

Re: Need help working with the dates

Re: Can PROC SQL AVG function be completed within different subsets in...

Re: difference between merge set and update

Re: Numeric and Character Observations under a Variable

Re: Can we use changing dates in proc format?

Re: Picking matched controls

Re: Date informat MMDDYY10. incorrect?

Re: how to insert a new colomn into dataset use proc sql?

Re: Use RETAIN to re-order variables

date diff SQL to Sas

UPCASE ALL VARIABLES IN DATASET

Re: converting numbers to time format?

How to write resultset (csv files in this case) onto an FTP server

Re: convert alpha to numeric without creating a new var

Re: consecutive observations only

Re: how can we get the first and last observations in a dataset using ...

UPCASE ALL VARIABLES IN DATASET

To find the second Highest Date

Re: want to give space between in two variables in txt

Data step with multiple data sets

Dataset list in data step view does not work as expected

SAS ETS Date Variable

Summing Based on condition for Year

annual to monthly GDP conversion

Re: How to do this using Proc SQL?

Re: SQL Cartesian product optimization

Is there any multiplication function (∏) in sas?