About cosmid

cosmid · ‎08-19-2021

The EG is only available on my Windows. Other users don't have access to it. They need access to this program in UNIX environment since that's where all the data resides. When they run the code. I need to prompt them to ask which section of the code they want to run otherwise everything will be executed and will take a long time for the code to complete. I just need them to enter like a number between 0-5 and it'll work.

cosmid · ‎08-19-2021

It's connected to the Windows SAS.

cosmid · ‎08-19-2021

Hi Koen! Yes, I just googled it and yet you still beat me to it.

cosmid · ‎08-19-2021

Ok, SAS Enterprise Guide. But it seems if I have it working in EG it will not work in UNIX since they are kind of different unless I missed something there too? lol Unfortunately, I need the code working for UNIX.

cosmid · ‎08-19-2021

What is EG? Thanks

cosmid · ‎08-19-2021

Hi Reeza, thank you for pointing that out. I didn't read the document carefully enough.Now I understand why it doesn't work in Windows. Right now I am just trying to figure out what I need to have the code working in UNIX.

cosmid · ‎08-19-2021

Wow, I didn't know there are so many options. I NEED to have this working in UNIX environment. It would be nice to know how it will work in Windows, but not as important. I do have SAS Enterprise Guide but I rarely use it as I am still 'newbie' in this field. Once I have time, I would like to investigate the difference between SAS Windows and SAS Enterprise Guide. At a glance, they seem to work similarly. I only heard that Enterprise Guide is more point and click.

cosmid · ‎08-19-2021

Hi, I have the following code: %macro test; %put Type in a name:; %input inName; %put The name you entered is &inName; %mend test; %test; When I run this code in Windows: Nothing happens, the two put statements are printed out in the log window. When I run this code in UNIX: I get two blank lines but it is waiting for an input. After type something, there will be another blank line and it takes me back to the command line. When I check the log file, the variable inName stores what I have typed in. Is there something wrong with my code or I am approaching it in the wrong direction? I just wanted to ask the user for input. Thanks

cosmid · ‎07-28-2021

Hi Becky, Thank you for your reply and the information. I appreciate it! I just wanted to know if the tasks are much more different than programming because from the course overview it seems it's more of managing type of work. Also, you said that practical work experience is recommended, so, for someone without any experience, is the e-Learning course sufficient to 'pass' the exam? Thanks

cosmid · ‎07-26-2021

Hi, I'm thinking about taking the SAS Platform Administration SAS 9.0 and Viya. Before I invest time on this, I just want to know: Is a lot of SAS programming experience/knowledge required in order to take the certification (and able to complete job tasks in the future)? I'm asking this because I just went through the SAS Administration: Getting Started. It doesn't seem to involve anything from SAS Base/Advanced. I wouldn't consider myself a good programmer, so I thought this might be a good career change (if I pass the cert and get a job that is). Also, would you recommend this certification? Thanks in advance!

cosmid · ‎07-06-2021

Hi, I tried the %include method. It saves all the output file into one single file. For example, if I created test.sas with %include statements, instead of the test.sh, and use the test.sas, all the print*.lst will be gone and they will be saved as test.lst instead. I need the output to be named after the original SAS programs. That's why I am using the test.sh. Of course, unless there's a way getting around this? I'm new to this so I could be wrong, hehe.

cosmid · ‎07-06-2021

Hi, I have a bunch of SAS programs and I wanted to run them once in a single program. I used print1.sas, print2.sas, and print3.sas as an example. They just print out a very simple data. I created a test.sh file: #!/usr/bin/sh sas print1.sas & sas print2.sas & sas print3.sas & I used the command: ksh test.sh It worked. I get a print1.log, print1.lst, print2.log, print2.lst, etc. Which is exactly what I needed. However, I keep getting the following warning message in 2 out of the 3 files: WARNING: Unable to copy SASUSER registry to WORK registry. Because of this, you will not see registry customizations during this session. My questions is: 1. SASUSER registry can only be used once? 2. Is this WARNING serious or its something harmless and can be ignored? 3. Is there something wrong with the test.sh file or what is the proper way of running a program like this? Thanks!

cosmid · ‎06-11-2021

Wow! I didn't know you can use a proc means like that! Really learned a lot, thank you! This works great for the sample data! Is there a way to keep other columns while increasing the value by 1? It seems the proc freq dropped other columns when I test it.

cosmid · ‎06-11-2021

I'm sorry. What I meant by increasing the value by 1 based on the max value, is to increase the value by 1 in the first row in each group and then for that group the value keeps getting increased by 1 from there on.

cosmid · ‎06-11-2021

If I have a data like this: data sample; input class x; datalines; 1 1 1 2 2 1 2 2 2 3 3 5 3 6 run; And I want the output to be: class x 1 3 1 4 2 4 2 5 2 6 3 7 3 8 I can get the max number from each class but I don't know how to proceed to the next step by increasing them by 1. proc sql; select max(x) into :max_val from sample group by class; quit;

%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: SAS %input not working?

Re: SAS %input not working?

Re: SAS %input not working?

Re: SAS %input not working?

Re: SAS %input not working?

Re: SAS %input not working?

Re: SAS %input not working?

SAS %input not working?

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

SAS Platform Administration SAS 9.0 and Viya Certification and job dut...

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

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: How to increase a columns value by 1 based on it's max value?

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