If a var is defined as char,   length x $6.; How do I check the values of this var that has numbers only?   Example, if x has 12346 1a2b3c 1+abc   How do I find numeric values such as 12346? Or is there a way to look for values that's alphabets? special chars?   Thanks! ... View more

For example,   If I have a program with two macros that print out month report and the other for quarter report: %macro printmonth(mon);   print statements here; %mend printmonth;   %macro printqtr(qtr);   print statements here; %mend printqtr;   %printmonth(Jan); %printmonth(Feb);   %printqtr(qtr1);   How do I create two different .lst files and name them as monthly.lst and quarter.lst? Currently, this program will create a single .lst file with the same name as the program.   Thanks!     ... View more

Hi,   I got the following error message when I tried to practice SAS Viya in SAS Studio:   My code: /*Start a session named mySession using the existing CAS server connection.*/ cas MySession sessopts=(caslib=casuser locale="en_US");   ERROR: The request to start or connect to a session failed. Specify a UUID to connect to an existing session or specify a session name, port, and host name to start a sesseion.   My question is, what session name, host, and port I can use for practice purposes? Are cashost=cloud.example.com and casport=5570 available to everyone to use, and free? The existing CAS server connection written in the comment from the snippet, what is it?       Thanks ... View more

Hi,   If you have taken the exam, I just wanted to know if there's going to be any questions related to User-defined formats in CAS on the exam. The Exam Guide said the following will be on the exam:   • Location where formats are stored within CAS • Saving formats to caslibs with the CASFMTLIB= option • Save formats to and retrieve from permanent SASHDAT files with a CAS statement • Assigning formats to in-memory tables   I had the e-Learning course and it did not cover any of the above. Did SAS forgot to update their Exam Guide or they intentionally leave out stuff in their Prep Guides? Anyone know any good place to learn User-defined formats in CAS?   Thanks    ... View more

Hi,   How do I use a substr in a Proc Sql Update?   For example,    data test;   input x $; datalines; abc bbc ccc run; data test; set test; substr(x,1,1) = 't'; run; This will give me: tbc tbc tcc I tried using the substr in a PROC SQL Update but it won't work: proc sql; update test set substr(x,1,1) = 't'; quit; 1. How do I use the substr function in a Proc SQL Update. 2. Is it okay to use the same dataset in a set statement, like the dataset test in the above example.   Thanks! ... View more