Check out the complete guide to SAS Macros: - ua-cam.com/video/i4hu1b9r_Qw/v-deo.html Check out the complete guide to PROC SQL:- ua-cam.com/video/kVoAf3Jzz0Y/v-deo.html Check out the complete guide to SAS Learning for Beginners: - ua-cam.com/video/zX-zPfwv6c8/v-deo.html
Hi Sir Pls reply me! This Type Question was asked in my Practice. My doubt is Since in Origin Asia Europe etc type were there so it is very simple to split & Execute. But What if Observation in Origin are having Blank or Space in Between them like "Asia N" "Europe S" "USA +" etc. Since in above video lines numbers are there pls tell me what to change in which line number.... Pls..
Hi.. your videos are very good.. Its my kind request, could you please take a detailed class on Proc Report and Proc Tabulate.. Once again.. your classes are so easy to learn and very much interesting.. Thanks a lot.
Thanks for liking this video. Your question is quite subjective in nature. I would recommend you to specific to your requirement e.g. whether do you want to combine those tables dynamically or it's just one time requirement. If you want to make it dynamic, please put your example in detail over here and we will guide you achieve what you want
Hi Abhishek, Please refer to the below link for better explanation on this: support.sas.com/resources/papers/proceedings/proceedings/sugi22/ADVTUTOR/PAPER44.PDF
Hello 👋 Thank you so much for your comprehensive videos. I have been looking for videos on how to match cases with controls in a case control study by 2 or 3 variables. Is it possible to provide some guidance through a video in this area. I have been reading a sas document and they say it begins with splitting a dataset. I will very much appreciate it. Thanks
Thanks for watching this.. if you can explain your problem statement with some example that will be easy to understand for me and I'll be able to provide you a specific solution
HI.. this video is very helpful!!!. can you please explain the how we can export the large data(last one year data) set into multiple excel files dynamically by month
U r vedious are best. Can we find duplicates by useing combination of both proc freq and if statements? If s how to send duplicates to one data set and non duplicates to one data set?
Hi Vishal, I'm not sure what you actually mean by loading the data from server however I'll show you the examples how to load the data from teradata or denodo loading the data from teradata proc sql; connect to teradata as odbc(UID=your_user_id PWD=your_assword SERVER=server_name); create table testing as select * from connection to odbc (select column1 ,column2 ,column3 from teradatadb.teradatata_tablename ); disconnect from odbc; quit; loading data from denodo proc sql; connect to odbc(DATASRC="server_name" user=your_user_id pass=your_password); create table testing as select * from connection to odbc (select column1 ,column2 ,column3 from denododb.denodo_tablename ); disconnect from odbc quit;
Hi Sir Pls reply me! This Type Question was asked in my Practice. My doubt is Since in Origin Asia Europe etc type were there so it is very simple to split & Execute. But What if Observation in Origin are having Blank or Space in Between them like "Asia N" "Europe S" "USA +" etc. Since in above video lines numbers are there pls tell me what to change in which line number.... Pls..
before starting with the solution shown in the video, my recommendation is to remove the space from the values, e.g. data you_want; set you_have; origin_new = compress(origin); run; once this is done, try using the solution provided on "you_want" dataset.
Check out the complete guide to SAS Macros: - ua-cam.com/video/i4hu1b9r_Qw/v-deo.html
Check out the complete guide to PROC SQL:- ua-cam.com/video/kVoAf3Jzz0Y/v-deo.html
Check out the complete guide to SAS Learning for Beginners: - ua-cam.com/video/zX-zPfwv6c8/v-deo.html
Hi Sir Pls reply me! This Type Question was asked in my Practice. My doubt is Since in Origin Asia Europe etc type were there so it is very simple to split & Execute. But What if Observation in Origin are having Blank or Space in Between them like "Asia N" "Europe S" "USA +" etc.
Since in above video lines numbers are there pls tell me what to change in which line number.... Pls..
sir your videos are best source of knowledge...
please make video on ....
what topics to be *must learn* in *base sas* & *Advance sas*
Hi Manoj,
Here is the link for a whole playlist for SAS Base + Advance -
ua-cam.com/play/PL4GjoPPG4VqPRFh5PwCXwT0q1d6dERj4E.html
Hi.. your videos are very good..
Its my kind request, could you please take a detailed class on Proc Report and Proc Tabulate..
Once again.. your classes are so easy to learn and very much interesting.. Thanks a lot.
Hi Deepak,
Thanks for following the channel, Sure we will make that video as soon as we get time
Thanks, great vid!! One question: how would you join the 3 tables that you found at the end?
Thanks for liking this video.
Your question is quite subjective in nature. I would recommend you to specific to your requirement e.g. whether do you want to combine those tables dynamically or it's just one time requirement.
If you want to make it dynamic, please put your example in detail over here and we will guide you achieve what you want
Sir inner join in SQL and merge are giving different number of obs , how is that happening ??
put your both of the syntax here and let me have a look
Sir, why do we need to use double & in data &&origin?
Hi Abhishek,
Please refer to the below link for better explanation on this:
support.sas.com/resources/papers/proceedings/proceedings/sugi22/ADVTUTOR/PAPER44.PDF
Go more vidios about Sas you are good
Hello 👋
Thank you so much for your comprehensive videos. I have been looking for videos on how to match cases with controls in a case control study by 2 or 3 variables. Is it possible to provide some guidance through a video in this area. I have been reading a sas document and they say it begins with splitting a dataset. I will very much appreciate it. Thanks
Thanks for watching this..
if you can explain your problem statement with some example that will be easy to understand for me and I'll be able to provide you a specific solution
HI.. this video is very helpful!!!. can you please explain the how we can export the large data(last one year data) set into multiple excel files dynamically by month
Thanks for watching this, we will try to make a separate video for your requirement
@@learnerea Thanks
Hi Sunil,
You can check out the video-
ua-cam.com/video/bbMMWnnRfo0/v-deo.html
U r vedious are best. Can we find duplicates by useing combination of both proc freq and if statements? If s how to send duplicates to one data set and non duplicates to one data set?
The best option is to use the proc sort, use the below link to watch the same:
ua-cam.com/video/0zxAr2oD1co/v-deo.html
Could you please make video on subqueries in SQL...and questions and Answers on sas interview questions...
Sure will try to do that as soon as we get time, thanks for following the channel
how to upload server data into sas invirement
Hi Vishal,
I'm not sure what you actually mean by loading the data from server however I'll show you the examples how to load the data from teradata or denodo
loading the data from teradata
proc sql;
connect to teradata as odbc(UID=your_user_id PWD=your_assword SERVER=server_name);
create table testing as
select * from connection to odbc
(select column1
,column2
,column3
from teradatadb.teradatata_tablename
);
disconnect from odbc;
quit;
loading data from denodo
proc sql;
connect to odbc(DATASRC="server_name" user=your_user_id pass=your_password);
create table testing as
select * from connection to odbc
(select column1
,column2
,column3
from denododb.denodo_tablename
);
disconnect from odbc
quit;
Take a class on trail design models
as soon as possible
Why && ( double ampersand )
You may like to read this
support.sas.com/resources/papers/proceedings/proceedings/sugi22/ADVTUTOR/PAPER44.PDF
With out using macros how can we do that?
sorry for the disappointment, that doesn't seem to be feasible...
happy to see a solution coming from you, if you get the one
Hi Sir Pls reply me! This Type Question was asked in my Practice. My doubt is Since in Origin Asia Europe etc type were there so it is very simple to split & Execute. But What if Observation in Origin are having Blank or Space in Between them like "Asia N" "Europe S" "USA +" etc.
Since in above video lines numbers are there pls tell me what to change in which line number.... Pls..
before starting with the solution shown in the video, my recommendation is to remove the space from the values, e.g.
data you_want;
set you_have;
origin_new = compress(origin);
run;
once this is done, try using the solution provided on "you_want" dataset.
My new dataset is splitting in different datasets of different name size
Like my variable has not unique name but there are space in between them
Anyone please