cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Srigyan
‎02-08-2022
  • 130 Posts
  • 19 Likes Given
  • 2 Solutions
  • 0 Likes Received

Table creation by data

by Quartz | Level 8 in SAS Programming
‎10-26-2018 09:02 AM
‎10-26-2018 09:02 AM
I have a table   Product_ID starting Date price ID1 01-Jan-18 7 ID1 05-Jan-18 89 ID1 07-Jan-18 6   I want to write the code to generate below data point   Product_ID starting Date price ID1 01-Jan-18 7 ID1 02-Jan-18 7 ID1 03-Jan-18 7 ID1 04-Jan-18 7 ID1 05-Jan-18 89 ID1 06-Jan-18 89 ID1 07-Jan-18 6 ... View more

Re: Override values

by Quartz | Level 8 in SAS Programming
‎09-10-2018 12:44 PM
‎09-10-2018 12:44 PM
Instead to today I put     startingDate+15; do i= startingDate+1 to startingDate+15; range is coming for start_date from 1st Jan to 15-Jan is same. though it is correct for override data.   Product_ID startingDate price ID1 01-Jan-18 7 ID1 02-Jan-18 7 ID1 03-Jan-18 7 ID1 04-Jan-18 7 ID1 05-Jan-18 7 ID1 06-Jan-18 7 ID1 07-Jan-18 7 ID1 08-Jan-18 7 ID1 09-Jan-18 7 ID1 10-Jan-18 7 ID1 11-Jan-18 7 ID1 12-Jan-18 7 ID1 13-Jan-18 7 ID1 14-Jan-18 7 ID1 15-Jan-18 7 ID1 16-Jan-18 7 ID1 03-Jan-18 12 ID1 04-Jan-18 12 ID1 05-Jan-18 12 ID1 06-Jan-18 3 ID1 07-Jan-18 5 ID1 08-Jan-18 5 ID1 09-Jan-18 5 ID1 10-Jan-18 5 ID1 11-Jan-18 5 ID1 12-Jan-18 5 ID1 13-Jan-18 5 ID1 14-Jan-18 5 ID1 15-Jan-18 5 ID1 16-Jan-18 5 ID1 17-Jan-18 5 ID1 18-Jan-18 5 ID1 19-Jan-18 5 ID1 20-Jan-18 5 ID1 21-Jan-18 5 ID1 22-Jan-18 5 ID2 05-Jan-18 89 ID2 06-Jan-18 89 ID2 07-Jan-18 89 ID2 08-Jan-18 89 ID2 09-Jan-18 89 ID2 10-Jan-18 89 ID2 11-Jan-18 89 ID2 12-Jan-18 89 ID2 13-Jan-18 89 ID2 14-Jan-18 89 ID2 15-Jan-18 89 ID2 16-Jan-18 89 ID2 17-Jan-18 89 ID2 18-Jan-18 89 ID2 19-Jan-18 89 ID2 20-Jan-18 89 ID2 07-Jan-18 87 ID2 08-Jan-18 87 ID2 09-Jan-18 87 ID2 10-Jan-18 99 ID2 11-Jan-18 99 ID2 12-Jan-18 99 ID2 13-Jan-18 99 ID2 14-Jan-18 99 ID2 15-Jan-18 99 ID2 16-Jan-18 99 ID2 17-Jan-18 99 ID2 18-Jan-18 99 ID2 19-Jan-18 99 ID2 20-Jan-18 99 ID2 21-Jan-18 99 ID2 22-Jan-18 99 ID2 23-Jan-18 99 ID2 24-Jan-18 99 ID2 25-Jan-18 99 ID3 03-Jan-18 6 ID3 04-Jan-18 6 ID3 05-Jan-18 6 ID3 06-Jan-18 6 ID3 07-Jan-18 6 ID3 08-Jan-18 6 ID3 09-Jan-18 6 ID3 10-Jan-18 6 ID3 11-Jan-18 6 ID3 12-Jan-18 6 ID3 13-Jan-18 6 ID3 14-Jan-18 6 ID3 15-Jan-18 6 ID3 16-Jan-18 6 ID3 17-Jan-18 6 ID3 18-Jan-18 6 ID3 04-Jan-18 7 ID3 05-Jan-18 5 ID3 06-Jan-18 5 ID3 07-Jan-18 8 ID3 08-Jan-18 8 ID3 09-Jan-18 8 ID3 10-Jan-18 8 ID3 11-Jan-18 9 ID3 12-Jan-18 9 ID3 13-Jan-18 9 ID3 14-Jan-18 9 ID3 15-Jan-18 9 ID3 16-Jan-18 9 ID3 17-Jan-18 9 ID3 18-Jan-18 9 ID3 19-Jan-18 9 ID3 20-Jan-18 9 ID3 21-Jan-18 9 ID3 22-Jan-18 9 ID3 23-Jan-18 9 ID3 24-Jan-18 9 ID3 25-Jan-18 9 ID3 26-Jan-18 9 ... View more

