About Jcox22

Jcox22 · ‎02-18-2020

I'm a new SAS programmer and am currently working on a dataset thats disorganized like this: data1 var1 data2 var2 data3 var3 data1 var1 data1 var1 data2 var2 ... I was wondering if there was a pointer in sas (like @) that would allow me to point before the variable to organize the data. Thanks EDIT: Resolved

Jcox22 · ‎02-18-2020

I'm a new SAS programmer and am trying to figure out how to read in column headers for a data frame from a text file. The problem is the data look like this: Var1 Var2 Var3 Var4 Var5 Var6 1 data for 1 data for 1 2 data for 2 data for 2 ... And My output looks like this: obs Var1 Var2 Var3 1 Var4 Var5 Var6 2 1 data for 1 ... This is what I have so far any feedback I appreciate. PROC IMPORT DATAFILE= "/folders/myfolders/file.txt" out = WORK.MYOUTPUT DBMS= TAB replace; getnames = yes;

Online Status	Offline
Date Last Visited	‎02-19-2020 10:46 AM

Organizing Messy Data

Reading in column names from txt on multiple rows

Organizing Messy Data

Reading in column names from txt on multiple rows