About cosmid

cosmid · ‎12-28-2022

Thanks again Koen!

sbxkoenk · ‎12-26-2022

Hello , I am glad you got it. 🙂 In SAS V9.4 , there are only 2 data types : character & numeric (dates are just formatted numeric values). ( In SAS VIYA , there are many more data types ... for CAS-tables ). This sentence of yours might be a bit confusing : The formats and informats are just there for how they are displayed and stored. I would rather say : The formats are just there for how they (the numbers) are displayed. The informats are just there for how they are read and stored (as a number). Cheers, Koen

SASKiwi · ‎12-25-2022

This is the error you get if you drop the dollar sign from the format: 35 proc print data=sashelp.class; 36 format sex sexfmt.; ERROR: You are trying to use the numeric format SEXFMT with the character variable Sex in data set SASHELP.CLASS. 37 run;

sbxkoenk · ‎05-13-2022

And ... forgive me for this reply as it is a little bit off-topic , but I want people reading this topic thread to know about : memoryFormat="DVR" (duplicate value reduction memory format) SAS Viya System Programming Guide Table Action Set: Syntax upload Action https://go.documentation.sas.com/doc/en/pgmsascdc/v_014/caspg/cas-table-upload.htm You can save a lot of ( in-memory ) space that way. Thanks, Koen

Ksharp · ‎04-29-2022

data have; input x $6.; length x $ 6; flag=ifn(notdigit(strip(x)),0,1); datalines; 12346 1a2b3c 1+abc abcde ; run;

cosmid · ‎04-08-2022

I have tried with RTF and PDF in the UNIX environment and it didn't work. It creates a file ending in .rtf and .pdf but once opened, they are just gibberish. Maybe I need to contact system admin for add-ons to open RTF or PDF files in UNIX? However, they both worked in SAS Windows. For me, the lst is sufficent and gets the job done. Thanks again, now I learned how to create RTF and PDF in SAS Windows. I'm sure this will come in handy when I need it.

LinusH · ‎02-10-2022

If you sign up for a 30 day free trial, you'll be able to run SAS Viya for Learners that way, I don't think an edu address is required. SAS Learning Subscription Free Trial | SAS

Mark2010 · ‎01-18-2022

Check the Extended Learning content associated with the eLearning. It will be listed in your "My Training" content. Under "Video Tutorials", you should see some content under "User-defined Formats in CAS."

Kurt_Bremser · ‎10-06-2021

The use of SUBSTR on the left side of an assignment is a feature of the data step compiler and not available anywhere else.

Sajid01 · ‎08-31-2021

Hello @cosmid For your question "Is a lot of SAS programming experience/knowledge required in order to take the certification " The answer is no. And for this part "and able to complete job tasks in the future" : One can survive with a minimal knowledge of programming. But good knowledge of programming will give an edge. As an administrator one comes across many service tickets/complaints saying that SAS is not working as expected or has degraded functionality whereas either its a clear programing error. If one has a knowledge programing then , can answer with confidence that it is a coding error.

ballardw · ‎08-19-2021

@cosmid wrote: Hi ballardw, thank you so much for that information! It explained the document better and gave me a better understanding. Tom posted the doc just a few mins before this one so I have accepted that as the solution. It would be nice if I can accept both. Thanks again for your help! No problem with who gets credit as long as you get a workable solution. I will say that it has been more than 20 years since the last time I actually used the %Window though.

SASKiwi · ‎07-06-2021

You could use PROC PRINTTO to direct SAS output to whatever file you want from within each program. If you want more fancy output, like HTML or PDF output rather than just text then controlling output with ODS is a better option.

Ksharp · ‎06-12-2021

data sample; input class x; datalines; 1 1 1 2 2 1 2 2 2 3 3 5 3 6 ; data sample; set sample; by class; if first.class then n=0; n+1; run; proc sql; create table want as select *,sum(n,max(x)) as want from sample group by class order by 1,2; quit;

SASKiwi · ‎06-09-2021

SAS Install Center is a good place to start.

cosmid · ‎06-09-2021

In SAS studio's output, they do start on a new page. But in UNIX, the result are glued to each other. So that's why I was trying to see if there's a way to fix it.

%lowcase vs lowcase

Re: Question regarding whether SAS resets values in the PDV

Question regarding whether SAS resets values in the PDV

How do I find the SAS catalogs for formats such as date9., comma8. etc...

Question on many to many merge

Is there a way to print the libname var in the log?

Re: How to replace a value from a column with the value of column from...

Re: How to replace a value from a column with the value of column from...

Re: How to replace a value from a column with the value of column from...

How to replace a value from a column with the value of column from ano...

Re: how to truncate table

How to concatenate values in SAS

Re: DO WHILE vs. DO UNTIL

Re: %lowcase vs lowcase

Re: %lowcase vs lowcase

Re: How to convert a formatted SAS date back to a SAS numeric date?

Re: How to output a macro result to a specified .lst file?

Re: I keep getting Correct the highlighted errors and try again

Re: Are _N_ and _ERROR variables available during BY-group prcoessing?

Re: SAS Base questions from 5th Edition Book

Re: Sample Question from SAS Website that I couldn't get it right

Re: How to convert a formatted SAS date back to a SAS numeric date?

Re: Reference character format names

Re: Listing and Removing duplicates with an indexed dataset

Re: Is there a way to check the values of a SAS char var that has numb...

Re: How to output a macro result to a specified .lst file?

Re: How do I start a SAS Viya session?

Re: Anyone took the SAS Viya Associate Certification Exam?

Re: Using substr in Proc SQL update

Re: SAS Platform Administration SAS 9.0 and Viya Certification and job...

Re: SAS %input not working?

Re: How to run multiple sas programs from one program?

Re: How to increase a columns value by 1 based on it's max value?

Re: Any good learning materials for SAS studio installation/configurat...

Re: How do you insert a blank line or a blank page for each macro resu...