About Tom

Tom · ‎09-28-2011

I do not think you can do that. If your code did not include macro control statements it should work. How about creating a sub macro and then passing in the name of the submacro? %macro doloop; %do i=1 %to 3; data _null_;run; %end; %mend doloop; %let x=doloop; %macro mm; %&x ; %mend mm; options mprint; %mm;

Tom · ‎09-28-2011

Are you just talking about the TAGSORT option on PROC SORT? http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a000146878.htm

Tom · ‎09-28-2011

You do not need to use SYMGET. Just reference the macro variable. Replace: WHERE uid eq %sysfunc(symget('abc_username')) AND pwd eq %sysfunc(symget('abc_password')) with WHERE uid eq "&abc_username" AND pwd eq "&abc_password" Note the quotes so that the compiler will see that the terms on the right hand side of the EQ operator are strings and not variable names or constants. Symget is only useful when running in a data step and you want to get the current value for a macro variable that you might have updated since the data step was compiled by using a CALL SYMPUT statement.

Tom · ‎09-27-2011

I am not sure why people use PROC EXPORT to create text files. The data step is in many ways easier and more flexible.

Tom · ‎09-27-2011

Remove the quotes from around the name of the symbol. When using %SYSFUNC() (and macro functions in general) you do not need to put quotes around strings. To the macro processor everything is a string.

Tom · ‎09-27-2011

This is actually a difficult problem to handle properly as some last names include spaces. data sample; input @ ; length first_name $50 last_name $50 ; last_name = scan(_infile_,-1,' '); first_name = substr(_infile_,1,length(_infile_)-length(last_name)); cards; Nadal Anthony Samuel John Beth Goodrich ; Run;

Tom · ‎09-27-2011

So you do NOT have two date fields. The first dataset has a number like 19,400,420 that you want to interpret as the date 1940/04/20. To convert it use bthdate = input(put(pthdate,z8.),yymmdd8.); format bthdate yymmdd10.; Also I am confused about dataset two. You say the format is MMDDYY10., but the dates you listed are have day before month.

Tom · ‎09-26-2011

Do you need the intermediate datasets with the numeric suffix? If not then why not just use a data step? Why do you need a macro? data all_data; set RF300l3.wacom_main; where curve_id in (&Curve_id); run;

Tom · ‎09-26-2011

You just got some extra characters into your program. The error message is that it did not understand the PROC statement. So of course it does not understand the other statements that only apply when running PROC EXPORT.

Tom · ‎09-26-2011

Look at this thread. http://bbs.cdisc.org/bbs/forums/thread-view.asp?tid=3473

Tom · ‎09-26-2011

As Art says add PATIENT to your TABLES statement. If you want it as a list then use the LIST option. Otherwise you will get a grid with #rows equal to the number of patients and #cols equal to the number of categories. TABLES patient*diagnosis / list ;

Tom · ‎09-26-2011

Art - I think that the problem is that ViewTable does not distinguish between the formats that are defined in the dataset and those that it is using because of default behaviour. I would prefer that it just leave the format/informat attributes empty in that screen, as they are in the dataset. If they must put in a default value then it should be marked in someway to distinguish between that and the value of the attribute that is in the dataset's metadata.

Tom · ‎09-26-2011

proc freq ; tables response*category / norow nopercent ; run;

Tom · ‎09-25-2011

Looks like you want to loop over a set of SUFFIXES and use those suffixes for both specifing the name of the output dataset and the variable name. %macro stuff(suffixes); %local i j ; proc sql noprint; %do i=1 %to %sysfunc(countw(&suffixes)); %let j=%scan(&suffixes,&i); create table test&j as select role , cats(count(Q&j),'(',put(count(Q&j)/count(*),percent8.),')') as C&j from data group by role ; %end; quit; %mend stuff; %stuff(4 6 7 10 13);

Tom · ‎09-25-2011

Art - "Permanent formats" are just formats that are permanently attached because they are defined in the datasets. As opposed to formats that you temporarily attach during a procedure by using a format statement. - Tom

Online Status	Online
Date Last Visited	2 hours ago