Re: Override values

by Quartz | Level 8 in SAS Programming
‎09-10-2018 07:52 AM
‎09-10-2018 07:52 AM
the number of overrides are not confirmed, so this one does not fulfill the requirement.   ... View more

Re: Override values

by Quartz | Level 8 in SAS Programming
‎09-10-2018 07:16 AM
‎09-10-2018 07:16 AM
do i=1 to overidden-lst_date; from where you got overidden ... View more

Override values

by Quartz | Level 8 in SAS Programming
‎09-10-2018 04:50 AM
‎09-10-2018 04:50 AM
I have the price for 3 product where there is product start date. it means for ID1 from 01-Jan-18 price will be 7. Product_ID starting Date price ID1 01-Jan-18 7 ID2 05-Jan-18 89 ID3 03-Jan-18 6   I have another table which overrides the older price. it means for the ID1 price has changed as 12 from 03-Jan-2018 and again on 06-Jan-2018.   Product_ID Overridden date price ID1 03-Jan-18 12 ID1 06-Jan-18 3 ID1 07-Jan-18 5 ID2 07-Jan-18 87 ID2 10-Jan-18 99 ID3 04-Jan-18 7 ID3 05-Jan-18 5 ID3 07-Jan-18 8 ID3 11-Jan-18 9     the output table will be like following...   Product_ID Date price ID1 01-Jan-18 7 ID1 02-Jan-18 7 ID1 03-Jan-18 12 ID1 04-Jan-18 12 ID1 05-Jan-18 12 ID1 06-Jan-18 3 ID1 07-Jan-18 5 ID1 08-Jan-18 5 ID1 09-Jan-18 5 ID1 10-Jan-18 5 ID1 11-Jan-18 5 ID1 so on till today() 5 ID2 05-Jan-18 89 ID2 06-Jan-18 89 ID2 07-Jan-18 87 ID2 08-Jan-18 87 ID2 09-Jan-18 87 ID2 10-Jan-18 99 ID2 11-Jan-18 99 ID2 12-Jan-18 99 ID2 so on till today() 99 ID3 03-Jan-18 6 ID3 04-Jan-18 7 ID3 05-Jan-18 5 ID3 06-Jan-18 5 ID3 07-Jan-18 8 ID3 08-Jan-18 8 ID3 09-Jan-18 8 ID3 10-Jan-18 8 ID3 11-Jan-18 9 ID3 so on till today() 9 ID3 13-Jan-18 9     Please share the optimize code...  ... View more

Re: Number of records in for each dataset available in a metadata sas ...

by Quartz | Level 8 in SAS Programming
‎07-10-2018 08:47 AM
‎07-10-2018 08:47 AM
Value is (.)  for metadata tables. ... View more

Re: Number of records in for each dataset available in a metadata sas ...

by Quartz | Level 8 in SAS Programming
‎07-10-2018 08:40 AM
‎07-10-2018 08:40 AM
This is giving me a blank value.   memname nobs Table 1 . Table 2 . Table 3 . Table 4 . ... View more

proc forecast for group

by Quartz | Level 8 in SAS Forecasting and Econometrics
‎07-10-2018 08:33 AM
‎07-10-2018 08:33 AM
I want to run proc forecast on mentioned below data   Sr No Product Date Unit 1 P1 01-Jan-18 88 2 P1 02-Jan-18 82 3 P1 03-Jan-18 149 4 P1 04-Jan-18 151 5 P1 05-Jan-18 177 6 P1 06-Jan-18 307 7 P1 07-Jan-18 179 8 P1 08-Jan-18 148 9 P1 09-Jan-18 139 10 P1 10-Jan-18 105 11 P2 01-Jan-18 115 12 P2 02-Jan-18 75 13 P2 03-Jan-18 52 14 P2 04-Jan-18 128 15 P2 05-Jan-18 50 16 P2 06-Jan-18 61 17 P2 07-Jan-18 49 18 P2 08-Jan-18 42 19 P2 09-Jan-18 36 20 P2 10-Jan-18 89   As you see, there is two product and their date and unit is there, I want to forecast with proc forecast for next 5 days for both the product in the same table. The actual scenario we have more than 40K product so I want to know how can I forecast for next 5 days in the same table with smaller code. ... View more

Number of records in for each dataset available in a metadata sas libr...

