About Alpay

Alpay · ‎06-22-2012

Expanding on Steve's code. data want ; set have ; by id1 id2 ; retain _id1 _id2; if first.id1 then do; _id1 = id1; _id2 = id2; end; if _id1 = id1 and _id2 = id2; drop _id:; run ;

Alpay · ‎06-22-2012

Asterisk will select all columns in underlying tables. In this case, two sub queries in above sql script act as tables. One sub query returns 4 variables, and the other one returns 2 variables. For more explanation, please refer to PROC SQL documentation in help file.

Alpay · ‎06-22-2012

Once you get your data set say work.state you can open a program editor window and create another data set. File -> New -> Program data work.state2; set work.state; NewVar = PRXCHANGE('s/(AM|PM)/ $1/',-1,F16); run;

Alpay · ‎06-22-2012

SAS assigns the length of a variable when it is seen first time. If the order of the data sets does not matter you can place the data sets with length 70 before the data sets with lenght 48 in set statement. Data gompers.gompers_2001_2011; set gompers.gompers_2007_2009_my gompers.gompers_2010_my gompers.gompers_2000_2001 gompers.gompers_2002_2005 gompers.gompers_2006 ; run; If the order of the data sets matters in set statement you can use a length statement before set statement to specify the length of the variable coname. Data gompers.gompers_2001_2011; length coname $70; set gompers.gompers_2000_2001 gompers.gompers_2002_2005 gompers.gompers_2006 gompers.gompers_2007_2009_my gompers.gompers_2010_my; run;

Alpay · ‎06-22-2012

SAS assigns a format to a column to display the value stored in that column. The above code would be used with datetime values which are stored as numeric variables. I just realized that F16 is a character column not numeric. In this case, you will need to change the value of that string with an operation or create a new variable. NewVar = PRXCHANGE('s/(AM|PM)/ $1/',-1,F16); Example: data _null_; x = '20/06/2012 10:02:35AM'; y = PRXCHANGE('s/(AM|PM)/ $1/',-1,x); put y=; run;

Alpay · ‎06-22-2012

I see why. Font name needs to be enclosed in single quotes when the overall text enclosed in double quotes. Please see the example below. %LET DISTNAME = Example; ods escapechar='^'; TITLE1 "&DISTNAME."; ods pdf file='d:\temp\test.pdf'; proc print data=sashelp.class; run; ODS PDF TEXT = "^S={just=center font=('Times New Roman',14PT,Bold)} Report produced for &DISTNAME. ISD"; %* ODS PDF TEXT = "^S={just=center font=(""Times New Roman"",14PT,Bold)} Report produced for &DISTNAME. ISD"; //* This would work, too */ ods pdf close;

Alpay · ‎06-21-2012

Can you try enclosing in double quotes instead of single? ODS PDF TEXT = "^S={just=center font=("Times New Roman",14PT,Bold)} Report produced for &DISTNAME. ISD";

Alpay · ‎06-21-2012

y is an array of variables y2004 thru y2010. Its values initialized to missing at the beginning of the data step. yr is a variable to denote the index value for array y. y[yr]+ part will increment the value of the variable referenced (e.g., yr=2005 means y2005 variable). *(year>yr and year <=(yr+6)) part is an inline indicator whether year is greater than yr and year is less than or equal to yr + 6. If the criteria holds, it will be computed as 1 otherwise 0. For your case, starting year and ending year values need to be changed to 1938 and 2002, respectively. Also, the expression *(year>yr and year <=(yr+6)) needs to be replaced with *(year>yr and year <=(yr+10)).

Alpay · ‎06-21-2012

You already have first part as a subquery. Do the same type of sub querying for the additional two variables and merge the results. data have; length sex race trt time $20; length subno weight height age 8; input subno weight height sex race age trt time; datalines; 1 63.7 141.85 Male Caucasian 19 Drug present 1 63.7 141.85 Male Caucasian 19 Drug past 2 72.6 149.22 Female Black 27 Placebo present 2 72.6 149.22 Female Black 27 Placebo past 3 60.7 147.64 Female Caucasian 26 drug present 3 60.7 147.64 Female Caucasian 26 drug past 4 64.2 150.93 Male Caucasian 21 Placebo present 4 64.2 150.93 Male Caucasian 21 Placebo past 5 60.6 153.56 Male Asian 41 drug present 5 60.6 153.56 Male Asian 41 drug past ; run; proc sql; create table want as select 'n subjects' as col0, * from ( select sum(upcase(trt)='DRUG' and upcase(time)='PAST') as drug_past, sum(upcase(trt)='DRUG' and upcase(time)='PRESENT') as drug_present, sum(upcase(trt)='PLACEBO' and upcase(time)='PAST') as pla_past, sum(upcase(trt)='PLACEBO' and upcase(time)='PRESENT') as pla_present from (select distinct subno,trt,time from have) ) , (select sum(upcase(trt)='DRUG') as drug_total, sum(upcase(trt)='PLACEBO') as pla_total from (select distinct subno,trt from have)) ; quit;

