SAS Clinical programming Tutorial | CDISC, SDTM & ADaM Training Full Course by JOYATRES TECHNOLOGY

SAS Clinical programming Tutorial  | CDISC, SDTM & ADaM Training Full Course by JOYATRES TECHNOLOGY

Show Video

okay yeah are you guys able to see my screen right no wait one second let me show you whatever hello yeah one second i am opening these sessions mirror better recording yeah previous class we discussed about the uh label option and along with the wear option uh where along with the uh how to we can uh filter out we can take the filter the particular that uh record from the uh datasets along with it how do we can apply the aggregation functions along with the where option okay uh then uh today we uh we are discussing about the one more option that is the password yeah everyone able to see my screen now yeah what's the difference then password option why we are using the password option uh see why we are using password in a sense if you are creating any dataset before no one can able to do modify the in the future needs here you can update the particular password if you apply any password to your particular data set which is created by you uh then no one can able to change that data set existing that is which is declared by you so if you want to create any one means uh that person has to after this password which you enter the password right to the dataset that password only that person has to be uh while reading the uh while doing any modification to the that existing data set so now we are now i'm going to discuss about the password option so what is the syntax for this password like data and data set name here here it will come data and inside parents see how to use password so i'm going to use the entire password key just to install that you can use shortcut is equal to how to mention uh your name i mean let me say your password then run so this is the syntax about the password so and you can give character whatever you want okay this is the syntax so just i'm going to do the tactical how we can be able to do this password how do we can update this password to the particular dataset so this is the our first environment so today i am going to create the one more uh normal dataset so that that is a damage dataset only just for understanding purpose i am going to begin uh using now data then i'm just i'm giving the b that is my database and we have to use input statement here so while reading the variables in there so for the reading the variables only we can use input statement and i'm giving name it's a character variable one for any kind of variable you have to enter the dollar symbol and uh i'm giving just a h that is a numeric no need to use anything here and i'm giving the gender uh also character variable so that we can enhance the dollar now we can use the character data lengths so all these are whatever we can be able to see now in our blue color so those we call as the statements so cause so insult the gods we can mention like names damage and age is 12 and his gender is me and ramu and [Music] this data so i don't want to give print i mean i don't want to see uh results in output window so i'm not giving any i'm not specifying any any prop step here uh so just i'm reading the data only now just click on the submit button here so just to go and check in log whether this data set has been read or not yeah this read this data center has been read has successfully and uh this data set b the name is id that is a stored data work library and it's showing like you say this data set having a four observation along with the three variables so uh the data set has been b the name is b uh it's created successfully just i'm going to apply the password [Music] full name of password just to give you the shortcut link that is the pdw that means the password [Music] and my password is you can mention anywhere any name you can you this password so simply i'm leaving now just uh run it now so just to go and check in log if you get any other anything error warnings all the information we need to know about this data in log window only uh so this password has been applied to the data set which data structure i have created be that effect only so the the information will be same now before applying the password to the specific data set uh after applying the password after that that's it the information will become the same but the thing is see now i'm going to print this particular data set in my output i want to see this all uh results in output window so that just i'm giving the prostate now so instead the top step we can use the print so how to give data and i'm giving you the data segment which my data system is b right i'm using b and just run it see we can able to read this particular we can able to see this output in output we know order we can see now [Music] see the read access denied so the messaging is the start spot uh we are getting the one message that pop up here so what is which the read has access denial entered the password for the our this meaning of this message is we can't able to read this particular b data set because the user the existing user has appeared the one password over to the data set this particular data set so that if you want to read if you want to change anything uh we have to update the password here so what is my password my password is a tiger right t i g e r tiger so just click on okay so before giving the correct password just i'm giving the uh incorrect password say let's see whether we can able to see the results in output window or not we can see and after tiger this time specifying the uh one more uh alphabet that's the a it's a tiger after the tj so if you click on the okay then it will read or not we can see so we can't be able to see this output in output in the right still we are in editor window only just go ahead checking it out see what is the log uh telling invalid are missing read password on member wordpress b data that means we are giving the we are specified the invalid data invariant password onto the particular dataset so that only we can't able to reach this particular output in output window so that now i am going to do one thing again i am going to submit this uh two buttons that change the line see now again it's asking password okay now i'm going to specify the proper output i mean proper password okay just click see we are getting the output right so in data even in real time scenarios also if you anyone want if you want to restrict if you want a productive data set if you are that means although no one can able to read or no one can be able to uh change your data into the further level or further person i am in other persons also so that you can update the password so if you update any password any data set uh the template anyone want to do something on that particular password dataset that person has to enter particular password which is entered by the previous user so this is about the password see i am giving some notes about password by using password password option we can protect or if anyone wants three or more this option here that means he uh he mentioned the one password for that data set so that if anyone wants to we uh i mean so [Music] see uh first thing you want to do any modification on the existing data set before that we can't we can able to read the data the data set then only we can able to do changes if you can't able to read itself you can't do anything am i correct so this is about the password option so as of now we have uh completed the uh this data set options okay uh and one more topic here today we are going to discuss about crosstalk options right in a previous class earlier also i have explained like uh options we have the multiple of options like data set options that i'm sorry that step options and system options uh and again that is step options we have these three categories like available control options and observation control options and one more thing data set options and here now we are discussing about the proc step options so what is the use of prop ship options here means so as of now we see we saw some system options and observation control options and available control options i know uh and data set options so all these options are uh these system options will work like your big global options any data options in the car uh it uh these options so the data set options only work for the data step level only and and we also have some variable control and observation control options and those options also works only for the uh specific wearable control options keep rename and drop so that these three options only work for the variables and observations options also we have some of the options so these options only work for the observation level so now we are going to discuss about the clock step options in this case these options will work only prostate this option would work in the inside the data step this options only work for the prostate so that's why we can call as a prostate options okay and just i'm giving you some mores regarding these these options only work for rockstar but for others so what are the top step options means we have the different kinds of different types of options here one is the title and second one is footnote and third one is [Music] for just one second i will come within two minutes [Applause] so yeah hi guys and back to the session yeah so these are the positive options and the like titles don't no no obvious and double so these four options only talk step options and majorly we are using in real time also in different scenarios and this for only we have we can use only proc stable not we can't be able to use the enter the data step and data step on it so with this call with the proxy functions so before going to explainable this title footnote no obvious double so what is the meaning of title and what is the meaning of footnote so uh for example just i'm going to open the volume what document and i will explain about the footnote and what is the title before going just let me open the work what document yeah this is about word document right so okay instead of word document this time i will open for the powerpoint so it will be clear for you so so see uh if you open any session of the overfile automatically the page will show like it's like this one click to add title and click to add subtitle okay so uh what is uh tells about uh title 2 also means this title uh and this party we can tell about the uh what is the content of and what is the subject of this document so that we are giving you some title names right uh for example uh if you i'm going to programming for the diabetic dataset basically some criterias so that just i'm using the diabetics so for example i'm i'm doing some thesis you know everyone doing this some theses we take i mean study levels right so if you giving any content you you are writing anything over here before that you are giving your title name of your content and of your project whatever may be so here we are giving the title in that in that manner only so committing this session also we are applying the title to our particular program okay uh in real time scenarios also and whatever yeah we have the plenty of lines of the programming part like a hundred thousand whatever many likes so while reading that entire uh programming we can't able to uh find out which one is which one is which one uh this line uh relating to the uh which one this i mean for example just i'm giving this data set so i don't know about this data set i mean which is relating for the any demographic data or any diabetic data we don't know right so so that i'm just applying the uh in my clock step line i'm just i'm applying my title name of this data set so in output also once you will give the print and in output you can able to know uh this output belongs to the demographic and this output belongs to the diabetes and this output belongs to the a domain like that only so so that is the use of the title and so uh let me uh before going to the programming part just i will show you one more thing here you go and check the output so we have the previous output here right so which i printed now so by default we are seeing the one title here in this output right this what is the title here the search system so the default will if you print any number of data sets if you print the default directory it will come like i said this has system only so this is our default title in sas output if you want to change this uh if you want to apply even one title over here means we can use the title options that is called the top step options where we can use that option inside the prostate so i am going to do now so before that i just i am giving the syntax of title and just i'm giving a few bytes here by default uh we can see title of the output is the entire system if you want so if you want [Music] a plate you know user specified yeah here is the username means ourselves programmers we can encourage the users okay make use of specified id if you want to specify any title from urine then by using the time we have to use so that we can use this option [Music] and one more important thing here how many titles we can able to give to the specified datasets so the maximum number of titles cl is in sas we have to specify only 10 titles at a time you're more than 10 we can't able to do that only we have this case we have a specific limited element here that is a 10 only max okay then i'm going to give syntax here the syntax like uh so what i said so these are the top step options so that we can use the we said the prop step only we can't be able to use dataset right so this time using proxy here and give a data set data and after that you can give this a here that's the name of the excuse semicolon and run so this is normally we are giving the proc step right so instead of rock step and instead of run in between we have to give note id so where we can apply the title option so in between the run statement and prop statement in between you how to specific type so title and after that you have to write your name right i mean like your title name right so so titan name it's a character right so that whatever you are mentioning the any character uh message or character variable or what i mean character observation so everything whatever if it comes like it's a character or it comes like the test so that information your house to mention in between the single quotes or a double quotes then only source will can be able to read that is a character okay you can give like title one title two so this is my title one so what i said we have to give up to like 10 maximum titles we can able to apply up to 10 only so where we can be able to use so now i am applying for title group that is means my second id so like this we can give up to like the number of titles like 10 syntax about this title option uh if you don't want if you want to give only one title uh just here give title and you have to give uh information that one no need to mention the title one title looks like this is just for i mean just for a better understanding but personally i'm giving this numbering here one two three four five like up to 10 uh so no need to give that memory if you want you can give if you don't want you can't you can ignore it okay just for the better understanding purpose for me i'm not mentioning that memory here okay see now i'm going to see uh same concept with sas environment okay so what i said uh this title we cannot play in between the drop and run so i'm using same see if you give any spelling mistake also like so this is not a correct uh spell for title so automatically it will show like it's a red color so that you can you can came to know so we did some mistake here or what is the mistake here i added spelling mistake so that after that you have to mention what i said you have to mention anything anymore is inside the single port officer semicolon so so as of now we are seeing like this sas system that is the title if you run create any other two or three data sets you can enable if you run those datasets automatically the output will show you like this a system this is a default only so i'm going to change the default thing in output that's our system okay and then sas program so such programming only my title okay so it going to replace the search programming title it's going to replace the sas the default one what is the default the this thing has system so uh before that just i'm uh giving i i will use the sas uh i mean the system option like all i want i'm going to page breaking the output then only uh we can compare the previous output and correct one okay at least i'm giving the options and what is one form dll yeah as of now i'm just read this option line only okay okay so now i'm going to print this see at the time of explaining the about the password uh if you want to read one more time third time and fourth time question a number of times every time you how to specify the password for that particular ad set again i am reading this i again i'm reading i'm again i'm printing this b data set only so already i'm applying the password option uh for this data set so again now again i'm using same data set for the training purpose so that again it's asking the password so what is my password here i get it i get my password okay start popping this time typing here just click on the ok button see the same output is coming now there is no changes here the four observations and four variables only here previous one and uh compared to connect current one only so this is the previous one and this is the current one only so what i did know just i'm changing the my title of the my output i mentioned like sas programming this is my title of my output right so start programming so previously we have this system that is the default title so i'm compressing i mean i'm changing that modifying the default type by using the my specified that means uh that user specified title one this is a sas programming uh yeah everyone able to see in route everyone able to see my screen hello are you guys there yeah hello yeah is it clear both of you yes yeah previously we have the sas system that is a default id now we are the uh we are replacing that we are changing that our default thing which is sas programming so this is how we can do the programming so how we we can be able to use uh this title option in real time means see for example i have the here like just you can assume like this think about this this is for the uh i mean diabetic patient related information okay so if i mention here diabetic patient related information or diabetic if any if you are if you want to give diabetic life so that time it will come like either that output is a diabetic one so the time you can able to know this output relating for the diabetic okay for example we have the multiple data sets like this uh this is the one data set like we have to take our confined access maybe you can just like assume that okay yeah so uh by the time you have to print those that 10 data at a time so that you can uh yeah sorry everything here okay so that time you have to paint those platters at a time so if you print those data sets at a time means uh while checking while validating your output uh so you may you you may be a bit confused right this output already belongs to the which uh data set and this output belongs to which data we can't able to understand so here we have these just four observations and four variables so that we can able to know uh this output for glass to this data set and this output will have to restart but in coming to the radiator we have the many observations and many uh uh too many of the observations available so that time we can we can't able to know which the output is the black three which data set so that for that but personally we have to maintain the title if you mention the title it will come back if it is a diabetic means if you mention the diabetes it will show which will show like diabetic the title name is showing as a diabetic so that time you give uh you only understand better thing mentally you can able to understand so this output belongs to the diabetic so that is why we are using the title option in real time okay and one more thing yeah this is about the title so any dose about this about this title option no yeah okay then fine okay so this uh this is about the title so next one next thing is a footnote uh footnote is instance um what is the foot that is a bottom foot nothing but the bottom right in normal language we can treat like it's a bottom food so here what is the food node means uh we can get the some information we can use some information uh head of the output at the bottom of the output here if you want to mention any information so as of now i gave here end of the title like it will appear like that information that name the titan name will appear uh like head of the output right head of the output means so this is the output so uh this is the head i mean uh this before that output only we are seeing the title name right so the what is our footnote means bottom is here you can apply footnote means some information for better understanding purpose in real time if you use the title along with the footnote it will be good so now we can able to see how we can able to apply the footnote before that is just if we see the go through the notes yeah about the footnote yeah footnote i see your footnote always appears the bottom of the page by using this option we can assign our own footprint for our data set uh we use attempt 10 footnotes for each datasets so this is actually uh this is my own preparation so yeah okay okay okay what i explained right here the footnote will appear at the bottom of the output appear bottom of the output yeah bottom of the output on the bottom of the output is at the bottom of the page but above the page or bottom of the order both are same only so we can use our phrasal verbs so for this also we have the limit so at a time we can give max number is 10. then only we can able to use more than that we can't able to okay and what is the syntax this is a syntax output this if i'm copying here so so this is also crosstalk options so that we can use the insert the clock step we can't able to use the insert the data stick okay so this is just interactive the footer what is the give what i mentioned in the syntax data after that you have to mention the datasheet name here you have to specify the dataset name and then after you know how to use the footnote so so footnotes i mean here also we are giving some information about the data dataset right so that is also nothing but a character due to this text so that we how to specify the quotations so then after you have the run statement that means uh the program has been the data step has been ending at that step at that line so then on this house you can able to understand your programming your data step reading and printing has been completed the run is nothing but the ending if it tells about ending adding of your program so i am going to pay now so again i am taking the same yeah same it here also uh what my dad's name here just again i'm printing the same data which is the b1 only dataset name of v dataset only and again i am going to print it with the footwork now b and footnote then football i have to mention the single quotation inside information we have to mention some information okay so my information is started what is the meaning of start time means see already and uh ran this same data i'm printing same that is b dataset twice until now so i'm going to print now again third time so i want to know i just i want to remembering my uh this footnote i mean the same data how many times i am regarding so this is my requirement okay so that i'm mentioning my footnote start time okay third time it will come like it will appear bottom of the output it's like a third time that means uh until that we are printing the same that is a statement so that i'm giving started instead of that you can even give your you know any name okay in the case of footnote okay just i'm going to run now so already i told you two types now again i am explaining about one more thing so if you are printing this same data set b directory automatically again if you laugh about the password because already i have updated the password here so let's see uh just click on the submit button here or else you can use the f3 button in your system see again it's asking password right my password is a tiger just click on the ok button yeah so this is the bottom of the page part about the output mix so here my output bottom here only okay so we are seeing red thought time so this is the output okay this is our output and bottom i said bottom of the output or bottom of the page right so this is my or if you assume like it's a page this window it's like a page and it is a bottom third time okay now what i'm going to do now i want to use both i mean i mean i want to use these two things like title and footnote attack how we can use the academies uh just we can use the uh before footnote or offload we can view the title name here okay my title i'm going to mention my title my titan name is diabetic [Music] so what is the diabetic means my data set title name is diabetic so i so that means this information i am treating this information it's like a diabetic phase information this dataset information is like a diabetic only so just i'm giving diabetic again i'm just i'm changing the start time uh why because again you will find if you say whether you will get the output or not we can't say that uh just you can you see fourth uh just i'm giving the fourth time about this just again i'm going to run the same data set which i created earlier and again it will ask the password just click on the submit button here again we lost because already i have updated the password for the same one so click on it okay so we are not getting the auto drive we are not getting the output check now oh no something needs to happen but there is no error for this that is immediately uh be diabetic kind of four to ten marketing for b1 also and i'm going to just run a statement so i'm going to play now b1 okay again [Music] yeah something happened actually so earlier i explained that the our question is sometimes we'll get the problem like this so that so there is no error in our programming programming or lines but still you are not getting the output before rename this uh data set name so in real time also if you getting any kind of this this kind of any issues means just you can rename the data set name so that may that means uh this house will retreat like if it's a new data set okay so so you see the diabetic is that my take my data title is a diabetic and again i have mentioned the footnote here what is my footnote is the fourth time that means the same method i'm running myself with the fourth time four times it has been ran the same landscape okay this is about the title and footnote okay and what is next one no obs what is the meaning of no obs no obviously it's nothing but obviously it means it's our observations no being smith no ob no no observation that means i don't want observations where so before that actually uh where we uh where this uh obvious information appearing whether it is locked or either it's output so there is no yeah so right now we are uh [Music] no obvious also yeah no obviously also it's just rock step option that means all this for title footnote no bsn double all these four we are using the output purpose of it so that why because output for cutters means we are using these four options inside the prop step that means why we are where we are using the proc type which we are using this proc step only for the printing purpose that means only for the output purpose so as of now i'm changing this output only like i am giving the id this appearing output only i am giving the footnotes only it's appearing in the uh output only right so we are controlling the output now by using the transcript options so where we are seeing this obvious information means we see here so in the obs see here also the default thing it will come uh how many data set if you have the 10 data sets also you'll be running those 10 axis at a time also one by one also you will get the obvious observation information here observation information is how many observations are available inside the data set inside the data here we have the four observations the numbering only it's giving now one two three four like is the sequence number you can obviously make this a sequence number one two three four okay i don't if you i don't want this obvious information in my output i want i don't want to see this number numbering in my output so that if we can update the no obvious option so where we can apply the no obvious that that is the meaning of thing obviously no obvious injection in the sense we are removing the obs the numbering obvious obvious information in the output so that we can apply the no obvious option so that so it is a top step option right so that we have to use along inside the clock strip only because yeah no obvious just we are removing [Music] three options these three options only work in output level only got it yeah we have syntax for this what is the syntax for the image yeah based on copying this one instead of writing again removing this one i'm interesting so there's no obvious option we have to mention the top pin data is equal to data setting after the data set normally we have to specify the obvious okay previously we have mentioned at this line previously we mentioned here fourth node are uh title in between prop plane and run in between so we have this here colon and here also here also that means uh this line is sending this step to this line ended up at this line at this moment so that if you mention colon mix so this is a separate line and this is the separate mean this is the separate line so that we are measuring the so sas will be like everything we have the three lines okay so that now we are eventually uh after the data set now only how to message in obvious just uh we'll see in practically you go to just our output window uh just i'm going to come and surprise i'm i'm going to remove the observation information for the b1 data set in output window so that or what i said just uh yeah how to do cropping data set name after that is it normally how to machine obvious options just using space as one space and you have to mention you know obvious if anything goes to wrong if you in the spelling mistake are the way of calling that particular option here that means we expert syntax we have to give this mobius hero itself only instead of it at this place if you give here this no obs see automatically showing latency in red color that means uh we are not using this option in correct way am i correct we are not doing this this option is correctly so it's a incorrect one if you run this out if you run this step also you will get the uh error in log builder okay if it comes in no blue color everything you are you know you are applying that option correctly so this is advantage in sas so again i am running this now again it will lost password or not it will allow password again now our password is a tiger the tiger okay the fourth time my because four uh the same footnote i used here for this uh this time also so same diabetic only i've used it in my title also same i didn't change the title and footnote but i used no obs option here so that we are not getting the obvious information right here so previously this is my current output and previously see we have this output obs one two three for this information we are removing gpr subtracting this uh obvious selection from the output by using the obvious so this is about the output yeah clear anyone is getting uh available any doubts about these three options yeah okay fine yeah okay so here one more thing you guys are observing one more thing so before that just yeah just wait uh just i mean i'm going to commenting now this title and footnote just you guys observe one thing okay uh just i i'm going i'm going to run this uh same v1 dataset with no obvious option just i'm commenting this tight step and footnote step okay just click on the submit button now again so again it will last password yes it will ask you password i am entering it i can see now so same output is coming now there is no difference right no difference guys if if you observe any difference please let me know now it will be clear are you getting my point or not yeah are you getting my point or not so i'm running yeah yeah i'm cleaning the same or yes same data same the step only again but now i didn't mention that i am not considering this title and footwork lines i am not including this two step of lines in my program just i'm excluding this uh two states from my program just i'm using no obs only but the same i'm getting the same output or not i'm saying output why i am getting c more put in the sense i just have used it this time only no obvious option so that it removes this obvious information that's fine but the thing is again we are getting the the title the name is diabetic and footnote the fourth the same information we are getting at our title now in the footnote why we are getting the title and footnote here again right just i excluded already here just i commented means these two lines i am excluding from my program but even it's coming why it's coming means this title and footnote option also it will work like as a global options if you update a title or boot node once for any data set okay if you're creating one more data set if you're running that data so same or titanium name will it will appear in to the particular data set also for example i'm going to just uh your understanding purpose i am going to create one more data set here that means that the queue and my input inside input you are mentioning the variables names and i'm going to mention the variable names here yeah location it's a character now i'm going to ending with the dollar symbol and uh yeah pin code for example superintendent this course is [Music] this is my fireball ping pong this is not but just like also okay i'm taking two observation variables along with three observations so again i'm going to give cockpit i want to see this data set or results in output vector so that i'm using the and following the prop print i mean proc step inside the top step i'm using print statement so just run it so just observe a few points here okay i'm going to submit this uh up to this selected which i am selecting now only i'm selecting this uh data set only so it will go going to run if you're selecting one any specific lines and the specified length means here from 20 32 i'm selecting 30 this 10 lines only i'm selecting now i'm going to run this segment by uh by using the starting button if you run this thing uh you will get the output only for this up blast to the this data set only okay that here now it's not asking password so until if you run this v1 same on dataset it will uh it's asking the password but it's not asking for this time why because this password option only works only i just i updated only for this data only for this uh data set only not for the order it won't work for the all works it's coming in the title name sorry footnote that is the footprint the fourth time find the diabetic is coming that is a title but this time your output having this uh contains this obvious information like it's having the three observations one two three and two variables these are always information we were getting but why we are getting the diabetic and that means uh titan name and footnote name why because so these two title and footnote these two things it will work like this global options that means it will work the entire star station if you close this session and if you open it reopens a new transition that time it won't work okay until that it will keep on updating your outputs but it it won't be good right in real time so why because this data only belongs to the diabetic but this data is not belong to the diabetic but even though we are getting the same uh titan name on the same footprint to the this output also so it may confuse right so it may confuse that so definitely it uh it will goes to the confused okay so that we are whichever we are applying the title footnote so i have played this title footage so my work is done up to this data set so i don't want the same title and footprint to here or i don't want the title of footnote also okay my work is done up to here only so that we are compressing we you revoke this title footnote which you appeared the earlier so how we can able to revoke this title footnote means so just you have to mention the same here title so title footnote both are the top step options so that you have to eventually insert the props step only so after that title you have to specify the single quotes so inside the single course no need to specify anything same way footnote so specify the single force no don't specify anything inside the quotation if you specify anything inside the quotations means uh the text will come like as if a title and footnote okay but now what i'm going to do now i am revoked i am revoking these two options i don't want to do this title unfortunately for the future that uh my future outpost so that i am revoking now okay i am going to run now again so see i'll as if i'm not re-working for the no obvious option so no obs option only work for you for this v1 data set only not to didn't work for the queue data set so so that's why we are getting the data set right i mean now obviously information we are getting to this output right so that means it's like it's a global option so if you wherever specified wherever to where you will appear which update to the option to the obs to the data set it will work only for the particular data set only but the title footprint is not like that if you apply any data set to title of photo it will work like the same title name same uh footprint uh text will it will come to the future outputs also so that it it won't be good so i'm going to revoke the title and footnote now i don't want the title of put on now just already i'm reading this few data no i am printing this only now just click on semicolon just to go and see the log any other so there is no error but yeah there is fine only so uh just an entire thing once yeah we are getting the output see i'm not getting anything here even i'm not i'm not getting the default table also so nothing here coming right uh here came like i say some yeah one code symbol is coming right why it's coming did i mention anything here just let one give one space here so first yeah now it's nothing coming okay the default thing is also nothing coming so previously what i did no i didn't give any space in between the uh this force okay it's not coming it's not coming it's not so that means i am remove these two options okay if you're going forward for example q1 is there and q1 is there just like as a q1 uh just removing these two things just uh how do we can explore just the commented one and run this one again see we are not getting the which we update the title and footnote now okay this is how we can do it okay so in real time how we can uh obtain the title footnote and how we can able to uh revoke this title of footnote in the sense see like this we cannot able to do so i'm just uncommenting just i'm including these two things now again so i took either already i told right up to we can able to give like up to ten that is at a time so i'm giving second title here is what is my second title i am telling two sauce once you able to or read this data set with the diabetes title after that i am revoking this title option so same way copy and it will really itself after that i'm telling to search it's revoking i mean i don't want to do the foreign future it's the same pattern the same footnote okay i'm going to run now again your last password now is like there is a password just click on the okay button yeah it's not coming right so it's not correct actually it has to come one time has to come so i'm going to run an entire thing [Music] yeah so one time it's coming the sas program is came and what happened okay uh something uh yeah again we need to okay let's run okay you know so this is how we can be able to use the title and footnote once you update the title just uh reworking in this way and if you want software tightly you can revoke in this way or else you can do in this way also okay yeah you can give any details it will be good okay it will be a good understanding for it okay that means we are applying diabetic here applying the fourth day again you come to here and we working with two things so if you want uh after that if you run any another data set it won't come it's not coming so this is just uh uh we go through the notes once uh before going to the one more topic so already expert number footer always appears on bottom of the page by using this option we can assign our own footnote for our data set we use attendance and footnote for each data set okay for each statistic that means this is one data set okay this is the q one is the one dataset for q1 dataset i can use up to uh from one to ten times in the same way we can i can update the 10 footnotes to the same data set from footnote one two four number two so the same information i mentioned here in this notes also so this is how we are given so here i mentioned like my footnote is here please call me i use it for footnote like you just please call me so the end of the output the end of the page uh the text will come back you say please call me so for example in exams if you connect if you attend any 10 exams or whatever so before that question mark the bottom of the question mark uh they will give you like the congrats uh i mean uh all the best layer so that kind of text will come like right the bottom of the question paper so yeah like like that if we can create here also so also we are using the no obvious option here by using this option we can surprise or we can remove the observation values that means this observation info we are removing by using this obvious options so where we can use you know obvious uh along with the top step we can use no obvious options okay and one more option our final option is the double option what is the mean of the double here so what is the meaning of the w intercepts by using the double option we can insert the null rows so so for example i will explain you here itself uh so we don't have any space in between this uh any space we don't know how either from we don't have the any space or any gap in between the each observation right in output so that if you want to insert any gap or any null in between the observation so that we can able to use the double option so so before going to the programming just uh we go through the nodes once by using the double option we can insert this out so how we can use this double option so that is the purpose of double option so null row or gap so both are the same only so if you want to get the any gap or null row in between the observation that means uh i will explain you in excel once one time but what is the garbage makes the sheet yeah so for example so this is the name is like a variable and maybe through the observations right so here so there is no gap right for example i'm telling there is no gap in between the observation in between row two row and you know record by recording there is no in between record with there is no gap so if you want to get inside the any gap that means so i want some empty row here in between in between low pass and if i want empty so in generally we can insert in this way in excel just which i'm explaining here what the concept of the double after that i will show you in programming so so i have inserted right in between i want to say gap so that means we can able to see the this output in very clearly so yeah wait again i'm going to insert one more thing here yeah so robust and so we are seeing these outputs it's a very clear manner so how the same way the how we can generate that gap in between the observations in output so for that we are using the double option okay so what is the syntax so this is the syntax affordable just a property this is also double option here okay this is the boost syntax just i'm calling meaning i'm going to copy this syntax part alone yeah this is a portable you clear it up to the syntax spot this is clear right the purpose of the w and what is the double meaning the meaning of the table and the syntax of the double is clear right yeah okay follow us so now we are going to see the programming part now how we can do the double so as of now there is no nothing right i think nothing happens so no there is no gap in between the observation in output so now i'm generating the gap or a gap in between the observation that we can call is a gap or null row so in sas terminology we can like it we can call it is a null row okay so as per syntax i am going to mention the uh inside the property because it's the prop in the block step options only so cockpit data after that your data setting after the data set memory you have to specify the double option [Applause] see we are generating some gaps in between the observations like one two three so we have the hydroponic diameter in between we have the null project has been the generator right so previously it's like you see very near each observation having the near when you are observing it for it's not good luck actually now if you mention this option you know for reading well for seeing also it's a good manner so that we can use the development okay we can we can't that's your they will ask how you can generate the gap and how can you can generate the null row in between the double option so we have the uh other methods also is there for generating the null row in between the observations so as of now i mentioned uh i explained about the only one method that is a double option only so going forward i will explain the uh few more methods to generating numbers so for here it's for only for this double option here as a for here itself it's only using for the pending purpose for the output purpose so going forward the methods i will explain you how to use those methods and what is the purpose of those i mean where we can apply these methods to generating the gaps in between the observations yeah okay uh this is about the top step options so what is the top step option we have these are the top step options so this is about the today class yeah these options only work for the blackstrap these are the title footnote nodes doubles so this four so this ultimately these four options will uh use along with the talkstar phone and that means we can use the only inside the clockpin only but remember about these two things uh football title the two things will work like easy global options if you want say you copy any carrier to footnote after that you have to surprise your how to remove those names otherwise it will come those names to the future uh that outputs also it will keep on the same it will repeat the same name same title same footnote it will come in the capone it will come the uh today uh feature order sets i mean a feature that sets out if you want the title footnote to same uh these two options you want to require to the upcoming data sets also you have to change the title how to change if you rs you can revoke the way i i have explained it the same way you can use the in real-time data also in real time projects also the same way so so whatever options whatever things i am explaining right so the man of calling the manner of your rework giving me those options how i am using here now the same way how to use the in real time also okay this is about the club now today's class okay then bye

2022-01-31 14:38

Show Video

Other news