Monday, April 10, 2017

Map with R



How it really works in R ggplot2 


http://eriqande.github.io/rep-res-web/lectures/making-maps-with-R.html

You need to create data in following format:

                long      lat        group order region subregion
#> 1 -101.4078 29.74224     1     1   main      
#> 2 -101.3906 29.74224     1     2   main      
#> 3 -101.3620 29.65056     1     3   main      
#> 4 -101.3505 29.63911     1     4   main      
#> 5 -101.3219 29.63338     1     5   main      
#> 6 -101.3047 29.64484     1     6   main      


Some useful packages


  • ggmap
  • googleVis







Sunday, April 9, 2017

Teradata Tutorial




Import CSV file as a table in Teradata


1. First create the table you want with the structure of the file.

Create table dp_cad_analtyics.A
(
Testcol1 varchar(20)
, Testcol2 varchar(20)
);

2. Then modify the below query accordingly so that the number of question marks are equal to the number of columns

Insert into dp_cad_analytics.A
Values
(?,?);


3. Select the option of "import data" from the "File" menu and execute query. It will ask for the file.




Wednesday, March 22, 2017

SAS tutorial


SAS Tutorial



SAS E-Guide


1. Library Creation

Create a program and write following command:

libname tanvir '/sasdata2/SAS-USERS/taaalam/';





2. Import File into Library

File > Import Data >  Select Local File >  Output SAS data set (  use SAS server and Library name that you created in step 1 )




SAS E-Miner


1. Map Libraries in SAS Miner (Let E-miner knows the library you created in E-Guide)

File > New > Library


2. Bring Files under "Data Source"

Right click "Data Source" > "Create Data Soruce"