Please, anyone, let me know the style or an example of using
'by='/'by' variable of a PDV(Program Data Vector)
Answer Posted / rajesh
list of 'by' variables tell SAS how data is stored in
source dataset or how it is to be represented in
output/output dataset.
PDV is used to write the observations in output dataset and
it does not get impected from any BY variable as data in
SAS always read sequencely. If BY vaialbes are there then
it just ensures that source dataset is sorted on list of BY
variables. It does not impact other thing.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
If you could design your ideal job, what would it look like?
Describe the function and untility of the most difficult SAS macro that you have written.
What are SAS/ACCESS and SAS/CONNECT?
Explain why double trailing @@ is used in input statement?
it will become easy if uuu provide website linkssss and list of consultanciessssss
How to create list output for cross-tabulations in proc freq?
what is sas metadata repository? : Sas-bi
how can you put a "trace" in your program? : Sas programming
please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??
I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.
how does sas handle missing values in sort order? : Sas programming
what is sas application server, database server, sas olap server and sas metadata server? : Sas-di
How can I remove header from output data set?
what are the best practices to process the large data sets in sas programming? : Sas-administrator
Approximately what date is represented by the SAS date value of 730?