About sandyming

rfortin · ‎02-11-2017

I want to apologize for my last post. I mistakenly responded to this threaded topic that was similar to one I had posted. rfortin

Tom · ‎03-24-2015

That is not a test for existence. That is a test for whether it is empty. They are two different things. For example if I want to write a macro than can optionally update the macro variable RETURN I could add this line of code to the top of the macro to check if the macro variable exists and if it doesn't make a local version so that the value is not returned. %if not %symexist(RETURN) %then %local return ; Notice that this will work better than adding a %GLOBAL statement since it will allow for the existence of the macro variable in the local scope of a calling macro environment.

PGStats · ‎08-05-2014

There are so many ways to do things in SAS! How did you get your graph? PG

jimevo888 · ‎07-11-2014

For full SAS/GRAPH customization, you really want to go on the ANNOTATE and PROC GREPLAY path. I have developed a fully customized 6 chart data-driven dashboard with nested VBAR in one of the charts using the annotate facility within a PROC GCHART output. The graphing output is definitely less "spectacular" in comparison to the output from PROC SGPLOT but there is still plenty of potential to create some stunning charts within a dashboard template. Anyway good luck... James

Cynthia_sas · ‎10-30-2013

Hi: Is your NAME variable a character variable? And if so, do you have a leading space(s) in front of the 3.8? With the code below, I find that the first 3 obs, that are "padded" or the right number of characters, does work correctly in PDF. But the last obs doesn't look right, even with Courier New font, because the (3.8) isn't as wide as the (100.0). cynthia ods _all_ close; data testit; infile datalines; input @1 Name $char11.; obsnum=_n_; return; datalines; 100 (100.0) 5 ( 3.8) 12 (999.9) 15 (3.8) ; run; ods pdf file='c:\temp\testits.pdf'; proc report data=testit; column obsnum Name; define obsnum / order; define Name / display style(column)={just=r font_face='Courier New' font_weight=bold}; run; ods pdf close;

Peter_C · ‎09-14-2013

If the context where the code will run is "explicit pass through" then Tom's use if the Teradata format looks most effective ! If "implicit pass through" then there should be no need for special arrangements as SAS automatically understands and handles the datatypes like datetime constants. Of course it has been some time since I programmed queries and user transforms in SAS DI.

Tom · ‎09-12-2013

CALL EXECUTE() is one way to generate code to run after the current step has completed. Another way is to write the code into a text file using normal PUT statements and then %INCLUDE the file, this will avoid a lot of the macro quoting and timing issues of CALL EXECUTE() %macro report (name); %put Running report for NAME=&name ; %mend ; filename code temp; data _null_; set sashelp.class (obs=5); file code ; put '%report(' name= ');' ; run; %inc code / source2 ; 18 %inc code / source2 ; NOTE: %INCLUDE (level 1) file CODE is file .../#LN00033. 19 +%report(Name=Alfred ); Running report for NAME=Alfred 20 +%report(Name=Alice ); Running report for NAME=Alice 21 +%report(Name=Barbara ); Running report for NAME=Barbara 22 +%report(Name=Carol ); Running report for NAME=Carol 23 +%report(Name=Henry ); Running report for NAME=Henry NOTE: %INCLUDE (level 1) ending.

sandyming · ‎08-23-2013

proc stdize data=old out=new missing=mean reponly; var _numeric_; run; You can also calculate the median first, then read values from a second data set

Tom · ‎07-02-2013

If you have a PROC CPORT generated transport file then you must read it using a SAS session that is running using UTF-8 encoding. You cannot switch on the fly to UTF-8 just to read the transport file. I have no idea what SAS would do with a V5 Transport file with UTF-8 encoding, but I suspect that the same issues would apply.

sandyming · ‎07-02-2013

Wow, three excellent ways to solve the problem!

ballardw · ‎05-09-2013

If you use Tom's approach make sure the length, the $200, actually covers the length of ALL lines in the files. I know that programs really shouldn't have lines that long but occasional things like datalines may exceed that expectation.

sandyming · ‎05-07-2013

Something like this? proc sql; create table temp as select a.usubjid, a.avisitn, count1/count2 as pct (select usubjid, avisitn, count(usubjid) as count2 from dataset where trt1 ne '' group by avisitn ) a left join (select usubjid,avisitn,count(usubjid) as count1 from dataset where trt1 ne '' and drug='PLACEBO' group by avisitn) b where a.avisitn=b.avisitn; quit; then you can merge with original with usubjid avisitn....

sandyming · ‎05-07-2013

Thanks, Astounding. I made a mistake at one place, missed a parenthesis , %fmt(inlib1=%str(c:\temp1\p_v1), inlib2=%str(c:\temp1\p_v2);

siliveri4uall · ‎05-09-2013

Hi, data data1; input wk2 estimate; datalines; 1 12 2 14 3 15 ; run; %macro Test (num=); proc sql noprint; select estimate into : aa from data1 where wk2=&num; quit; %put &aa; data data2; wk=&num; estimate=&aa; run; proc print;run; %mend Test; /* calling the macros */ %test(num=2); %test(num=3);

Haikuo · ‎04-03-2013

DN, Congratulations! and many many Thanks! Haikuo

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

Re: how to check if a macro variable exists....

how to check if a macro variable exists....

Re: Insert cgm graph into word

Insert cgm graph into word

Re: Put multiple PROC SGPLOT outputs on the same page

Re: Put multiple PROC SGPLOT outputs on the same page

Put multiple PROC SGPLOT outputs on the same page

Re: DATETIME22.3 to yyyy-mm-dd time

Text alignment in Proc Report to PDF

Re: Time stamp format help

Re: macro in a loop

Re: how to identify a time variable (time5. format) is num or char, no...

Re: how to identify a time variable (time5. format) is num or char, no...

Re: how to identify a time variable (time5. format) is num or char, no...

Re: DATETIME22.3 to yyyy-mm-dd time

Re: how to check if a macro variable exists....

Re: Insert cgm graph into word

Re: Put multiple PROC SGPLOT outputs on the same page

Re: Text alignment in Proc Report to PDF

Re: Time stamp format help

Re: macro in a loop

Re: replace missing value with mean

Re: XPT file encoded in UTF-8

Re: How can I create a dataset with all unique values of over 100 vari...

Re: How to delete one line from multiple SAS programs?

Re: can anyone help this is urgent

Re: Need help with a simple macro

Re: Create a macro variable based on another dataset

Re: how to identify a time variable (time5. format) is num or char, no...