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: 
Swapnasis
‎04-23-2024
  • 8 Posts
  • 1 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: can someone help write a SAS proc Sql orSAS data step to get the l...

by Calcite | Level 5 in SAS Programming
‎04-22-2024 11:45 PM
‎04-22-2024 11:45 PM
can this logic be written in proc sql, so that I can use the logic to pull data from database? ... View more

Re: can someone help write a SAS proc Sql orSAS data step to get the l...

by Calcite | Level 5 in SAS Programming
‎04-22-2024 11:39 PM
‎04-22-2024 11:39 PM
Thanks ksharp.Appreciate it ... View more

can someone help write a SAS proc Sql orSAS data step to get the last ...

by Calcite | Level 5 in SAS Programming
‎04-22-2024 08:38 PM
‎04-22-2024 08:38 PM
  Input ID Date Parameter 1 1_feb-2024 - 1 28-feb-2024 x 1 10-mar-2024 - 1 20-Mar-2024 x 1 31-mar-2024 - 1 01-apr-2024 x 2 1-feb-2024 x 2 28-feb-2024 - 2 10-mar-2024 - 2 20-Mar-2024 - 2 31-mar-2024 x 2 10-apr-2024 x 2 30-apr-2024 - Output--Last populated value of the parameter prior to the month end. So if I run my code as of Feb-2024 month end, the output should be ID Date Parameter 1 28-feb-2024 x 2 28-feb-2024 x So if I run my code as of Mar-2024 month end, the output should be ID Date Parameter 1 31_mar-2024 x 2 31-mar-2024 x So if I run my code as of Apr-2024 month end, the output should be ID Date Parameter 1 1-Apr-2024 x 2 30-apr-2024 x I tried the below, but it only gives me the last row, without considering month data output; update input(obs=0) input; by ID; data output; update input(obs=0) input; by ID; run; ... View more

EXPORT in sas

by Calcite | Level 5 in SAS Enterprise Guide
‎08-30-2016 12:29 PM
‎08-30-2016 12:29 PM
Can u exoprt a data set without header in SAS EG?.If So,How? ... View more

Re: Quarters and Periods

by Calcite | Level 5 in SAS Procedures
‎08-16-2016 02:09 PM
‎08-16-2016 02:09 PM
Below is the attachment of the input data.U have write a code to produce a dataset which looks llike my previous image ... View more

Re: Quarters and Periods

by Calcite | Level 5 in SAS Procedures
‎08-16-2016 02:02 PM
‎08-16-2016 02:02 PM
To me only the dataset with variable A is populated.I have been told that start date is 31-Dec-2015 and end date is 31-dec2020. I have to create a dates coloumn such that all the 21 quarters are populated in a manner as shown in the image file.along with that i have to create a period coloumn as  shown in the image ... View more

Re: Quarters and Periods

by Calcite | Level 5 in SAS Procedures
‎08-16-2016 01:50 PM
‎08-16-2016 01:50 PM
the Variable A can carry any value(not specific to what I have shown in the image).but the total no.of rows will be in mutiples of 21. What I exactly want is if the variable A is given in the input dataset.create the two varibles dates and period as given in the image file ##- Please type your reply above this line. Simple formatting, no attachments. -## ... View more

Quarters and Periods

by Calcite | Level 5 in SAS Procedures
‎08-15-2016 03:14 PM
‎08-15-2016 03:14 PM
For this dataset only variable A is populated ,I want to create 2 variables date and periods as shown in the excel.The code should be such that once i specify the start date and end date,it should generate all the quarters and their corresponding period starting from zero.In this dataset variable A has 42 values,so if i specify start date as 31-dec-2015 and end date as 31-dec-2020,it should generate all the inbetween quarters as shown in image and also their corresponding quartes.it should also repeat iti.e if Variable A has 42 values it should repeat it twice(42/21) ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎04-23-2024 01:19 AM
Likes given to
View All
Quick links