About Fraktalnisse

Fraktalnisse · ‎04-03-2015

I thought that i gave the %unquote answer in reply 6.

Fraktalnisse · ‎04-01-2015

Hi! It seems that when you build names like this, with macros, the result is not considered as one name by sas. Instead it's considered as two names that are concatenated. But if we put the expression inside of some macro function, we can put the parts together again. For example: data; azz=0; v1 = %unquote(%test(1)zz); run;

Fraktalnisse · ‎03-24-2015

Does this help? This lists the file sizes for all data sets in SASHELP library. proc sql; select memname, filesize format=sizekmg10.1 from dictionary.tables where libname='SASHELP' and memtype='DATA'; quit; You can also use the Tasks->Data->Data Set Attributes task, which includes a File Size field in its report.

Fraktalnisse · ‎11-28-2014

Why not use Proc Compare? proc compare data=Dataset1 compare=Dataset2 nosummary listvar; run;

Fraktalnisse · ‎11-19-2014

I believe that this question has already been answered, but here is yet another solution: when %unquote(%nrstr(&n)%eval(&k-1)) le myvar le &&n&k then %scan(&response,&k," ")

Fraktalnisse · ‎03-05-2013

Maybe this example can help you: %macro test(var); data table; set sashelp.class; where age in (12 %if &var=fourteen %then ,14 ; ); run; %mend; %test(fourteen) %test(notfourteen)

Fraktalnisse · ‎01-17-2013

Hi! As far as I know, you can't sum a subset of array elements with one function call. You have to write a do-loop. Mabye something like data s1n_test; set s1n_lags; array ppt_lag{37}; array ppt_sum{37}; do i=1 to 37; ppt_sum{i}=0; do j=1 to i; ppt_sum{i} = sum(ppt_sum{i},ppt_lag{j}); end; end; run;

Fraktalnisse · ‎01-11-2013

Hi! It sounds like a Proc Sql join. For example: proc sql; create table c as select b.date,b.key from a right join b on a.date=b.date and a.key=b.key where a.date=. and a.key=.; quit;

Fraktalnisse · ‎01-10-2013

Hi! The Contains operator is not limited to Proc Sql. It can be used in the data step, but only in a Where statement. I suggest the following: data nicholas._21603_; modify nicholas._21603_; if find(Combo,"23601") then remove; run;

Fraktalnisse · ‎01-09-2013

Hi! You have to write a complete data step. For example: data NewData; set InputData; combo=transtrn(combo,'21603',trimn('')); run; If you would like to remove certain characters from a text string, the compress function is easier than transtrn. But compress doesn't work for longer substrings, if you would like to remove 21603 you can't use compress.

Fraktalnisse · ‎01-09-2013

Hi! If you would like to take out the first 5 characters, you can use combo=substr(combo,1,5); If you would like to take out everything before _, you can use combo=scan(combo,1,'_'); or if you would like to search for 21603 and replace that with nothing, use combo=transtrn(combo,'21603',trimn('')); if you would like to remove all _, use combo=compress(combo,'_');

Fraktalnisse · ‎01-07-2013

Hi! Another way is to create a function with Proc Fcmp that calculates the age. From this, you can create a format that you can use on a date variable, to display both the date and the age. Something like this: /*Create function*/ proc fcmp outlib=work.myfunc.group; function fmtfunc(dob) $ 20; length text $ 20; age=int(yrdif(dob,today(),'age')); text=cats(put(dob,date9.),'(',put(age,3.),')'); return(text); endsub; run; /*Tell Sas where to fund the function*/ options cmplib=work.myfunc; /*Create a format that you can use on yout date variable*/ proc format; value agefmt (default=20) other=[fmtfunc()] ; run; proc print data=testData; format dob agefmt.; run;

Fraktalnisse · ‎01-07-2013

Hi! One solution is to convert the values to text with the function PUT, and then create a text variable from this. Mabye something like this: /*Create data with numeric variables*/ data testData; dob='21jan1988'd; age=25; run; /*Create text variable for presentation*/ data testData; set testData; text=cats(put(dob,date9.),'(',put(age,3.),')'); run;

Fraktalnisse · ‎01-07-2013

Hi! The data step will process only one observation at a time. The function pctl calculates the percentile based on the values that you send into the function, in the function call. A "row-calculation". You would like to calculate the percentile based on a column, and then compare this value to each row. Mabye something like this? /*Calculate 75 percentile*/ proc means data=sashelp.class noprint; var height; output out=p75dataset p75=p75DSvar; run; /*Store 75 percentile in a macro variable*/ data _null_; set p75dataset; call symputx('p75Mvalue',p75DSvar); run; /*Find the subset*/ data subset; set sashelp.class; where height>=&p75Mvalue; run;

Fraktalnisse · ‎11-30-2012

In Proc Transpose, the values in the ID variable will be interpreted as variable names in the output data set. Invalid characters will be replaced with underscore. For example, the values %ALK+ and %ALK- will both be transformed into the valid variable name _ALK_. So, this value occurs twice in the same by group.

Online Status	Offline
Date Last Visited	‎01-08-2020 11:54 AM

Re: Why doesn't this macro work?

Re: Why doesn't this macro work?

Re: Is there a way to view the physical size of SAS Data set within En...

Re: Check if Multiple Variables exist in a SAS Dataset

Re: &var and %eval, cannot combine??

Re: Macro %IF %THEN %DO %PUT %STR in DATA WHERE step

Re: Summing with Arrays

Re: Identifying observations Found in Set B but not found in Set A

Re: Delete observations that CONTAIN in a variable a certain word

Re: Search and Replace in a text column

"One fee for everything and everyone” - FANS enables workers from Wasa...

Re: Why would someone use SAS?

Re: Concatenating date variable with numeric variable

Re: Delete observations that CONTAIN in a variable a certain word

Re: Is there a way to view the physical size of SAS Data set within En...

Re: Why doesn't this macro work?

Re: &var and %eval, cannot combine??

Re: Why doesn't this macro work?

Re: Why doesn't this macro work?

Re: Is there a way to view the physical size of SAS Data set within En...

Re: Check if Multiple Variables exist in a SAS Dataset

Re: &var and %eval, cannot combine??

Re: Macro %IF %THEN %DO %PUT %STR in DATA WHERE step

Re: Summing with Arrays

Re: Identifying observations Found in Set B but not found in Set A

Re: Delete observations that CONTAIN in a variable a certain word

Re: Search and Replace in a text column

Re: Search and Replace in a text column

Re: Concatenating date variable with numeric variable

Re: Concatenating date variable with numeric variable

Re: Observations above the 75th percentile

Re: Why the errors were coming with data values?