On 11/22/11, mc 100404894 Saima Sarwar <mc100404894@vu.edu.pk> wrote:
> please share me cs504 assignment plz koi send kar dey na..
>
> On Tue, Nov 22, 2011 at 5:32 PM, Ghulam Mustafa
> <mc100401687@vu.edu.pk>wrote:
>
>> Are you sure this is right solution???????????????????
>>
>> On Mon, Nov 21, 2011 at 9:50 PM, Rubab Rana <mc100403939@vu.edu.pk> wrote:
>>
>>>
>>>
>>> *Write SQL code to create the following tables.*
>>>
>>> * Solution:*
>>>
>>> CREATE TABLE PERM.JOIN7 AS
>>>
>>> SELECT FACT_TBL*,
>>>
>>> PAT_TBL.PAT_NAME, PAT_TBL.PAT_SEX,
>>>
>>> DATE_TBL.MONTHYR, DATE_TBL.DATETEXT,
>>>
>>> DATE_TBL.QUARTRYR, DATE_TBL.YEAR,
>>>
>>> LOC_TBL.LOCNAME, LOC_TBL.OWNER,
>>>
>>> PROV_TBL.NAME <http://prov_tbl.name/>, PROV_TBL.TYPE,
>>>
>>> DIAG_TBL.DESCRIPT, DIAG_TBL.SUBGROUP, DIAG_TBL.GROUP,
>>>
>>> PROC_TBL.DESCRIPT, PROC_TBL.SUBGROUP, PROC_TBL.GROUP,
>>>
>>> SERV_TBL.NAME <http://serv_tbl.name/>, SERV_TBL.AFFLIAT,
>>>
>>> FROM
>>>
>>> PERM.FACT_TBL, PERM.PAT_TBL,
>>>
>>> PERM.DATE_TBL, PERM.LOC_TBL,
>>>
>>> PERM.PROV_TBL, PERM.DIAG_TBL,
>>>
>>> PERM.PROV_TBL, PERM.SERV_TBL,
>>>
>>> WHERE
>>>
>>> FACT_TBL.PATIENT=PAT_TBL.PATIENT AND
>>>
>>> FACT_TBL.DATESERV =DATE_TBL.DATESERV AND
>>>
>>> FACT_TBL.LOCATION =LOC_TBL.LOCATION AND
>>>
>>> FACT_TBL.ADJUSTMENT=PROV_TBL.ADJUSTMENT AND
>>>
>>> FACT_TBL.DIAGNOS1.DIAGNOS2 =DIAG_TBL.DIAGNOS1.DIAGNOS2 AND
>>>
>>> FACT_TBL.PROCEDURE AND
>>>
>>> FACT_TBL.SERVEMD = SERV_TBL.AFFLIATE AND; RUN;
>>>
>>> PROC SUMMARY DATA = Perm.JOIN7;
>>>
>>> Class Patient Quartryr Location;
>>>
>>> VAR Charges Adjust;
>>>
>>> OUTPUT OUT=Perm.Sum7;
>>>
>>> RUN;
>>>
>>>
>>> (here is solution for part1, but not sure it is correct or not, becoz
>>> its just my own idea.)
>>>
>>> --
>>> We say, "Be one as Pakistani Nation and grow up for Pakistan's Future".
>>> Wish you all the best. Join www.vuaskari.com,
>>> To post to this group, send email to vuaskari_com@googlegroups.com
>>> Visit these groups:
>>> This (Main) Group:http://groups.google.com/group/vuaskari_com?hl=en?hl=en
>>> MIT/MCS Group: http://groups.google.com/group/vu_askarimit?hl=en?hl=en
>>> HRM Group: http://groups.google.com/group/askari_hrm?hl=en?hl=en
>>> Banking Group: http://groups.google.com/group/askari_banking?hl=en?hl=en
>>> Management: https://groups.google.com/group/vuaskari_mgt?hl=en
>>> Marketing: https://groups.google.com/group/vuaskari_mkt?hl=en
>>> MIS Group: http://groups.google.com/group/askari_mis?hl=en
>>>
>>
>> --
>> We say, "Be one as Pakistani Nation and grow up for Pakistan's Future".
>> Wish you all the best. Join www.vuaskari.com,
>> To post to this group, send email to vuaskari_com@googlegroups.com
>> Visit these groups:
>> This (Main) Group:http://groups.google.com/group/vuaskari_com?hl=en?hl=en
>> MIT/MCS Group: http://groups.google.com/group/vu_askarimit?hl=en?hl=en
>> HRM Group: http://groups.google.com/group/askari_hrm?hl=en?hl=en
>> Banking Group: http://groups.google.com/group/askari_banking?hl=en?hl=en
>> Management: https://groups.google.com/group/vuaskari_mgt?hl=en
>> Marketing: https://groups.google.com/group/vuaskari_mkt?hl=en
>> MIS Group: http://groups.google.com/group/askari_mis?hl=en
>>
>
> --
> We say, "Be one as Pakistani Nation and grow up for Pakistan's Future". Wish
> you all the best. Join www.vuaskari.com,
> To post to this group, send email to vuaskari_com@googlegroups.com
> Visit these groups:
> This (Main) Group:http://groups.google.com/group/vuaskari_com?hl=en?hl=en
> MIT/MCS Group: http://groups.google.com/group/vu_askarimit?hl=en?hl=en
> HRM Group: http://groups.google.com/group/askari_hrm?hl=en?hl=en
> Banking Group: http://groups.google.com/group/askari_banking?hl=en?hl=en
> Management: https://groups.google.com/group/vuaskari_mgt?hl=en
> Marketing: https://groups.google.com/group/vuaskari_mkt?hl=en
> MIS Group: http://groups.google.com/group/askari_mis?hl=en
>
> please share me cs504 assignment plz koi send kar dey na..
>
> On Tue, Nov 22, 2011 at 5:32 PM, Ghulam Mustafa
> <mc100401687@vu.edu.pk>wrote:
>
>> Are you sure this is right solution???????????????????
>>
>> On Mon, Nov 21, 2011 at 9:50 PM, Rubab Rana <mc100403939@vu.edu.pk> wrote:
>>
>>>
>>>
>>> *Write SQL code to create the following tables.*
>>>
>>> * Solution:*
>>>
>>> CREATE TABLE PERM.JOIN7 AS
>>>
>>> SELECT FACT_TBL*,
>>>
>>> PAT_TBL.PAT_NAME, PAT_TBL.PAT_SEX,
>>>
>>> DATE_TBL.MONTHYR, DATE_TBL.DATETEXT,
>>>
>>> DATE_TBL.QUARTRYR, DATE_TBL.YEAR,
>>>
>>> LOC_TBL.LOCNAME, LOC_TBL.OWNER,
>>>
>>> PROV_TBL.NAME <http://prov_tbl.name/>, PROV_TBL.TYPE,
>>>
>>> DIAG_TBL.DESCRIPT, DIAG_TBL.SUBGROUP, DIAG_TBL.GROUP,
>>>
>>> PROC_TBL.DESCRIPT, PROC_TBL.SUBGROUP, PROC_TBL.GROUP,
>>>
>>> SERV_TBL.NAME <http://serv_tbl.name/>, SERV_TBL.AFFLIAT,
>>>
>>> FROM
>>>
>>> PERM.FACT_TBL, PERM.PAT_TBL,
>>>
>>> PERM.DATE_TBL, PERM.LOC_TBL,
>>>
>>> PERM.PROV_TBL, PERM.DIAG_TBL,
>>>
>>> PERM.PROV_TBL, PERM.SERV_TBL,
>>>
>>> WHERE
>>>
>>> FACT_TBL.PATIENT=PAT_TBL.PATIENT AND
>>>
>>> FACT_TBL.DATESERV =DATE_TBL.DATESERV AND
>>>
>>> FACT_TBL.LOCATION =LOC_TBL.LOCATION AND
>>>
>>> FACT_TBL.ADJUSTMENT=PROV_TBL.ADJUSTMENT AND
>>>
>>> FACT_TBL.DIAGNOS1.DIAGNOS2 =DIAG_TBL.DIAGNOS1.DIAGNOS2 AND
>>>
>>> FACT_TBL.PROCEDURE AND
>>>
>>> FACT_TBL.SERVEMD = SERV_TBL.AFFLIATE AND; RUN;
>>>
>>> PROC SUMMARY DATA = Perm.JOIN7;
>>>
>>> Class Patient Quartryr Location;
>>>
>>> VAR Charges Adjust;
>>>
>>> OUTPUT OUT=Perm.Sum7;
>>>
>>> RUN;
>>>
>>>
>>> (here is solution for part1, but not sure it is correct or not, becoz
>>> its just my own idea.)
>>>
>>> --
>>> We say, "Be one as Pakistani Nation and grow up for Pakistan's Future".
>>> Wish you all the best. Join www.vuaskari.com,
>>> To post to this group, send email to vuaskari_com@googlegroups.com
>>> Visit these groups:
>>> This (Main) Group:http://groups.google.com/group/vuaskari_com?hl=en?hl=en
>>> MIT/MCS Group: http://groups.google.com/group/vu_askarimit?hl=en?hl=en
>>> HRM Group: http://groups.google.com/group/askari_hrm?hl=en?hl=en
>>> Banking Group: http://groups.google.com/group/askari_banking?hl=en?hl=en
>>> Management: https://groups.google.com/group/vuaskari_mgt?hl=en
>>> Marketing: https://groups.google.com/group/vuaskari_mkt?hl=en
>>> MIS Group: http://groups.google.com/group/askari_mis?hl=en
>>>
>>
>> --
>> We say, "Be one as Pakistani Nation and grow up for Pakistan's Future".
>> Wish you all the best. Join www.vuaskari.com,
>> To post to this group, send email to vuaskari_com@googlegroups.com
>> Visit these groups:
>> This (Main) Group:http://groups.google.com/group/vuaskari_com?hl=en?hl=en
>> MIT/MCS Group: http://groups.google.com/group/vu_askarimit?hl=en?hl=en
>> HRM Group: http://groups.google.com/group/askari_hrm?hl=en?hl=en
>> Banking Group: http://groups.google.com/group/askari_banking?hl=en?hl=en
>> Management: https://groups.google.com/group/vuaskari_mgt?hl=en
>> Marketing: https://groups.google.com/group/vuaskari_mkt?hl=en
>> MIS Group: http://groups.google.com/group/askari_mis?hl=en
>>
>
> --
> We say, "Be one as Pakistani Nation and grow up for Pakistan's Future". Wish
> you all the best. Join www.vuaskari.com,
> To post to this group, send email to vuaskari_com@googlegroups.com
> Visit these groups:
> This (Main) Group:http://groups.google.com/group/vuaskari_com?hl=en?hl=en
> MIT/MCS Group: http://groups.google.com/group/vu_askarimit?hl=en?hl=en
> HRM Group: http://groups.google.com/group/askari_hrm?hl=en?hl=en
> Banking Group: http://groups.google.com/group/askari_banking?hl=en?hl=en
> Management: https://groups.google.com/group/vuaskari_mgt?hl=en
> Marketing: https://groups.google.com/group/vuaskari_mkt?hl=en
> MIS Group: http://groups.google.com/group/askari_mis?hl=en
>
--
We say, "Be one as Pakistani Nation and grow up for Pakistan's Future". Wish you all the best. Join www.vuaskari.com,
To post to this group, send email to vuaskari_com@googlegroups.com
Visit these groups:
This (Main) Group:http://groups.google.com/group/vuaskari_com?hl=en?hl=en
MIT/MCS Group: http://groups.google.com/group/vu_askarimit?hl=en?hl=en
HRM Group: http://groups.google.com/group/askari_hrm?hl=en?hl=en
Banking Group: http://groups.google.com/group/askari_banking?hl=en?hl=en
Management: https://groups.google.com/group/vuaskari_mgt?hl=en
Marketing: https://groups.google.com/group/vuaskari_mkt?hl=en
MIS Group: http://groups.google.com/group/askari_mis?hl=en
Comments
Post a Comment