Alpay · ‎06-21-2012

You can define you own format by using directives in a picture statement as follows: proc format; picture dmyhmsampm low-high = '%0d/%0m/%Y %0I:%0M:%0S %p' (datatype=datetime); run; data _null_; x = '20Jun2012 10:02:35'dt; put x dmyhmsampm.; run; For explanation of these directives please see the documentation for PICTURE statement in PROC FORMAT section.

Alpay · ‎06-20-2012

I am assuming you will want one row data set with ypur named variables. data x; informat one two three four five comma12.; input year one two three four five ; datalines; 2005 36,565,000 38,964,000 43,091,000 41,709,000 64,508,000 2006 36,761,000 39,090,000 42,869,000 42,619,000 66,213,000 2007 37,282,000 39,514,000 42,582,000 43,291,000 67,981,000 2008 37,342,000 39,707,000 41,966,000 43,723,000 69,878,000 2009 37,422,000 39,717,000 41,866,000 43,733,000 69,888,000 2010 37,501,000 39,727,000 41,766,000 43,743,000 69,898,000 2011 37,468,000 39,737,000 41,666,000 43,753,000 69,978,000 ; run; data want; array y [2004:2010] y2004-y2010; do until(last); set x end=last; upperlimit = MIN(2010,Year); do yr = 2004 to UpperLimit; y[yr]+((.1)*(one + two + three + four + five)*(year > yr and year <= (yr+6))); end; end; put (y2004-y2010)(=); keep y2004-y2010; run; y2004=138091600 y2005=138868100 y2006=116112900 y2007=93047900 y2008=69786300 y2009=46523700 y2010=23260200

Alpay · ‎06-20-2012

You can use numx.d format to display comma instead of a period to separate decimal point. data have; input xvar yvar; datalines; 1.2 2 2.3 3 3.5 5 4.2 7 ; run; goptions reset=all border cback=white htitle=12pt htext=10pt; title; axis1 label=none; symbol1 interpol=spline value=dot color=blue; proc gplot data=have; plot yvar*xvar/vaxis=axis1 ; format yvar xvar numx.2; run; quit;

Alpay · ‎06-19-2012

Here is a very simple example of parallel processing using SAS/Connect. You can pass parameter values from parent to child sessions using %syslput. Replace %macro p definition with your macro definition or have your macro available to your child sessions in sasautos folders so that they can be searched automatically. options threads autosignon sascmd="!sascmd -nonews -asynchio -noterminal"; signon task1; %syslput parm = 1; rsubmit task1 wait=no; %macro p(p); %put parm = &p; %mend; %p(&parm); endrsubmit; signon task2; %syslput parm = 2; rsubmit task2 wait=no; %macro p(p); %put parm = &p; %mend; %p(&parm); endrsubmit; waitfor _all_ task1 task2; signoff task1; signoff task2;

Alpay · ‎06-19-2012

If you modify your code as follows you won't need proc sort after step proc summary as proc summary generates sorted output by class variables. I don't have data to test it but give it a try. proc summary data=old1 nway; class soc randtext/missing; output out=probe (drop=_type_); run; proc transpose data=probe out=tprobe; by soc; id randtext; var _freq_; run;

Alpay · ‎06-19-2012

You are right. I did not test it before I submitted above code. First period acts as a delimiter for &i in the first pass. Second period acts as a delimiter for &Country1 in the second pass. &&Country&i.csv -> Country1csv &&Country&i..csv -> abudahbicsv &&Country&i...csv -> abudhabi.csv

Online Status	Offline
Date Last Visited	‎07-30-2018 04:57 PM

Re: SAS Model Implementation Platform 3.1 New Features

Re: Dates = numbers? HOW

Re: Need help in introducing parallel processing.

Re: How to get one subset like this?

Re: How to get one subset like this?

Re: Top 10 retailors according to Script Count for Tpye

Re: Need help in introducing parallel processing.

Re: Need help in introducing parallel processing.

Re: Why this do until loop using all the observations?

Re: Transform dates to weeks and match with other dates?

Re: Row/column headings colors in tabulate

Re: how avoiding proc sorting before proc transpose

Re: Whats the problem about this loop?

Re: %SYSFUNC format problem

Re: proc sql summary table considering distints subjids

Re: Help sorting and removing dups

Re: summary proc sql (add a second subquery with different select dist...

Re: How to modify data in sas eg

Re: multiply lengths for variable (in character) while merging files

Re: How to modify data in sas eg

Re: How to reference a macro variable in ODS RTF TEXT= ?

Re: How to reference a macro variable in ODS RTF TEXT= ?

Re: variable creation conditional on time

Re: summary proc sql (add a second subquery with different select dist...

Re: How to modify data in sas eg

Re: variable creation conditional on time

Re: Decimal points to commas

Re: Need help in introducing parallel processing.

Re: how avoiding proc sorting before proc transpose

Re: problem of using macro to import multiple csv files