About fayyazcivil

fayyazcivil · ‎07-31-2014

Hi. Thanks for your reply. Yes it is, I just mentioned randomly .

fayyazcivil · ‎07-31-2014

Hi. I need to create a multiple array (81,81). I've 3 columns in my data. 1st and 2nd column values ranges from 1 to 81 (these are codes for Provinces) and the 3rd column shows the distance between these provinces. The data structure is like: A B C 1 2 200 1 3 500 . . . 1 81 300 2 1 100 2 3 250 . . . 81 80 1000; I need to create an array/table/matrix which is 81 by 81 and shows the distance (3rd column value) between these provinces (1st and 2nd columns values). Thanks in advance.

fayyazcivil · ‎07-07-2014

I am reading Proc Format, and let's see how it works.

fayyazcivil · ‎07-07-2014

@Reeza, yes it has 60K rows and I column. I am sorry I didn't know about that. Now I know what is array in SAS.

fayyazcivil · ‎07-07-2014

Hello. I've a column vector array 61312*1. Values ranges from 0 to 20. I need to replace the values (0 to 20) with the below mentioned values(0 to 7): 0=0, 1=1, 2,3=2, 4=3, 5,6,13=4, 7,8,9=5, 10,11,12,16=6, 14,15,17,18,19,20=7 Thanks in advance.

fayyazcivil · ‎07-06-2014

The sequence will be like this: Origin (1) Destination(1) Survey_Location(1) Interception_Pt (0 or 1) Origin (1) Destination(1) Survey_Location(2) Interception_Pt (0 or 1) ....... Origin (1) Destination(1) Survey_Location(246) Interception_Pt (0 or 1) Origin (1) Destination(2) Survey_Location(1) Interception_Pt (0 or 1) ...... Origin (2) Destination(1) Survey_Location(1) Interception_Pt (0 or 1) ......... Origin (81) Destination(81) Survey_Location(246) Interception_Pt (0 or 1) For this case rows should be 81*81*246=1614006

fayyazcivil · ‎07-06-2014

Dear Rick, Thanks for your reply. Yes I've duplication in the data i.e. origin destination pairs, which are 61312 instead of (81*81)=6561. But for this case rows should be 81*81*246=1614006 (because 246 are the number of locations where survey conducted) It will be like 4 columns: Origin, Destination, Survey_Locations(246), Interception_Pt(1 if intercepted or 0 otherwise) I am going to install SAS/IML in a few days, and will read first the "Getting Started with the SAS/IML Matrix Programming Language", then I will come back to you, via SAS/IML forum. Thanks.

fayyazcivil · ‎07-06-2014

Perfect! . Thank you very much

fayyazcivil · ‎07-06-2014

OK, thanks for this. Let me find SAS/IML software first, and then will run it.

fayyazcivil · ‎07-06-2014

Dear Tom, Yes, the above coding has worked well. Now the problem is when I run it with proc sql, the following error occurs: 415 proc sql ; 416 create table want as select a.*,b.length 417 from have left join lookup 418 on a.origin = b.origin 419 and a.destination = b.destination 420 ; ERROR: Unresolved reference to table/correlation name a. ERROR: Unresolved reference to table/correlation name b. ERROR: Unresolved reference to table/correlation name a. ERROR: Unresolved reference to table/correlation name b. ERROR: Could not expand a.*, correlation name not found. ERROR: Unresolved reference to table/correlation name b. ERROR: The following columns were not found in the contributing tables: a. 421 quit;

fayyazcivil · ‎07-06-2014

Thank you very much for this. I am very new to SAS. I don't know what is SAS/IML, I am using SAS 9.4. Kindly let me know how can I switch to SAS/IML? or it's a different software?

fayyazcivil · ‎07-06-2014

Hello. I've a matrix of order 61312*3. 1st column represent Origin (from 1 to 81) 2nd column represent Destination (from 1 to 81) 3rd column represent location of survey (1 to 246) I need a matrix of 3 columns (but rows can increased now instead of 61312), of below type; Origin Destination Location 1 1 1 1 2 2 or can be none 1 . . 1 81 246 2 1 1 . . . 81 81 246 Kindly, let me know how should I proceed.

fayyazcivil · ‎07-06-2014

Dear Tom, thank you very much for this. As you said the second table name Matrix, how can I define the Input variable in this case, i.e. origin1-origin81??

fayyazcivil · ‎07-05-2014

Hello. I have two tables. 1st order is 61312*2 (two columns i.e. origin and destination, values ranges from 1 to 81 in both columns). 2nd table is 81*81 (include length between origin and destination) Now I need to create a table having order 61312*3 i.e origin*destination*length, i.e. to write a code which take the value from 2nd matrix (length) for their respective values in 1st matrix. Kindly let me know how should I proceed.

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: Multiple Array in SAS

Multiple Array in SAS

Re: Replace values in array

Re: Replace values in array

Replace values in array

Re: Matrix or Array Arrangement

Re: Matrix or Array Arrangement

Re: Specific Table creation by properties matching

Re: Matrix or Array Arrangement

Re: Specific Table creation by properties matching

Re: Multiple Array in SAS

Multiple Array in SAS

Re: Replace values in array

Re: Replace values in array

Replace values in array

Re: Matrix or Array Arrangement

Re: Matrix or Array Arrangement

Re: Specific Table creation by properties matching

Re: Matrix or Array Arrangement

Re: Specific Table creation by properties matching

Re: Matrix or Array Arrangement

Matrix or Array Arrangement

Re: Specific Table creation by properties matching

Specific Table creation by properties matching