Using libnames it should work as long as view's are supported. M8 is not necessary. ... View more

Libname is a reference to path . Therefore when wants to use the view the reference to that location or libname will have to be mentioned again. ... View more

Please try this modified version of the code Libname lib1 "/root/balbalba/reter"; DATA lib1.Central / VIEW= lib1.Central_v; SET lib1.Other_Table; SET lib1.Other_Table2 KEY = AGREEMENT_NUMBER / UNIQUE; IF _IORC_=%SYSRC(_DSENOM) THEN DO; _ERROR_ = 0; END; RUN; ... View more

In SAS SQL when no format is specified for a  variable length the format defaults to best8. This was causing anything beyond 8 characters to be truncated. Therefore the proper approach is to use format as rightly suggested by @PaigeMiller. ... View more

Applying sensitivity label may cause encryption or restrictions in the use of  excel files. You can try to access the file from SAS bytreating the file as a password protected file. This paper lists some approaches https://www.mwsug.org/proceedings/2013/FS/MWSUG-2013-FS04.pdf ... View more

Hello @leen . Reading this post along with your other post (https://communities.sas.com/t5/SAS-Programming/SAS-takes-so-long-to-initiate-print-even-very-small-dataset/m-p/905810#M357718 ) and the fact that you have used path="XE",  gives me the impression that you have PC SAS and Oracle express installed on your PC and that your SAS initialization and often running small tasks is slow. Under these circumstances creating a libname statement implies bring your entire Oracle table into SAS at the backend. That may cause the execution of the process to be slow. Rather than dwell on the mechanics of the process, I would recommend that you try SQL pass through as suggested by @SASKiwi  ... View more

Hello @erigal60  1.When you compressed the file using the command (x "gzip /abc/123/gdr/file1.sas7bdat";). a new file file1.sas7bdat.gz would be created at the location /abc/123/gdr and the orignal dataset file.sas7bdat would be deleted. 2. Subsequently you are creating the libref get  (libname get "/abc/carib/process/data";). This location does not contain the dataset fi1e1.sas7bdat.    This is the reason you see the error message (ERROR: FILE1 does not exist.) 3. The file needs to be  copied to the location pointed by your libref. You can use the code by @Reeza OR @yabwon  to perform this action.. ... View more

Hello In case you want to use only SAS then then the approach by @Tom is what one needs to follow. However in case you have access to bash shell, the large file can be split into a number of smaller  files having 10,000 lines each. The command would be as follows. Please do test it. split -l 10000 --numeric-suffixes input_filename output_prefix You will get out put  files with the name output_prefix01, output_prefix02..... The next step would be to write a code to read these files one file at a time. ... View more

Hello @Sarah-R  Please have a look at this http://support.sas.com/kb/24/487.html As@SASJedi suggested you may forward the log  output to an external file. ... View more

Hello This is a common question in SAS interviews. This is my solution. If there are duplicate values for the nth position, reports them. May not be the most elegant or efficient approach but it does works for the interview.   data s; input Id Price; datalines; 100 25 100 60 100 65 100 80 100 91 101 55 101 25 101 85 101 100 103 100 104 91 ; run; %Let N=2; PROC SQL; Select Id, Price from s s1 where (&N.-1)=(select count(Distinct Price) from s s2 where s2.Price> s1.Price); QUIT; ... View more

Hello @user34567  You want to insert the result set of the union all into the table UREN. Ensure that all the statements of the union all  return the same number of columns i.e, the column you want to insert. Sample insert statement is given below insert into Result_table (A,B) select A, B from Table1 union all select A, B from Table2 union all select A, B from Table3 ... View more

What does the log say? As a reminder we don't what your data is. ... View more

Hello @leen  In your first post you have mentioned "Hi, all. Each time I start SAS, it takes about a few minutes to initiate and it takes so long to even print a very small dataset (sometimes even 1 rows). " This indicates that either the laptop has insufficient resources OR the D drive is not physically installed in the laptop. It is customary in corporate environment to  mount a networked or shared drive at boot time with a drive letter. This gives the impression that it is a local drive. It also happens often that a user works on a remote machine/VDI and the desktop is essentially a window to access those resources. If there is a local IT support group / SAS Admin in your organization do approach them ... View more

Yes. After all you are executing a SAS code in STP. Proc transpose is outputing an error and it is quite possible that the source datasets are different. ... View more

Hello @leen  The large difference between real time and cpu time typically indicates an I/O issue. One possibility is that the D drive is not local to the machine that is running SAS i.e. it may be a remote or networked location. is your SAS running on your local PC or on the server. ... View more