Ho Soha You can also use the SG... procs to achieve the result, see example below. They allow to overlay plots with some settings for barwidth and discreteoffset you get two bar beside each other. With this example there is no need to change our data data plotData; infile cards; input Region $ Sales2009 Sales2010 ; cards; East 543 487 North 500 565 South 825 750 West 600 700 ; proc sgplot data=plotData; hbar region / response=sales2009 discreteoffset=-0.2 barwidth=0.4 ; hbar region / response=sales2010 discreteoffset=0.2 barwidth=0.4 transparency=0.5 ; run;
... View more
hi Kamalakar this message indicates, that the font was not found in the SAS registry. To see which fonts are defined in the SAS registry, you can use the following code: proc registry startat="\CORE\PRINTING\FREETYPE\FONTS" list ; run; Then check the log. All the fonts that are on your system are usually registered during the install process of SAS. However you can register fonts later using Proc FONTREG, see sample below proc fontreg mode=add msglevel=normal usesashelp ; truetype "c:\windows\fonts"; run; Please also check the documention for Proc REGISTRY and Proc FONTREG for more information. Bruno
... View more
Hi Ashwini In general the intermediate result tables/views are automatically deleted at the end of a job, since they are in the WORK library. If you want to delete them earlier you could add a User Written transformation and add your own code to delete the tables/views. You can simply connect the result tables/views from transformation to your User Written transformation. The code below will delete all the tables which are connected to the User Written transformation. Please be careful about when to run this transformation, as it might delete tables/views which are needed in subsequent transformations %macro myDelete; %local i; proc sql; %do i = 1 %to &_INPUT_count; %if &&_input&i._memtype = DATA %then %do; drop table &&_input&i; %end; %if &&_input&i._memtype = VIEW %then %do; drop view &&_input&i; %end; %end; quit; %mend; %myDelete See also attached picture what it might look like Bruno
... View more
Please note In order to use a font it has to be registered in the SAS Registry One can use Proc FONTREG to this, see example below. The NOUPDATE option only shows what would happen, but the SAS Registry is not updated proc fontreg usesashelp mode=add noupdate ; truetype "C:\Windows\Fonts"; run; To use it as suggested, find an example below: proc gslide; note color=black font="Free 3 of 9" height=10 j=right angle=90 "<123>"; note color=black font="Arial" height=10 j=right angle=90 "<123>"; note color=black font="Free 3 of 9 Extended" height=10 j=right "<123>"; note color=black font="Arial" height=10 j=right "<123>"; run; quit; Bruno
... View more
Hi How about using the DLM= option of the FILE statement Data test; input name $1-1 age $ 3-5 sex $ 6-7; cards; a m b 14 m c 15 m d 8 f e f ; data _null_; set test; file "c:\temp\someFile.txt" dlm="!"; put name age sex; run;
... View more
hi Find below a working example. Macro variables created within a macro have usually a LOCAL scope. However you can make macro variables global, see example below I have also made some changes to your code sample %MACRO M1(COL,TAB,MACROVAR); %* make the macro var global; %global ¯ovar; %* * we are reading only the first obs of the table * the TRIMMED option will take away trailing blanks *; PROC SQL NOPRINT; select &col into :¯ovar TRIMMED from &tab(obs=1) ; quit; %put _local_; %MEND; %M1(MNEMONIC,SASHELP.ADOMSG,A1) %PUT NOTE: *&A1*; From your code it looks like you want to be able to access some messages from a data sets. Please have a look at the SASMSG http://support.sas.com/documentation/cdl/en/nlsref/63072/HTML/default/viewer.htm#n0pbh06faefiuyn1paei4vrvft2d.htm and SASMSGL http://support.sas.com/documentation/cdl/en/nlsref/63072/HTML/default/viewer.htm#n1iekis5qclbspn1wd6bno0jhtdq.htm functions as well
... View more
Hi NTVM Please mark this discussion as answered, maybe also provide the approach you did take. This will help others when searching for this. thanks Bruno
... View more
hi In order to see which configuration files are used, you can run the following code: proc options option=config; run; The output looks like this: CONFIG=( "C:\SAS93\SASFoundation\9.3\sasv9.cfg" "C:\SAS93\SASFoundation\9.3\nls\en\sasv9.cfg" ) Specifies a SAS configuration file. This will give you the information whether your sasv9_local.cfg is used. you can always specify a custom config file at SAS invocation like this: sas -sysin <SCRIPT> -config <CONFIG-FILE> ...
... View more
Hi when reading from a text file one can use the FILENAME= option of the INFILE statement to get the name of the file being read. This can be very helpfull if you are reading several files with the same DATA Step. See below for any example. The first DATA Step simply creates a test file. filename myinput "!TEMP\Garantees_20120730.txt"; data _null_; file myinput dlm=","; do i = 1 to 10; put i "20100730"; end; run; data someData; length _myFilename $ 2048 myFilename $ 256 ; infile myinput dlm="," filename=_myFilename; input line myDate : anydtdte. ; myFilename = scan(_myFilename, -1, "\"); format myDate date9. ; run;
... View more
Hi Steve I do not know of a format, but you can write a function to make a SAS date value out of the string, see sample below: proc fcmp outlib=work.myFunctions.dates; function xDate( date $); length dlm $ 1; dlm = "-"; year = scan(date, 1, dlm); month = scan(date, 2, dlm); day = scan(date, 3, dlm); newDate = cats(day, month, year); newDate_N = input(newDate, date9.); return(newDate_N); endsub; run; options cmplib=(work.myFunctions) ; data testFunction; date1 = '2011-AUG-12'; date2 = xDate(date1); format date2 date9.; run; Bruno
... View more
Liang When one is accessing a view (SQL or DATA Step), the data from the view is materialized and exists while reading from the view. If you read the data from the view several times, it is usually better to make a SAS Data Set out of it. Bruno
... View more
LiangCk You can make use of DATA Step views, in this way there is no SAS Data set created by the DATA Step but a view. The code for the view is executed when you access the view for instance when using Proc APPEND, see code below for a sample. A question on the code sample you provided: is there a reason that you use infile/input as well as file/put, just curious. Bruno * * create a DATA Step view *; data work.mycsv_Temp / VIEW=work.mycsv_Temp; infile mycsv dlm=";" dsd; input name : $16. sex :$1. age : 8. ; run; * * append to existing using DATA Step view *; proc append base=work.mycsv_base data=work.mycsv_Temp ; run;
... View more
Hi Filipvdr Check out the follwoing code below it uses Proc XSL (preproduction) to remove the names space information. * * remove name space stuff from XML response * * taken from http://wiki.tei-c.org/index.php/Remove-Namespaces.xsl *; filename rmns temp; data _null_; infile cards; input; file rmns; put _infile_; cards4; <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:output method="xml" indent="no"/> <xsl:template match="/|comment()|processing-instruction()"> <xsl:copy> <xsl:apply-templates/> </xsl:copy> </xsl:template> <xsl:template match="*"> <xsl:element name="{local-name()}"> <xsl:apply-templates select="@*|node()"/> </xsl:element> </xsl:template> <xsl:template match="@*"> <xsl:attribute name="{local-name()}"> <xsl:value-of select="."/> </xsl:attribute> </xsl:template> </xsl:stylesheet> ;;;; * * use XSL to remove namespace information *; filename xslout temp; proc xsl in=soapout out=xslout xsl=rmns ; run; Bruno
... View more
pysas I think you best discuss this with technical support and outline the steps you used to produce the the prompt as well as the report
... View more
Dhana The ability to upload files through a Stored Process was added with SAS9.2, see also http://support.sas.com/documentation/cdl/en/stpug/61271/HTML/default/viewer.htm#stpugwhatsnew902.htm
... View more
