SAS Support Communities

HI Randmize means assign to trt groups ,Here 20 subjects are randmized in this again 3 are not assign to trt How? ... View more

Hi, Could you try this program?   filename in PIPE 'type c:\temp\prodrun.log'; data check;   infile in missover pad;   input line $1000.; run; ... View more

here is the code may helpful data work.cleandata36; set cert.input36; group=upcase(group); if group in ('A','B'); run;   proc means data=work.cleandata36 median; class group; var kilograms; run;   data results.output36; set cleandata36; if Kilograms < 40 or Kilograms > 200 then do; if group='A' then kilograms=79; else kilograms=89; end; run;   proc contents data=results.output36; run; ... View more

This did not help me directly, because that was not my question, but this answer helped me indirectly to solve another problem. Thanks.   - Dr. Abhijeet Safai ... View more

For folks who find the above solutions unsatisfactory or you're wondering why LOCK LIBNAME LIST or LOCK LIBNAME QUERY is returning something to the effect of "You and nobody on your system is locking this dataset." and yet you run a PROC DATASET step and your files are still locked, you have more options.   You can check to see what files are in use by your system and terminate/kill those processes by process ID's.   For Unix Systems, you can use lsof -p | grep FILENAME which will spit out the process ID(s) using the file. You can kill that process with kill -v PROCESS_ID.   On Windows Servers, you have to install the Handle.exe program onto your compute server. Then you must open up the command prompt and run the handle.exe file and feed it the name of the table/file you are attempting to access. Which will provide the process ID(s) using the file. You open up Windows Task Manager, go to Details, sort your process IDs, and then you can kill that process.   It is highly likely this will damage the file, however, we can delete the file and replace it with SAS Data Integration Studio. Looking at the LIBNAME statement you can find where on your machine the file is and delete it. Then you use SAS Data Integration studio to recreate your corresponding library. ... View more

Retrieving the source code of a compiled macro, such as a CapCut Reels template, is typically not possible. When code is compiled, it's transformed into machine-readable instructions, making it difficult to revert to the original source code. To access the source code, you would need the uncompiled version or the developer's files, which may not be publicly available for templates like CapCut Reels due to copyright and proprietary reasons.   ... View more

I used data step to import with the following option, this resolved the issue with unwanted quotes I got for the last column. Hope this helps. Thanks.   TERMSTR= option—Specifies what end-of-line character to use for a file. This option is specific to ASCII operating systems and is documented in the SAS 9.2 companion for your operating system. This option is useful when you want to share data files that are created on one operating system with another operating system. For example, if you are working in a UNIX environment and you need to read a file that was created under Windows, use TERMSTR=CRLF. Similarly, if you are in a Windows environment and you need to read a file that was created under UNIX, use TERMSTR=LF. The following INFILE statement illustrates reading a MAC file from a PC: infile 'C:\mydata\test.dat' dsd dlm='|' termstr=cr; ... View more

/*用于加X轴Y轴标签的上下标*/ data _anno; length label $ 200; drawspace="layoutpercent"; function="text"; textweight="normal"; textsize=12;textcolor="black"; width=200; x1=50; y1=2.5;label="体重(*ESC*){sub 'mw'}"; output; x1=2.5; y1=50;rotate=90;label="身高(*ESC*){sup 'mw'}"; output; run; /*****画散点图*****/ proc sgplot data=sashelp.class sganno=_anno; scatter x=weight y=height; xaxis label=' '; yaxis label=' '; run;   ... View more

Hi: If you followed the setup instructions for Programming 1, when you expand the EPG194 folder (older name) or the EPG1V2 folder (newest name), then you should see a subfolder named output. If you right click on the output subfolder under your main class folder and in the popup menu on the right click, choose Properties, you should next see the Properties window which will contain the FULL path to the output subfolder. The libname could be: libname out "s:\workshop\EPG1V2\output"; or libname out "/home/<yourUserID>/EPG1V2/output"; or libname out "/home/<yourUserID>/EPG194/output"; or you may want to make an entirely NEW folder for your output under the class main folder. Let's say you do make a NEW folder under the EPG1V2 (or EPG194) class folder and you call the NEW folder mystuff, so when you want to write to the mystuff folder, your LIBNAME statement would change to something like: libname out "/home/<yourUserID>/EPG1V2/mystuff"; Using the right-click and Properties method will ALWAYS show you the correct folder path you need to use. Cynthia ... View more

@SanderB wrote: This answer is actually wrong because ANYHDTDTM will assume MM-DD-YYYY first over DD-MM-YYYY. If you give it 12-01-2023 it will read it as the 1st of December, but it should the 12th of January. This is not (entirely) correct. The ANY... informats will prefer DMY or MDY depending on the DATESTYLE system option (which has a default setting of LOCALE, which means the current locale setting also influences the date order). ... View more

Great thanks for the solution. It helps me also! ... View more

Works for me! Thanks! ... View more