by Quartz | Level 8 in SAS Programming
‎07-06-2018 07:03 AM
‎07-06-2018 07:03 AM
I am working with some of the tables which are basically somewhere in Oracle and SAS have the metadata library. If I want to check the number of records in all these tables in SAS. How can I do that? ... View more

Re: date frequency min value

by Quartz | Level 8 in SAS Programming
‎07-04-2018 05:11 AM
‎07-04-2018 05:11 AM
I reframed the question, Please check and respond.     ... View more

Re: date frequency min value

by Quartz | Level 8 in SAS Programming
‎07-03-2018 09:58 AM
‎07-03-2018 09:58 AM
my apology, I put the wrong table, modified it again. Please have a look. ... View more

date frequency min value

by Quartz | Level 8 in SAS Programming
‎07-03-2018 09:38 AM
‎07-03-2018 09:38 AM
I have mentioned below dataset in SAS.   Table-1   Sr No PRODUCT ON SALE DATE OFF SALE DATE SELL_PRICE 1 P1 01-Jan-18 03-Jan-18 84 2 P1 02-Jan-18 06-Jan-18 93 3 P1 04-Jan-18 10-Jan-18 46 4 P1 08-Jan-18 10-Jan-18 14 5 P1 01-Jan-18 01-Jan-18 15 6 P2 01-Jan-18 07-Jan-18 84 7 P2 03-Jan-18 04-Jan-18 93 8 P2 07-Jan-18 09-Jan-18 46 9 P2 04-Jan-18 08-Jan-18 14 10 P2 03-Jan-18 04-Jan-18 15   I have a product list(in this case P1 and P2) and there are many date range for the same product with the different price. The time range can overlap each other for the same product. My task is to make a dataset which contains a date range which will be the min of 'ON SALE DATE' and the max of ''OFF SALE DATE". so for the product, P1 date range will be 1-Jan-2018 to 10-Jan-2018. and for the product, P2 date range will be 01-Jan-2018 to 09-Jan-2018. and the price will come which will be minimum for that date. so the dataset will look like below one...   Table-2   Sr No PRODUCT Date SELL_PRICE 1 P1 01-Jan-18 15 2 P1 02-Jan-18 84 3 P1 03-Jan-18 84 4 P1 04-Jan-18 46 5 P1 05-Jan-18 46 6 P1 06-Jan-18 46 7 P1 07-Jan-18 46 8 P1 08-Jan-18 14 9 P1 09-Jan-18 14 10 P1 10-Jan-18 14 11 P2 01-Jan-18 84 12 P2 02-Jan-18 84 13 P2 03-Jan-18 15 14 P2 04-Jan-18 14 15 P2 05-Jan-18 14 16 P2 06-Jan-18 14 17 P2 07-Jan-18 14 18 P2 08-Jan-18 14 19 P2 09-Jan-18 46   so if you check the price for P1 on 1-Jan-2018, there are two prices mentioned for this first table-Row-1, the price for P1 is 84 First table-Row-Row-5 the price for P1 is 15.   hence the final price for P1 for 01-Jan-2018 will be 15 which is minimum between (84,15). check Table-2 and Row-1.   How to write a SAS code for this. ... View more

Re: Proc transpose

by Quartz | Level 8 in SAS Programming
‎06-01-2018 06:31 AM
‎06-01-2018 06:31 AM
It was a sample example and there are only two value columns (column3 and column4), my problem is I have multiple value column, by this example I have to transpose it so many times like that. Can we run any loop or something which can take all value column and run in the smaller piece of code? ... View more

Re: Proc transpose

by Quartz | Level 8 in SAS Programming
‎06-01-2018 06:30 AM
‎06-01-2018 06:30 AM
It was a sample example and there are only two value columns (column3 and column4), my problem is I have multiple value column, by this example I have to transpose it so many times like that. Can we run any loop or something which can take all value column and run in the smaller piece of code? ... View more

Proc transpose

by Quartz | Level 8 in SAS Programming
‎05-31-2018 11:52 AM
‎05-31-2018 11:52 AM
I have data in mentioned below format   Col-1 Col-2 Col-3 Col-4 product-1 LAI 1 25.00 product-1 LEX 2 17.50 product-2 LAI 1 9.00 product-2 LEX 1 25.00 product-3 LAI 1 16.20 product-3 LEX 1 199.00 product-4 LAI 1 30.00 product-4 LEX 4 88.00   my requirement is to see in the below-transposed format   Col-1 LAI_Col-3 LEX_Col-3 LAI_Col-4 LEX_Col-4 product-1 1 2 25 17.5 product-2 1 1 9 25 product-3 1 1 16.2 199 product-4 1 4 30 88     ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎02-08-2022 02:23 PM
Likes given to
Quick links