There are multiple concepts involved in 'union all corr'. 1) UNION is a set operation in sql - that is to combine rows from more than one dataset (or sql query) 2) With UNION, only the unique rows from both the datasets will be kept in the final dataset 3) ALL keyword forces all the rows from both the dataset to be kept in the final dataset when compared to only unique rows without the ALL keyword 4) Set operations are performed based on column position in proc sql instead of variable names - this means, the first column from first dataset and first column from second dataset gets appended irrespective of the names of those variables. 5) CORR is used force the appending based on column names instead of position. Hope this helps! I will try to create a video explaining this in details.
For example, if we have used a width of 30 for a column in the report define statement, and there are more than 30 characters in that variable, proc report by defaults prints only 30 characters in the output. If we want those additional characters to be printed on the next line, we need to use flow option.
Hi Kishore, it is a known issue - on some of the older videos, the audio was low. Please try to manage with a headset in a low background noise area. Will try to reupload this with audio corrected or redo this videos sometime later.
Nice to explain thanks
you are welcome
What is cmnt1 option ??
How the commented lines are generated ?
Can you pls guide ?
it's a keyboard macro...
you can find the details here..
ua-cam.com/video/VkMIZJnnn-A/v-deo.html
@@mycsgThank you for reply 😊Will check.
But one more doubt how to do %include steps and links ( which means a path where the file is stored)
Because I tried but errors are shown.
can you please share additional details like the error message...
Hi could you do TFL programming on laboratory analysis data. Pls
Hi Sravnathi, please expect in next couple of weeks.
what is meaning of 82 line union all corr
There are multiple concepts involved in 'union all corr'.
1) UNION is a set operation in sql - that is to combine rows from more than one dataset (or sql query)
2) With UNION, only the unique rows from both the datasets will be kept in the final dataset
3) ALL keyword forces all the rows from both the dataset to be kept in the final dataset when compared to only unique rows without the ALL keyword
4) Set operations are performed based on column position in proc sql instead of variable names - this means, the first column from first dataset and first column from second dataset gets appended irrespective of the names of those variables.
5) CORR is used force the appending based on column names instead of position.
Hope this helps! I will try to create a video explaining this in details.
Hii bro flow option equal to split haa bro
For example, if we have used a width of 30 for a column in the report define statement, and there are more than 30 characters in that variable, proc report by defaults prints only 30 characters in the output. If we want those additional characters to be printed on the next line, we need to use flow option.
Tq so much bro
voice is very low bro i m not getting
Hi Kishore, it is a known issue - on some of the older videos, the audio was low. Please try to manage with a headset in a low background noise area. Will try to reupload this with audio corrected or redo this videos sometime later.