Tag: IMPORT

Import Excel data, transpose, and plot it!

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…

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…

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;&nbsp &nbsp &nbsp delimiter=’|’;&nbsp &nbsp &nbsp getnames=yes;run;