Hi How where the original SAS Data Sets created? Using the Import task from EG or Proc Import or ... If you are using SAS Enterprise Guide, it will set the SAS System Option VALIDVARNAME=ANY. This might be the cause of the names you are seeing. You can use options validvarname=v7; so that Proc IMPORT creates names with underscores at places where the original name had blanks
... View more
Hi Miguel You can make use of Perl Regular Expression functions to do what you want. For the case you are interested you can make use of the PRXCHANGE function See sample below. The HTML tags are placed by "*". As I am not the Regex expert, I search for what I want to do, and then adapt the Regex to the appropriate SAS PRX... function. data posts; length id $5 username $10 post $250; infile datalines delimiter=','; input id $ username $ post $; post2 = prxchange("s/<[^>]*>/*/ ", -1, post); datalines4; 338,"jessykate",<a class=\"mention\" href=\"/users/tim\">@tim<\/a> AHA!! thank you! i will try that :D. 223,"chris",Hi All <\/p>\n\n<p>Quick update on discourse - File uploads now work - Upload away! 1017,"ralfe",Hi <\/p>\n\n<p>I quite like <a class=\"mention\" href=\"/users/ahnjune\">@ahnjune<\/a> 's suggestion. If you go to <a href=\"https://p2pu.org\">https://p2pu.org<\/a> then click on the drop-down arrow to the right of your profile ;;;; proc print; run;
... View more
You can access the Environment Manager by using http://hostname:7080/ where hostname is the name where the SAS Environment Manager Server runs. By default you should use the sasadm@saspw to first login.
... View more
Hi You can use the inline formatting functions to achieve what you are after. For that you need to set the ESCAPECHAR= option for ODS. You can find more information about the available inline formatting functions here: SAS(R) 9.4 Output Delivery System: User's Guide, Third Edition. The sample below use the {NEWLINE} and {UNICODE} functions. Please consider the length of this additional text in the variable that is used for reporting. The SPLIT= option is for spliting column header text. Find below sample code. data x; infile cards dlm="," ; input pt text : $60. ; cards; 1,Protocol required data collection / testing (9) 1,Study visit early or late (9) 1,System not implanted per protocol (1) ; data x1; length temp $ 1024; set x; retain temp; temp = catx("^{newline}", temp, catx(" ", "^{unicode 25cf}",text) ); run; ods escapechar="^"; proc report data=x1 nowd split="/"; column pt temp; define pt / display; define temp / display; run;
... View more
Kurt You can use the NAME= option on the individual plot statement to name the file being created. See sample code below. proc catalog c=work.gseg kill; run; quit; ods html file="c:\temp\sample.html" gpath="c:\temp" (url=none); proc gplot data=sashelp.class ; plot age * weight / name="sample_"; run; quit; proc gbarline data=sashelp.class; vbar age / name="sample_"; plot / sumvar=height ; run; quit; ods html close;
... View more
Hi the INFILE statement supports wildcards, the FILENAME= option names a variable that will contain the name of the file that a records was read from. Please note, that the variable named by the FILENAME= option is dropped automatically, so you need to assign the value to some other variable. See also example 5 in the doc for more ideas on the list of files to read SAS(R) 9.4 Statements: Reference, Third Edition data someData; length _xFilename $ 256; infile "c:\temp\*.csv" filename=_xfilename; xFilename = _xFilename; input @1 line $10. ; run; bruno
... View more
Proc REPORT can do this using the GROUP and ACROSS usage for the variables, see sample code below. data have; infile cards dlm=","; input id : $8. date : mmddyy8. device : $8. desc : $32. ; format date date9.; cards; A1,03/01/15,R150,Supplier1 A1,03/01/15,R151,Supplier4 A1,03/01/15,R171,Supplier4 a2,03/02/15,R161,Supplier2 b1,03/03/15,R152,Supplier3 ; proc report data=have; column desc date; define desc / group; define date / across; run;
... View more
As already mentioned you can use the "External File" functions of the DATA Step to get this information, see also SAS(R) 9.4 Functions and CALL Routines: Reference, Third Edition Below is a sample program that will get a list of files with a given extension. %macro getFileList( dirName= , extType= , outDsn= ); %let extType = %upcase(&extType); data &outdsn; length msg $ 256 fileRef $ 8 dirName $ 1024 fileName $ 256 fullName $ 1281 ; * * check if dirName exist *; rc_check = fileexist("&dirName"); if rc_check = 0 then do; putlog "ERROR: &sysMacroname &dirName does not exist"; stop; end; * * assign a fileref to the directoy, let SAS decide on the fileref used *; rc_assign = fileName(fileRef, "&dirName"); * * open the directory * if open fails write message and clear fileref *; dirId = dopen( fileRef ); if dirId = 0 then do; msg = sysmsg(); putlog "ERROR: &sysMacroname could not open &dirName as directory"; putlog msg; rc_assign = fileName( fileRef ); stop; end; * * open was sucessfull * get the number of files in the directory *; n_files = dnum( dirId ); do i = 1 to n_files; * * get the names of the files and check for the extension * we do not check whether the file returned is a file or directory *; fileName = dread(dirId, i); if upcase(scan(fileName, -1, ".")) = "&extType" then do; dirName = "&dirName"; fullName = catx("\", dirName, fileName); n_match + 1; output; end; end; * * clean up *; dirId = dclose( dirId ); rc_assign = fileName( fileRef ); msg = catx(" ", "NOTE: &sysMacroname found", n_match, "files that match &extType"); putlog msg; keep dirName fileName fullName ; run; %mend; * * test the macro *; %getFileList( dirName=c:\temp , extType=csv , outDsn=work.csvList )
... View more
Have a look below. Only mention the scatterplot name in the discretelegend statement and use the legendlabel option for the text of the legend label proc template; define statgraph barscatter; begingraph; entrytitle 'Best Percent Change in Lesion Size'; layout overlay / xaxisopts=(display=none) yaxisopts=(label="&ylab." linearopts=(viewmin=-1.05 viewmax=%sysevalf(&yaxismax.+.05) tickvaluelist=(&tickvaluelist.))); barchart x=n y=bestpct / group=posneg name='b'; scatterplot x=n y=scattermissing / markerattrs=(symbol=X color=cx000000) name='s' legendlabel='No Post-Baseline Assessment' ; referenceline y=eval(coln(0.2, -0.3)) / lineattrs=(color=black pattern=dot); discretelegend 's' / across=1 autoalign=(bottomleft) location=inside; endlayout; endgraph; end; run;
... View more
Hi You can use the TRANSPOSE procedure to do this. See example below: data have; infile cards dlm=","; input pers $ Year Month Variable $ Value ; cards; AAA,2001,01,Var1,100 AAA,2001,01,Var2,200 AAA,2001,06,Var1,110 AAA,2001,06,Var2,210 AAA,2002,01,Var1,120 AAA,2002,01,Var2,. BBB,2001,01,Var1,100 BBB,2001,01,Var2,200 BBB,2001,06,Var1,110 BBB,2001,06,Var2,210 BBB,2002,01,Var2,220 ; proc sort data=have; by pers year month; run; proc transpose data=have out=want(drop=_name_) ; by pers year month; id Variable; var Value; run;
... View more
Open the file as XML file in the SAS XML Mapper Application, go to Tools -> Automap using XML You will get the same tables as you mentioned. See screenshot
... View more
I do not know what exactly your query needs to be, write your query into a file while reading from the first table and then use %INCLUDE to run the code written to the file. See sample below: data have; infile cards dlm="," dsd; input id : 8. tableName : $32. ; cards; 1,TableA 2,TableB 3,TableA 4,TableB 1,TableC 5,TableC ; %macro createtables(name=); data &name; do id = 1 to 5; someValue = catx("_", id, "&name"); output; end; run; %mend; %createtables(name=tableA) %createtables(name=tableB) %createtables(name=tableC) filename mycode temp; data _null_; set have end=last; file myCode; length query $ 1024; query = catx(" ", 'select a.* from' , strip(tableName) , 'as a' , 'where a.id = ' , id ); if _n_ = 1 then do; put "proc sql;"; put "create table want2 as"; put query; end; else do; put "outer union corresponding"; put query; end; if last = 1 then do; put ";quit;"; end; run; %include myCode / source2; filename myCode clear;
... View more
I suggest to copy all the tables from the PROPHET library to the WORK libray. This will give you random access and the XML data does not have to be read everytime.
... View more
