good job

May I have the sample dataset please

Hhhhf🎲🚞🚝🇨🇮👨‍💻🏪🥉

terrible video

thank you for creating this vidoe really helpful as a beginer to have a basic understanding of sas!

Thanks fro video , Please do the statics video bit clarity

Data Files have been deleted

I am having issues with the pathing - under the PROC IMPORT, datafile= “C:\Users\shaworth2\Documents\tabdelim.txt”; keeps adding a = to the end in the log and says it can be read. Any advice?

hey, while conversion csv to sas7bdat. can i specify data types or change data types?

Why do you have to turn ODS graphics off after running graphing statements? When is it necessary to turn ODS graphics on prior to these statements? Thanks!

Too fast without proper explanation 😔

You didn't explain key value extraction

Good day Ivy. IYou lecture is interesting to beginners like me. Unfortunately, I tried to upload excel data using the code you provided but kept receiving the following error message: OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 68 69 PROC IMPORT OUT= pgtrial; ERROR: FILE= or TABLE= is required and must be specified. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 184.18k OS Memory 20896.00k Timestamp 11/15/2023 12:35:37 PM Step Count 71 Switch Count 0 Page Faults 0 Page Reclaims 16 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 70 DATAFILE="C:\Users\hp\Documents\11SAS PRACT\pgtrial.xlsx"; 71 DBMS=EXCEL REPLACE; 72 GETNAMES=YES; /* put yes if the first row is the headers*/ 73 MIXED= YES; 74 USEDATE= YES; 75 SCANTIME= YES; 76 RANGE="Sheet1"; 77 RUN; 78 79 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 89 what could be the problem? This is the code I entered: PROC IMPORT OUT= pgtrial; DATAFILE="C:\Users\hp\Documents\11SAS PRACT\pgtrial.xlsx"; DBMS=EXCEL REPLACE; GETNAMES=YES; /* put yes if the first row is the headers*/ MIXED= YES; USEDATE= YES; SCANTIME= YES; RANGE="Sheet1"; RUN;

Your videos are very useful even though it is 2023, almost 2024.... ¡Thanks from México!

can i get a sas files

Hi, I'm a beginner in VBA and learning to automate mundane daily/weekly/monthly tasks. I would like to automate our monthly stock take processes. I have divided all tasks into blocks to address each issue separately. I have successfully automated three/four blocks. The next two/three blocks are way more advanced than I can handle. I see part of the solutions in the script you Demo'd in the video. Can you possibly assist? I have a sheet that contains source data. The source data( only certain cells from all the rows) should be split evenly into X(variable based on available staff that can count) amount of new workbooks. Each created workbook will contain a section of the source data that a staff member will use to count stock inventory using tablets. The data is captured and entered into specific cells, until all items are counted. Once that sheet is completed and saved it should automatically create a PDF copy with date time stamp. The source data should now retrieve the count applicable to each product code from the workbooks that was originally created. There are duplicate product codes and therefore should match specific criteria before the count is used. Once the data is entered into the source data it will immediately indicate if the stock balances, is short or extra stock. If there is a variance, then all rows that contain a variance, should be copied and place in the sheet "Variance Recount 1". It is quite a process, but I believe 95% of the tasks can be automated. Can you indicate if you can give advice/guidance? Regards

I found your lessons very simple and easy to follow! Thank you for doing this.

Hi How can I put 2 or more words in the same variable cell? Thx

Hello Kieng Iv, The practice data in the dropbox has been deleted, I need the data to follow along with your teaching.

Thanks for sharing the knowledge, Please how can I this software

fish sticks or fish d****?

Hello, I have a question. How can I get fields related to mandatory data?

So grateful for your video🥰. Its made my work so easy. I used to take hours cause my knowledge was limited by now data analysis would take up an hour or less. Thank you.

"Our clients are not sophisticated in analytics and the language we use.......... these people are from our parents generation" . Terrible way to frame up any group of people. Very surprise that Deloitte allowed this to be posted

the software suitable for area banking?

The time has come for me to finally learn SAS X) Thank you

Great Work!!!

Kindly assist the Link for the Data is not working

Great lessons, thank you. Kindly assist the link to DropBox is not working

How to get working files

Why is your last name pronounced "i, v"

i need to change the legend dynamically. any idea?

Hi can you help me with moving shapes using the mouse. I’d like to grab a shape move it to another cell and drop it there. Thanks

Sakiru Oyeyemi is interested

powerful... not powerful hahhaah that was a nice one

Doe anyone know where we can download this software, they claim it came with the book but I got the electronic copy of the book and did not receive a CD

I LOVE YOU ROMULO

I LOVE YOU ROMULO ❤

I LOVE YOU ROMULO ❤

Can u please provide input files , so that i can practice along with you?

How do I match positive and corresponding negative numbers in a column in acl

THANK YOU FIRST! I got an error says that procedure SGPLOT not found

The presentation and delivery was superb...thank you fot this. Please i await for your advance level series

God how boring these people sound. Made me sleepy

if move coordinations points faster on chart curve ?!

Can you send me new version for SAS application for downloud

Any chance you still have the data laying around?

Hi, I conducted a three-factorial [ pH (2 levels), salt(3 levels), and iron (3 levels) in a completely randomized design conducted with 3 replications. I want to do an ortogonal test on the second and third levels of iron at the first levels of pH and salt in SAS. However, I get the message NOTE: CONTRAST one is not estimable. Could you please tell me where I am making mistake? Data factorial; input ph salt iron rep yield; cards; 1 1 1 1 3.5 1 1 1 2 3.8 1 1 1 3 3.4 1 1 2 1 4.1 1 1 2 2 4.3 1 1 2 3 4.5 1 1 3 1 4.6 1 1 3 2 4.8 1 1 3 3 4.9 1 2 1 1 3.1 1 2 1 2 3.2 1 2 1 3 3 1 2 2 1 3.4 1 2 2 2 3.5 1 2 2 3 3.3 1 2 3 1 3.5 1 2 3 2 3.8 1 2 3 3 4 1 3 1 1 3 1 3 1 2 2.98 1 3 1 3 2.8 1 3 2 1 3.1 1 3 2 2 3.5 1 3 2 3 3.2 1 3 3 1 3.6 1 3 3 2 4.1 1 3 3 3 3.4 2 1 1 1 3.2 2 1 1 2 3.4 2 1 1 3 3.1 2 1 2 1 4.1 2 1 2 2 4 2 1 2 3 4.2 2 1 3 1 4.3 2 1 3 2 4.5 2 1 3 3 4.3 2 2 1 1 2.98 2 2 1 2 2.8 2 2 1 3 2.7 2 2 2 1 3.2 2 2 2 2 3.1 2 2 2 3 3.3 2 2 3 1 3 2 2 3 2 3.4 2 2 3 3 3.6 2 3 1 1 2.65 2 3 1 2 2.75 2 3 1 3 2.5 2 3 2 1 3 2 3 2 2 2.98 2 3 2 3 2.95 2 3 3 1 3.2 2 3 3 2 3.5 2 3 3 3 3.1 ; proc glm; class ph salt iron rep; model yield=ph salt iron ph*salt ph*iron salt*iron ph*salt*iron/ss3; contrast 'one' iron 0 1 -1 ph*salt*iron 0 1 -1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0/e; run;

Obsolete

Thank you