Thank you, i don't know how really but this seems to now work and shows me the correct data. Again all we have been taught is simple PROC steps and that is it and the lecturer does not aid us if we get stuck on aspects he is expecting from us. just fyi this is what i now have and works perfectly for the assessment, i want to thank you all @PaigeMiller @Kurt_Bremser @Tom for your help. Everyone has to start somewhere right? PROC IMPORT
DATAFILE = '/home/cw2/imdb-videogames.csv'
OUT = Videogame_data
DBMS = CSV
REPLACE;
RUN;
DATA Videogame_data;
SET Videogame_data;
IF NOT MISSING(rating) AND NOT MISSING(votes) AND NOT MISSING(certificate);
RUN;
PROC SORT DATA=Videogame_data OUT=temp_videogamedata NODUPKEY;
BY name;
RUN;
DATA Videogame_data;
SET temp_videogamedata;
RUN;
data titles;
set Videogame_data;
words = countw(name,' ');
run;
PROC PRINT data=titles;
var name words;
run; Ive got to admit that i think the example on the SAS helpbook is what confused me the most so again thank you for your help 🙂
... View more