Of course you know how to create graphs … But do you often find that preparing the data to plot is often the hardest part? Well then, this blog post is for you! I’ll be demonstrating how to import Excel data into SAS, transpose the data, use what wer…
Tag: IMPORT
Import password protected EXCEL into SAS
Click Here%macro readpass(xlsfile1,xlsfile2,passwd,outfile,sheetname,getnames);options macrogen symbolgen mprint nocaps; options noxwait noxsync;%* we start excel here using this routine here *;filename cmds dde ‘excel|system’;data _null_; length fi…
Read XLS with data starts on 3rd row, and column names on 2nd row
proc import file=’C:Usersprocxsample.xls’ out=test dbms=xls replace; sheet=disposition; namerow=2; startrow=3;  …
Creating a better graph to show trade deficit
I recently saw a cool graph showing the US import/export trade deficit. But after studying it a bit, I realized I was perceiving it wrong. Follow along in this blog, to find out what the problem was, and how I redesigned the graph to avoid it. I was looking through dadaviz.com […]
The post Creating a better graph to show trade deficit appeared first on The SAS Training Post.
Define delimiter in PROC IMPORT
DSD DLM=”|” TRUNCOVER LRECL=4096 proc import datafile=”…” dbms=dlm out=… replace;      delimiter=’|’;      getnames=yes;run;