SAS Support Communities

Howles · ‎05-25-2015

The lengths of the variables (especially character variables) are also an issue. So run PROC CONTENTS for each data set created.

Howles · ‎04-07-2015

UPDATE, or MODIFY??

Howles · ‎02-24-2015

how about seq = 5 - seq ;

Howles · ‎02-19-2015

05/01/2010 is not a valid date literal, but it is a valid numeric expression. ( (5/1)/2010 ) evaluates to 0.0024875, which interprets as 1 January 1960.

Howles · ‎02-11-2015

CASE is meant for this. PROC SQL; CREATE TABLE summary AS SELECT AVG( case when (c=0) then b else (.) end ) AS Mean_B_C0, AVG( case when (c=1) then b else (.) end ) AS Mean_B_C1 FROM data; QUIT;

Howles · ‎02-05-2015

also MODIFY

Howles · ‎02-04-2015

Try something like this. proc format ; invalue none_zero 'None' = 0 other = [12.] ; run ; data _null_ ; input val none_zero. ; put val= ; cards; 123 None ;

Howles · ‎02-04-2015

The original difficulty arises because the VALUE statement requires literals (not expressions). But the specs change only from one launch of the program to the next (not on the fly within the program). So %sysfunc and %eval offer a workaround. Try something like this: Proc Format; %let td = %sysfunc( today() ) ; %let wd = %sysfunc( weekday(&td.)) ; value week %eval(&td.-&wd.- 7) -< %eval(&td.-&wd. ) = week1 %eval(&td.-&wd.-14) -< %eval(&td.-&wd.- 7) = week2 ; %symdel td wd ; run;

Howles · ‎01-28-2015

Go to Macro Collections - sasCommunity and follow Mayo Clinic link.

Howles · ‎01-23-2015

Actually that difference is 41972 1 data _null_ ; 2 days_between = '01dec2014'd - '01jan1900'd ; 3 put days_between= ; 4 run ; days_between=41972

Howles · ‎12-26-2014

Why (not) generate code with a macro? But first, make sure the target code is right. Why the ALLs in the UNIONs?

Howles · ‎12-26-2014

1. The (self-anointed) Macro Maven is Ron Fehd, not Ian Whitlock. 2. I would not dismiss the available user-written books about the macro facility.

Howles · ‎12-22-2014

See Convert Numeric Variables to Character - sasCommunity However, the technique might be defeated by the sheer number of columns.

Howles · ‎12-17-2014

What I don't know is how the SQL statement is optimized by PROC SQL. Maybe the SELECT is evaluated and the result set is spooled somewhere. Then the rows are batch-inserted into the target table. That seems to be the original poster's theory. Maybe the SELECT is evaluated and as each row is generated it triggers a single-row insertion operation. That's my hunch. The results will of course be the same either way, but the incurrence of overhead could differ.

Howles · ‎12-14-2014

I observe SQL defaulting to BEST8. The DATA step language uses BEST12. Try this: data demo ; numvar = constant('pi') ; put numvar ; run ; proc sql noprint ; select numvar into : macrovar from demo ; %put &macrovar ; quit ;

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

SAS Support Communities

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?

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: proc sql union and macro

Re: is there a Book on SAS macros authored by Ian Whitlock?

Re: How to convert all numeric columns to character columns in one sho...

Re: Sql Insert vs Data Step Efficiency Question

Re: unable to store datetime value in a macro variable

Follow Us

What is...