Hi, I have data of sale for month quarter and year. My requirement is to compare sale year on year basis for year month and quarter. Kindly refer to attached image where i have shown the required graphs. But in that attachment i have shown 3 graphs but i need to provide all these details in 1 graph only. I tried hierarchy , group,lattice column and row but none worked exactly with the requirement.   Bar chart or line chart both are fine , only requirement is to provide all the details in 1 chart. ... View more

Hello friends,   We have created geo bubble map of a city . Now requirement is to "print out" that city geo map with bubble in 3 feet * 4 feet page , but in the screenshot all bubbles are getting too close . If we are doing the zoom in , we are getting the clarity but screenshot can't accommodate full city . And if we zoom out clarity is not there.  Please suggest how can we get the huge "print out" with clarity.   Thank u!!! ... View more

I have created 1 aggregated measure , i want to create category with value less than 0 as bad and greater than 1 as good ... View more

I have 2 jobs A and B in SAS DI . I want to create a new job and put A and B job in parallel. But as i am dragging A and B , SAS DI automatically linking both jobs with a line and it seems like B will only run after completion of A. Please let me know how can i run 2 jobs in parallel in SAS DI.   Thanks ... View more

If I have a population data of 10,000 observation and I want to perform linear regression, then still I need to take sample or I can perform it on full population? If we can process full population then why we take sample? ... View more

Where i can learn credit risk modelling in bank? Paid training of SAS is out of budget for me. Could anyone pls let me know pdf or videos link ? Thanks ... View more

I have 1 time in excel file it's value is 27:27.36  i.e. 27 min 27 sec 36 subsec What informat need to be used to read this value. I need informat so that i can read this value. I used time10.2 and few other informat but it is not working.   Thanks in advance ... View more

Hi iam trying to import 1 xlsx file in SAS studio and there is only 1 sheet 'sheet1'.   Iam using below code:-   proc import datafile='/home/prakashnegi0/test.xlsx' out=test dbms=excel replace; getnames=yes; run;   In dbms i tried Excel,xls,excelcs,csv .. but none are working.   Can any one tell me the correct option here.   Thanks ... View more

There are 2 datasets, names and partners. In partners , id is given but we need to find corresponding names using "names" dataset data names; input st_id st_names $; datalines; 1 John 2 Mark 3 Steve 4 Smith 5 Cook 6 Messi 7 Mary 8 Kris 9 Kevin ; run; data partners; input st_id1 st_id2 st_id3; datalines; 1 4 7 2 5 8 ; run; I need to add 3 columns in dataset partners name_id1,name_id2,name_id3 . To get names from dataset "names" as per id , i think we need to join dataset 3 times. What if datasets has million of records, is there any way we can simply the joins? ... View more